Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record no in SQL?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00340444
Message ID:
00340742
Views:
28
>>>is the meaning that if i didn't use recno() in join condition "sql-select"..
>>>then no any unpredicted result will come out?!
>>
>>No, it means if you have two or more tables involved in a SQL-SELECT, then you can't use RECNO() at all. Specifying an alias as it's paramater does not work with a SQL-SELECT.
>
>You should never use Recno with SQL. Only PKeys!
>
>__Stephen

Only if ya got 'em, you can!
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform