Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use this in select - SQL
Message
From
30/03/2006 13:22:46
Tore Bleken (Online)
Vear, Norway
 
 
To
30/03/2006 13:20:56
Sergey Sizov
Belarus
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How to use this in select - SQL
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01108273
Message ID:
01109272
Views:
26
>>IF USED('myTable')
>> SELECT ('myTable')
>>ELSE
>> SELECT 0
>>ENDIF
>>USE myTable
>
>
>USE myTable IN IIF(USED('myTable'), 'myTable', 0)
>
Even simpler
USE myTable IN select('myTable')
Gone phishing

How to create sample data
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform