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!!
Previous
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