Elke, of course I can :-) After running the command I get the Error
General error;-4000 POS(1) Unknown result table. [ODBC] [S1000] General error Error points to "DECLARE" The Version of sqlstudio is 7.3.1.0 > Can or could: yes and no, the decision for the correct datatype, > especially combined with the implicit conversion between number > and character as in sqlmode Oracle, would be - nice -, > think of '123' + 7 --> '1237' or 130. > > Planned: no It's a pity to hear that. Hope that helps, if you need more, let me know. Manfred "Zabach, Elke" <[EMAIL PROTECTED]> schrieb am 06.06.03 11:35:05: > > Manfred Panter wrote: > > > > Hi Elke, > > thanks for the prompt answer. > > It works on the 7.4 Server, but not on the 7.3.0.20 :-(( > > Oops, what happens/which error/wrong or no result? > I do not remember a problem concerning that topic. > Please provide some more info. > > > > > > But: Do I have to use this declare - stuff for every > > Statement? > > In front of every SELECT-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? > > > Can or could: yes and no, the decision for the correct datatype, > especially combined with the implicit conversion between number > and character as in sqlmode Oracle, would be - nice -, > think of '123' + 7 --> '1237' or 130. > > Planned: no > > Elke > SAP Labs Berlin > > > > 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 > > > > ________________________________________________________________ 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
