>>>>>Hi Erik,
>>>>>yes, a bit different question, however on the same idea. The syntax error wasn't from the report . . . the report is small, and I combed it thoroughly.
>>>>
>>>>What line throws the error? Where are you running this SQL from? BTW, you probably want to use the INTO CURSOR clause here to prevent a browser window from opening when the query completes.
>>>
>>>
>>>public gdValue
>>>gdValue = Thisform.gd1.displayvalue
>>>
>>>public szValue
>>>szValue = Thisform.sz1.displayvalue
>>>
>>>select bundle,length,grade,siz,shipdataid; <-- This Line Erik
>>>from data1;
>>>into cursor 2ft; <-- Into Cursor
>>>where grade . . .
>>
>>You can't name a cursor beginning with a number. Character or underscore only.
>
>
>Yeah, I figured that out about 5 minutes ago . . . now the report runs but gives the wrong information. There are 6 test records in this database. The report spits out 6 rows, but the ID number of each row is the same (and turns out to be the 1st ID number 6 times).

Have you verified that your cursor is getting created properly? After you run the query, use the datasession window to browse the cursor.

If the cursor is correct, but the report shows the same record 6 times, you'll need to ensure that the correct table is selected before calling the report.