Hi Elke, thanks for the prompt answer. It works on the 7.4 Server, but not on the 7.3.0.20 :-((
But: Do I have to use this declare - stuff for every Statement? I was thinking about using SAPDB in ansi mode as a replacement of a SQLServer connecting using ODBC. But the String concatenation is different, too. ( "||" instead of "+") Or can that be changed? Regards, Manfred *------------------- Elke Zabach wrote: >DECLARE <cursorname> CURSOR FOR >select ... from ... >should help > >Elke >SAP Labs Berlin *------------------- Manfred Panter wrote: > > Hi, > I wanted to test SqlMode ANSI and came across a problem using > it with the sqlstudio (7.3.1 and 7.4) running against a 7.3 > (linux) and 7.4 (win2k) server: > When I run any select, like > "select * from article" > I get this error > > -3008 > Syntax error or access violation;-3008 POS(10) Invalid > keyword or missing delimiter. > [ODBC] [37000] Syntax error or access violation > > And it points to the "FROM" in the select. I am not able to > get one single select statement running :-( > > Do I have to set up some special things when running in > SQLMode Ansi. I just couldn't find anything on the board or > in the doku. ________________________________________________________________ Mit der Grupppen-SMS von WEB.DE FreeMail k�nnen Sie eine SMS an alle Freunde gleichzeitig schicken: http://freemail.web.de/features/?mc=021179 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
