General information
Category:
Coding, syntax & commands
This will only work in a single table circumstance. When you need to get the record numbers of all records that meet the condition you can:
SELECT RECNO() AS rn FROM sometable WHERE condition_is_met
>hey everyone,
>i am trying to select a dbf alias in some code i am writing. what i want it to do after i have selected it is search for a condition in the table and then point to the row where the condition is met. here is what i have so far.
>
>select alias
>scan for column condition = desired condition
>
>what i do not know how to point to the row after the condition is met. can anyone help me with this dilema? 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