Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict
Message
From
08/01/2001 20:39:59
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00459687
Message ID:
00460936
Views:
13
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform