Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record no in SQL?
Message
From
02/03/2000 07:21:24
 
 
To
02/03/2000 02:07:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00340444
Message ID:
00340462
Views:
31
>i hv a table and i want to use SQL to filter out some record by record no.
>example:
>i want to put record number 10 to 20 from table A into cursor B
>can SQL specify the record number that in range 10 to 20 ???


Using RECNO() in a SQL SELECT statement produces unpredictable results. This is documented in Help. This is one more reason to use Primary Keys.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform