Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update conflict
Message
De
08/01/2001 20:39:59
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00459687
Message ID:
00460936
Vues:
14
Thanks for reply.

I use a table call newkey.dbf and field nextkey to record next pk and view pk is default value same to base table.

If I use append and replace command the nextkey will only +1
But if I use insert command the nextkey will +2

eg.

append blank & replace
view id = 1
base table id = 1
newkey = 2

insert
view id = 1
base table id = 2
newkey = 3

Why?

Further, If I add the record (append blank), and save it (tableupdate) and delete it immediately,

SELE view
=TABLEUPDATE()
SKIP

system will prompt me update conflict too, it need to

SELE view
DELE
SELE basetable
GO TOP
SELE view

to delete the record. ?????

TIA.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform