> -----Ursprüngliche Nachricht----- > Von: Beermann, Albert [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 2. November 2005 10:50 > An: [email protected] > Betreff: SQL-Syntax ????? > > Hello Everbody > > I have 3 tables > Rbobjekte with rbobjekteid as primary key = structured > data > Rbobjektpos with rbobjektposid as primary key and rbobjekteid = detail > information of rbobjekte > Rbaplposausf with rbaplposausfid as primary key and rbobjektposid = > detail information of rbobjektpos > > I have a dbproc creates a cursor ergebnis with all rbobjekteid from > rbobjekte for a special structure > > Now i want to update all the records of rbaplposausf belonging to all > the rbobjektpos records belonging to all the rbobjektid in ergebnis > > I do: > Call dbproc .. > > Update rbaplposausf set rbaplposausf.rbrevierid = ?l_wert where > rbaplposausf.rbobjektposid in (select rbobjektpos.rbobjektposid from > rbobjektpos where rbobjektpos.rbobjekteid in (select rbobjekteid from > ergebnis)) > > Close ergebnis > > The update command fails with : missing delimiter > > Can someone help me with the correct syntax for the update commands > > Any help or ideas welcomed
Did you really write ?l_wert ?? With SQL a parameter has to be specified like this: <parameter_name> ::= :<identifier> | ? And in dbprocs only :identifier will help. Outside dbprocs it depends on the client (JDBC/ODBC/...) what can be used in which context. If this update is outside the dbproc, I do not see the need for preparing 'ergebnis' as it will not be used furthermore and therefore I do not catch the problem really. Elke SAP Labs Berlin > > Best regards > Albert > > ''''' > ''''''''' > (0 0) > +---------oOO-----------(_)------------------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] | > | Internet: http://www.piepenbrock.de | > +--------------------------------------oOO---------------+ > |__|__| > || || > ooO Ooo > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
