Grid Fields Undefined

Applications Grid / Reports
, ,
#1

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

#2

Please disregard, found the problem.

Thankyou

#3

What was the problem? please share

#4

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)