TSQLconector | PostgreSQL | Error insert master-Detail
lazarus / 16-Databases

----------------------------------------------------------------------
cpalx · 2014-07-18 16:19

Hello,
i am using :
Lazarus 1.2.4 (32bits)
FPC : 2.6.4
Revised SVN : 44758
Windows 8.1 (64bits)
Database : PostgreSQL 9.3

i have a program using Zeos, but by last zeos bug i am changing to
TSQLconector. All was ok until i was testing save a master-detail: the
SQL query is:

======
insert into stcentrocosto(cecoid,ceconombre,cecofechini,trabid,cecocod
igo,emprid)values('18','AF-334','18/07/2014','5','SMCECO-0016-
root14','18');
insert into sttrabceco(cecoid,trabid)values('18','8');
insert into sttrabceco(cecoid,trabid)values('18','0');
======

this work fine in Zeos, not in TSQLconector, because display the
error:

=======
Severity: Error
SQL state: 23503
Error Detail: (cecoid)=(18) is not present in table <<stcentrocosto>>
=======

but  i am inserting at first line

maybe some transaction fetuare missing

any idea??'