This appears to be a problem with SQLite itself. Using their sqlite3.exe command line query tool, I get the same errors: no such function.
Tim > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Tobias Bußmann > Sent: Wednesday, April 11, 2007 11:30 AM > To: [email protected] > Subject: REALSQLDatabase / SQLite and Trim > > > 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> > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.446 / Virus Database: 269.2.0/756 - Release Date: > 4/10/2007 10:44 PM > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.2.0/756 - Release Date: 4/10/2007 10:44 PM _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
