Gary,
>>Primary key will work just fine with free tables<<
I have the PrimaryKey() working with free tables just like you said. However, after studying the PrimaryKey() code, it appears that it doesn't do a re-synch the first time it is called like it does with a primary index type.
What brought this problem up was importing data from another table. As an example, if the other tables index key I was going to use was type numeric and the first record had a value of 5, and the last record had a value of 9,999 - you would think the first key it would increment would be to 10,000. However, it started with 1 - which is OK. However, after adding 5 records it then created a duplicate key for 5 (if it was a regular index, or would give me the uniquness warning if candidate index).
Any suggestions on how to handle this when you are importing records using the PrimaryKey() function.
Thanks,
Mel Cummings
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only