Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 101 - 2 questions
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00674789
Message ID:
00674966
Views:
22
Ashley,

I'm glad to help.

The where clause is one that can never evaluate to true, so no records would be returned, but the structure will be established. This works well when you are trying to get structures from a backend too.

>Once again, thanks (guess I was missing the table keyword).
>Both examples worked perfectly.
>Didn't understand the 1=2, unless that was just a bogus clause to get a 0 record result (I assumed that a 0 result would not create anything).
>
>As in past occasions, thanks againg for your guidance and effort!
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform