Re: Problems trying to use SQLite functions in a SELECT statement

Schenkel = Quartam Reports & PDF Library for Revolution <http://www.quartam.com> = "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) --- On Tue, 11/10/09, Peter Haworth wrote: > From: Peter Haworth > Subject: Problems tryi

Problems trying to use SQLite functions in a SELECT statement

Some time ago, I experienced problems trying to get revQueryDatabase to process a SELECT statement that included the SQLite substr function - rev QueryDatabase failed with the ubiquitous "Missing database ot SQL error" message. The same statement, cut and pasted into either the Sqlite3 com