General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>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).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only