Hi Tim, thanks for your confirmation. After some rather complex investigation, I created a Bug-Report for this. I invite you to sign on to them:
A lot of documented SQL-Functions are not available http://www.realsoftware.com/feedback/viewreport.php?reportid=bawfdmxf There are also some documentation errors regarding SQL Functions, which I've reported here: A lot of errors in documentatin of REALSQLDatabase's SQL Functions http://www.realsoftware.com/feedback/viewreport.php?reportid=yaenpawq and - especaially for TRIM(): REAL SQL Database - SQL Functions - TRIM Example incorrect http://www.realsoftware.com/feedback/viewreport.php?reportid=vjswapqo regards Tobias Tim Hare wrote: > 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> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
