Thread: ODBC, Access and foreign key (part 2)

ODBC, Access and foreign key (part 2)

From
"J. 'FIK'Brand"
Date:
Here are the ODBC-log from the workstation and the log from the server.

ODBC-log :

MSACCESS        fffcb265-fffef419 ENTER SQLExecDirectW
  HSTMT               08592424
  WCHAR *             0x07D7AF60 [     126] "INSERT INTO c0011 VALUES
('WM4100340000',0,'23006000','410034',1,1,Null,39.31,0,Null,0,'STUKS',2,1,1,
0,0,0,'410034',Null,Null)"
  SDWORD                   126

MSACCESS        fffcb265-fffef419 EXIT  SQLExecDirectW  with return code 0
(SQL_SUCCESS)
  HSTMT               08592424
  WCHAR *             0x07D7AF60 [     126] "INSERT INTO c0011 VALUES
('WM4100340000',0,'23006000','410034',1,1,Null,39.31,0,Null,0,'STUKS',2,1,1,
0,0,0,'410034',Null,Null)"
  SDWORD                   126


Server-log

Dec 21 11:53:47 obelix logger: ERROR:  <unnamed> referential integrity
violation - key referenced from c0010 not found in c0030

Thanks Jurgen