>
>A SQL-Select into a cursor will not create an empty cursor if no records match your criteria. Any actions upon the non-existing cursor will produce errors.>
>That's not true. SQL-Select creates cursor always, even when zero records are returned.
>
>
>I use _tally after the select to determine if a cursor was created but, elseware in the application I need to perform actions upon the cursor but, I don't know a command in Foxpro to ask "Does the cursor exist at all?", like type() for memory varibles. Can anyone help?Sergey,
You're right on this one. I guess John does a SQL-Select into an array. In that case, suppose the array name is laResult, then this test might be performed.
if type( 'laResult[1]' ) # 'U'
endif
One might also declare the array in advance, just to prevent problems due to its non-existence.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.