Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict
Message
From
07/01/2001 21:10:17
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00459687
Message ID:
00460379
Views:
10
Good monring.. sorry to disturb u again.

I find the strange behaviour :

if I use INSERT INTO command, the base table will auto generate new ID eg:

INSERT INTO viewPO (keyInDate,keyinBy) WITH (DATETIME(),userID)

the viewPO have PK value 1 and
the PO have PK value 2

IF I use APPEND command then it work ok, eg,

SELE viewPO
APPEND BLANK
REPL keyInDate WITH DATETIME(),;
keyInBY WITH userID

then viewPO have PK value 1 and
PO have PK value 1

Why??
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform