Hi List,
I'm a bit stuck now, hope someone can point me to the right direction.
I'm trying to use the Function "TRIM()" in an SQL Statement
(REALSQLDatabase / SQLite). According to
http://www.sqlite.org/lang_expr.html there should be a rtrim, ltrim and
trim function each with one or two parameters (second denotes what to
trim). In addition to this (and somewhat in contrast, too) in the
Language-Reference (PDF Version) Section SQL Functions (p. 943 in 2007r2
- 869 in 2006r2) I find the TRIM function, too but with a different
Syntax: TRIM (LEADING|TRAILING|BOTH [trimstring] FROM targetString)
Nevertheless - whatever I tried I always get a "no such function: trim"
error message instead of the expected result. I tried it with a 2006r2
and 2007r2 in a very streamlined test project:
rs = db.SQLSelect("SELECT TRIM(' test ');")
rs = db.SQLSelect("SELECT LTRIM(' test ');")
rs = db.SQLSelect("SELECT RTRIM(' test ');")
rs = db.SQLSelect("SELECT TRIM(BOTH FROM ' test ');")
rs = db.SQLSelect("SELECT TRIM(BOTH ' ' FROM ' test ');")
Is this function broken? I could not find a Ticket in the
Feedback-System regarding this issue. Or do I something wrong?
Regards
Tobias
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
