Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record pointers on empty cursors/tables
Message
 
 
To
02/02/2004 09:32:48
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00872917
Message ID:
00872924
Views:
19
It's not going to work because RECNO() = 1 for empty table/cursor.

>Yeah, that's pretty much what I thought I would have to do... So, I guess the real issue is that RECNO() is NULL if the table is empty? It has no actual value? Hmmm... I could see cases where RECNO() could be -1 though in the case of added records in a buffer. Maybe the best way would be to check if nRecNo is NULL rather than > 0.
>
>>Hi Jay
>>
>>This modification should do the trick:
>>
>>cAlias = ALIAS()
>>
>>nRecNo = RECNO()
>>
>>Do Something
>>
>>SELE (cAlias)
>>
>>IF nRecNO>0
>>   GOTO nRecNo
>>ENDIF
>>
>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform