Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use generated primary keys ?
Message
From
09/05/2000 09:52:28
Walter Meester
HoogkarspelNetherlands
 
 
To
09/05/2000 08:21:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00367063
Message ID:
00367621
Views:
57
Graig,

>It won't happen because it would break *LOTS* of existing code. The VFP team is very, very careful about what they remove.

Because I don't know the internal code of VFP, the following is only ment as speculation:

SET SPECULATION ON

The wish means that VFP should ignore deleted records in all cases determined by a setting or a tableproperty.

I assume there is a routine that is used to read records from the table. Depended of the SET DELETE, and the sort of the calling command (like INDEX, which does not respect the SET DELETED setting), it passes the record to the calling routine/command.

The enhancement would mean that this routine should be modified: It should work with one extra parameter which determine if deleted records should be ignored or not. If the ignore parameter is set, it just skips deleted records (just like the SET DELETED ON behavour) regardless of the SET DELETED setting or calling routine/command.

If this can be implemented this way, there is no need to break other existing code. All DML commands and the rushmore mechanism automaticly are scoped to non-deleted records.

SET SPECULATION OFF

Since this is pure speculation and neither you nor me know the internal coding, we both don't know how much work this requires to implement this wish.


Why do you think all the old FoxBase/2x screen stuff still works?

Not all Fox2.x features still work ! For example the READ command has lost a few of it's clauses.

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform