Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record pointers on empty cursors/tables
Message
 
 
To
02/02/2004 09:46:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00872917
Message ID:
00872933
Views:
16
I would simplify it a little bit
IF NOT EMPTY(cAlias)
    SELECT (cAlias)
    IF BETWEEN(nRecNo, 1, RECCOUNT())
        GOTO (nRecNo)
    ENDIF 
ENDIF 
>>It's not going to work because RECNO() = 1 for empty table/cursor.
>>
>Hi Sergey;
>
>Is there anything wrong with my code ?
>
>
>cAlias = ALIAS()
>
>nRecNo = RECNO()
>
>
>*Do Something
>
>
>if  empty(cAlias)
>else
>    SELE (cAlias)
>    if  nRecNo <> 0 .and. nRecNo =< reccount()
>        GOTO nRecNo
>    endif
>endif
>
>
>I'm asking you because.. IMO, this is the right stuff for Jay.. Don't you thing so ?
>
>Claudio
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform