LiveCode Forums.

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?

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.

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

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.

Ah. Thanks, Jan.