Re: [sqlite] ltrime() and rtrim() not understood with ODBC?
Ahh, that's it. On the ODBC driver information page I see "So far it has been tested with SQLite 2.8.17 and SQLite 3.3.13" Darn! Thanks Joe! On 8/3/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release. > > http://www.sqlite.org/cvstrac/chngview?cn=3698 > > What sqlite version is your ODBC driver? > > select sqlite_version(); > > --- Mitchell Vincent <[EMAIL PROTECTED]> wrote: > > If I use sqlite3.exe to execute the query "Select > > customer_id,customer_number FROM customers where customer_number != > > rtrim(customer_number);" it works great but as soon as I run that > > query through using the SQLite ODBC driver (using the latest > > available) I get "no such function: rtrim (1)" > > > > I thought at first that maybe sqlite3.exe just had extra extension > > functions compiled in but http://www.sqlite.org/lang_expr.html says > > ltrim and rtrim are "core". > > > > Is there something I have to do to get ltrim/rtrim to work over ODBC? > > > > > > Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for > today's economy) at Yahoo! Games. > http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] ltrime() and rtrim() not understood with ODBC?
rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release. http://www.sqlite.org/cvstrac/chngview?cn=3698 What sqlite version is your ODBC driver? select sqlite_version(); --- Mitchell Vincent <[EMAIL PROTECTED]> wrote: > If I use sqlite3.exe to execute the query "Select > customer_id,customer_number FROM customers where customer_number != > rtrim(customer_number);" it works great but as soon as I run that > query through using the SQLite ODBC driver (using the latest > available) I get "no such function: rtrim (1)" > > I thought at first that maybe sqlite3.exe just had extra extension > functions compiled in but http://www.sqlite.org/lang_expr.html says > ltrim and rtrim are "core". > > Is there something I have to do to get ltrim/rtrim to work over ODBC? Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] ltrime() and rtrim() not understood with ODBC?
If I use sqlite3.exe to execute the query "Select customer_id,customer_number FROM customers where customer_number != rtrim(customer_number);" it works great but as soon as I run that query through using the SQLite ODBC driver (using the latest available) I get "no such function: rtrim (1)" I thought at first that maybe sqlite3.exe just had extra extension functions compiled in but http://www.sqlite.org/lang_expr.html says ltrim and rtrim are "core". Is there something I have to do to get ltrim/rtrim to work over ODBC? Thanks! -- - Mitchell Vincent - To unsubscribe, send email to [EMAIL PROTECTED] -