| From: | "J(dot) 'FIK'Brand" <jurgen(dot)brand(at)tip(dot)nl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org(dot)pgsql-interfaces(at)postgresql(dot)org |
| Subject: | ODBC, Access and foreign key (part 2) |
| Date: | 2000-12-21 11:16:17 |
| Message-ID: | 91soml$iql$1@news.tht.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2000-12-21 11:18:55 | Re: Best way to replicate a DB between two servers (master/slave) |
| Previous Message | Alessio Bragadini | 2000-12-21 09:46:33 | red hat/mysql fiasco |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2000-12-21 15:18:20 | Problems with int8 and MS ADO/ODBC |
| Previous Message | Bernard ISAMBERT | 2000-12-21 11:05:42 | Problem with ecpg and 7.1beta1 |