Please do not top-post.
Bèrto ëd Sèra wrote:
An immediate question: did you check that Key (docuuserid)=(8415) is
actually present in table "trade"?
Ljubomir Erdeljan wrote:
> This relate to different column names
> docuuserid is column in porder1 but relate to tradeid in trade.
You missed
This relate to different column names
docuuserid is column in porder1 but relate to tradeid in trade.
Thank you,
On 05/09/2010 22:40, Bèrto ëd Sèra wrote:
An immediate question: did you check that Key (docuuserid)=(8415) is
actually present in table "trade"?
Bèrto
On 5 September 2010 23:17,
An immediate question: did you check that Key (docuuserid)=(8415) is
actually present in table "trade"?
Bèrto
On 5 September 2010 23:17, Ljubomir Erdeljan wrote:
> hi group,
>
> trying to create foreign key:
>
> ALTER TABLE porder1 ADD CONSTRAINT order_exist
> FOREIGN KEY (docuuserid) REFERENCE
On 5 September 2010 22:17, Ljubomir Erdeljan wrote:
> hi group,
>
> trying to create foreign key:
>
> ALTER TABLE porder1 ADD CONSTRAINT order_exist
> FOREIGN KEY (docuuserid) REFERENCES trade(tradeid) ON DELETE RESTRICT;
>
> column docuuserid is integer in porder1
> column tradeidis serial
hi group,
trying to create foreign key:
ALTER TABLE porder1 ADD CONSTRAINT order_exist
FOREIGN KEY (docuuserid) REFERENCES trade(tradeid) ON DELETE RESTRICT;
column docuuserid is integer in porder1
column tradeidis serial in trade and belong to primary key (single
column)
getting In E
hi.
i have a big problem...
i have created a 2 table cumacar and cumaasi,
the structure is
CUMACAR
cuidcar char(2)
cucodcar numeric(2)
cudescar varchar(35)
cuempcar numeric(2)
primary key (cucodcar, cuempcar)
CUMAASI
cucodasi numeric 3
cudesasi varchar 60
cucarasi numeric 2
cuemp
