Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Surrogate Keys - Have I got the right idea
Message
From
15/01/2001 01:54:26
Walter Meester
HoogkarspelNetherlands
 
 
To
14/01/2001 10:27:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00434523
Message ID:
00463661
Views:
24
Hi Mark,

>Basically all it did was attempt to find a deleted record. If it finds one it would blank the record and lock it.
>If it couldnt find one it would insert a new record and lock it.
>
>Since I am now doing everything via views I now am scratching my head wondering if it is going to be possible to recycle deleted records at all.
>
>The function would first have to check that the view was based on a normal VFP table (if it isn't it just does an insert and returns)
>
>If it is based on a VFP table, then it would have to find a deleted record in the base table and add it to the current view. Then it would have to blank it and lock it.
>
>Can you see anything in the above that would stop attempting this?

Unfortunately not. You've got to write your own code to recycle records and using localviews and reclycling records is very difficult to write. I've submitted a VFP.next wish that VFP is able to do this automaticly (via a table property) but unfortunately it is not implemented (yet).

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform