Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use generated primary keys ?
Message
De
09/05/2000 09:52:28
Walter Meester
HoogkarspelPays-Bas
 
 
À
09/05/2000 08:21:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00367063
Message ID:
00367621
Vues:
56
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,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform