Attaching a Query To a List Field

Mikey · Post by **Mikey** » Sun Jun 29, 2008 5:13 am

I posted this to the mailing list, but no response yet.

I was messing around with the Query Builder just to see if letting Rev handle some of the work was worth it. So as part of that I built a list field and tried to attach several columns from a table to the field. However, the field never updated and was always empty.

If I attached the SAME query to several fields, one column per field, everything worked fine.

Suggestions?

Janschenkel · Post by **Janschenkel** » Mon Jun 30, 2008 12:45 pm

Hi Mikey,

A couple of questions:
- which Rev version?
- which platform and version?
- which database type are you connecting to?
- are you using a list field or a table field?
- what is the SQL query in the automated builder?

Jan Schenkel.

Mikey · Post by **Mikey** » Mon Jun 30, 2008 1:59 pm

which Rev version?
2.9.0

which platform and version?
XP/SP3

which database type are you connecting to?
ODBC

are you using a list field or a table field?
Table field. As you are aware, list fields cannot receive multiple columns

what is the SQL query in the automated builder?
SELECT * FROM DEDUCTION

Janschenkel · Post by **Janschenkel** » Mon Jun 30, 2008 5:27 pm

Thanks for the extended information. If you're using ODBC, the problem may be that the driver supports just forward-only cursors.
Try ticking the checkbox "Cache record set" in the Database Query Builder.

Jan Schenkel.

Mikey · Post by **Mikey** » Mon Jun 30, 2008 5:39 pm

Ah. Thanks, Jan.