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
>
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
