Grid Fields Undefined

Hi,

I have a sql statement with a couple joins which runs fine in PhpMyAdmin. When I use the statement in the SQL box for my grid in ScripCase, I get the error “Grid Fields Undefined”. Similarly, if I use SQL Builder and select the tables, fields, and joins I get the same error.

I’m not using the SQL Prepare, just the SQL Select Statement box of the grid sql settings.

Any thoughts much appreciated.

Lyle

Please disregard, found the problem.

Thankyou

What was the problem? please share

If it append to someone else, check your SQL Select for syntax Error.

Also check if you have field that will be displayed (Field positioning)