Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor substituir tabela do data environment
Message
From
23/05/2003 08:11:51
 
 
To
22/05/2003 07:40:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00791531
Message ID:
00792136
Views:
25
This message has been marked as a message which has helped to the initial question of the thread.
Pedro;
>
>IF && deves usar o cursor
>
> SELECT * FROM WHERE ... INTO CURSOR && ou table temporária
>
> && como faço para que o VFP , pense que esta tabela , é a mesma que está no data environment , e
> que esqueça a que está no data envirronemt , e use esta ?
>
>ENDIF

Você pode decidir.. Fazendo o SQL somente se:
IF USED("MINHATABELA")
   sele minhatabela
   use
   SELECT * FROM WHERE ... INTO CURSOR minhatabela
endif
..Ou então, você pode decidir abrir sua tabela somente se:
SELECT * FROM WHERE ... INTO CURSOR xy
if  _tally > 0  && foi processado algo
    sele minhatabela
    use
    SELECT * FROM WHERE ... INTO CURSOR minhatabela
endif
Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Previous
Reply
Map
View

Click here to load this message in the networking platform