Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing nos in a table where index is in sequence
Message
From
30/04/2008 11:16:12
Joseph Mathai
Keyword-Tec Services
Bangalore, India
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Missing nos in a table where index is in sequence
Miscellaneous
Thread ID:
01314210
Message ID:
01314210
Views:
53
Hi,

I have a table with a about 40,000 - 50,000 records, with key field SLNO in order, is there any quicker way of finding out any missings nos in between , other than running a scan on the table and comparing with the counter.
Next
Reply
Map
View

Click here to load this message in the networking platform