In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
> Andrej Falout wrote:
> >>'Who''s Online'
> > So, single quote is escape character?
> 
> No, it just works to insert single quotes.

And what exactly _IS_ escape character then? How do I insert a double quote?

'xxx"xxx'
 
Is there anything else that I should watch for? Anything in the manual?

> > And this would work:
> > 
> > "This is the '"Title'" of the book" 
> 
> String literals have to be enclosed in single quotes, double quotes are 
> used for identifiers.

Just an observation: Small things that are a de facto standard across 95% of 
database systems and programing languages, like backslash is escape character, 
and ; is SQL statement delimiter (in SAP DB one has to use empty line starting 
with comment: // and AFAIQ there is no statement terminator/delimiter of any 
kind) can cause a _lot_ of pain especially for people porting existing code to 
SAP DB.

Is there any chance that a more common (dare I say "standard") behaviour can be 
adopted for SAP DB? It would help adoption of SAP DB a lot, in my opinion?

Thanks,

-- 
Yours, Andrej Falout, http://www.falout.com/disclaimer.html
Visit the OpenSource alternative, Aubit 4gl: http://aubit4gl.sourceforge.net
PLEASE NOTE: All HTML email sent to me WILL BE DELETED AUTOMATICALLY WITHOUT 
READING.


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to