Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>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).
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement