Hello,
I cannot confirm this error in my environment. Are you shure the tables doesn't exist
before you execute the program? I've got this error if I run the program twice,
because in the second run the tables already exist. To be sure add a DROP TABLE to the
main function of the test.
int main (int argc, char *argv[])
{
...
if (Connect(argv[1],argv[2],argv[3],argv[4])) { exit(1);}
EXEC SQL DROP TABLE X;
EXEC SQL DROP TABLE Y;
if (Update("create table X(f integer)")) { RollBack(); goto disconn;}
if (Update("create table Y(f integer)")) { RollBack(); goto disconn;}
...
}
When the error still occurs please send me vtrace
(http://sapdb.2scale.net/moin.cgi/VTrace) and/or Precompilertrace (environment
variable SQLOPT=-X) if possible.
Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: Claus-Thomas Buhl [mailto:[EMAIL PROTECTED]]
> Sent: Donnerstag, 28. November 2002 14:33
> To: [EMAIL PROTECTED]
> Subject: Problems creating more than one table in ESQL program
>
>
> I am hereby reposting what I submitted to this list 3 weeks ago.
>
> The appended ESQL program creates 2 tables X and Y.
> During creation of the second table the following error occurs:
>
> Duplicate table name:Y(22) Errorcode = -6000, ISAM = 0
>
> This is strange since the table Y does not exist.
>
> Furthermore, dropping multiple tables or creating/dropping
> multiple synonyms also doesn't work.
>
> We are using SAP DB 7.3.00.24 on Debian Linux 3.0 (woody).
>
> Any glues?
>
> Regards,
>
> CTB
> --
> _______
> \o/|\o/ Claus-Thomas Buhl
> | Diplom-Informatiker
> \_____/ mailto:[EMAIL PROTECTED]
>
> H.E.I. GmbH | Wimpfener Strasse 23 | D-68259 Mannheim
> Fon: +49-(0)621-795141 | Fax: +49-(0)621-795161 | mailto:[EMAIL PROTECTED]
> http://www.h-e-i.de && http://www.hei.biz && http://www.radpage.com
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
