Not quite clear what 'value' you want to get from the table.
Select statement returns the * set from table. If you need to know how many records collected, then:
select.....
nThis=_tally
>I'm running a SQL statement to get a value from a table (a number).
>Is there any way that I can assign the return of the sql statement to a variable?
>
>ie: nThis = SELECT * FROM tblKeyCounter
>
>There's only ever one record in that table... so it can only ever return one value.... but how do I assign that return to a variable?
>
>Thanks!!
Précédent
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