General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only