Subject | Embedded SQL error |
---|---|
Author | Mike Baker |
Post date | 2004-05-25T17:08:16Z |
Hi all, thanks for helping me with my previous gpre question. Now I have
another. Here is my setup;
I have created a Database with some tables.
I have created an embedded SQL source file that connects to the database and
does a simple insert.
My insert statement looks like this;
Load values into host variables.....
EXEC SQL
INSERT INTO DESCRIP_TAB
VALUES (:szCBCabId,
:lIDSeqNum,
:szIDFieldId,
:szIDFieldName,
:szIDConstDat);
gpre reports the following error message;
TABLE DESCRIP_TAB is ambiguous
There are no other additional error codes and I cannot find any
documentation describing this error. I have verified that the table and all
of its columns do exist.
Can someone enlighten me as to what this error message means or where I
might find a description for it and how to resolve the problem?
Thanks,
Mike
another. Here is my setup;
I have created a Database with some tables.
I have created an embedded SQL source file that connects to the database and
does a simple insert.
My insert statement looks like this;
Load values into host variables.....
EXEC SQL
INSERT INTO DESCRIP_TAB
VALUES (:szCBCabId,
:lIDSeqNum,
:szIDFieldId,
:szIDFieldName,
:szIDConstDat);
gpre reports the following error message;
TABLE DESCRIP_TAB is ambiguous
There are no other additional error codes and I cannot find any
documentation describing this error. I have verified that the table and all
of its columns do exist.
Can someone enlighten me as to what this error message means or where I
might find a description for it and how to resolve the problem?
Thanks,
Mike