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:
00340736
Views:
29
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform