Hi Stefano,
"at the end of the statement" isn't precisely right.
Separate the statements with lines containing nothing else but a
comment ('//' comment sign at the beginning) :
CREATE TABLE prova1 (odc_volontario_id INTEGER)
//
ALTER TABLE prova1 ADD ( PRIMARY KEY (odc_volontario_id) )
//
<other stmt>
//
...
should work.
BTW, this is exactly what the SQL Studio documentation says :
"To separate SQL statements from one another, specify a separator line. To be
identified as a separator line, the line must start with //. "
regards,
Markus Stausberg
SAP Labs Berlin
-----Original Message-----
From: Stefano Mainardi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:01 AM
To: Stausberg, Markus
Subject: RE: SQL Studio 7.4 and multiple SQL Statements
when I give:
CREATE TABLE prova1 (odc_volontario_id INTEGER) //
ALTER TABLE prova1 ADD ( PRIMARY KEY (odc_volontario_id) )
SQL Studio issues:
Syntax error or access violation;-3014 POS(49) Invalid end of SQL statement
I tryed other combination of ";" and "//" but the message remain the same.
where is the problem?
thanks
Stefano
-----Original Message-----
From: Stausberg, Markus [mailto:[EMAIL PROTECTED]]
Sent: luned� 6 gennaio 2003 9.13
To: Stefano Mainardi
Subject: RE: SQL Studio 7.4 and multiple SQL Statements
Hi Stefano,
you wrote :
> I tried to make a sql sript run to create tables for a simple test DB; it included
> drop,create and alter table statements; to make SQL Studio 7.4 to execute multiple
> statements I followed the instructions I got on the relevant manual for the 7.3
> version (I have found none for the 7.4) , i.e. I used comments "\\" at the end of
>each
> statement.
> Nevertheless it didn't work.
could you be a bit more specific here, e.g. what error messages did you get ?
an (excerpt from) the script woulsd also be helpful.
regards,
---
Markus Stausberg
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
