revdb error: MUST be select SQL

[Jan Schenkel]

--- Ivan <ivan at internet-marketing-today.com> wrote:
> Hi Jan,
> 
> Many thanks for the help - I'm still facing an issue
> with PRAGMA.
> 
> I was actually trying to use libDatabase from Trevor
> DeVore, but my database 
> insert was failing on libDB_addToTable.  In trying
> to get it to work, I 
> isolated the problem to the revDataFromQuery call
> above.
> 
> It seemed that the PRAGMA sql call was not working.
> 
> I tried to use revExecuteSQL, but this only executes
> sql and does not return 
> the table field information produced by PRAGMA
> table_info?
> 
> I'm sure there is a simpler way to do this - but I'm
> still very new to the db 
> calls in Rev.
> 
> 
> Thanks,
> Ivan
> 

Hi Ivan,

While I'm sure Trevor will jump in with comments on
his excellent libDatabase, I thought I'd mention the
following link to the SQLite.org WIKI:
<http://www.sqlite.org/cvstrac/wiki?p=InformationSchema>

Basically, it shows how you can create a VIEW with the
database schema information, so you wouldn't need the
PRAGMA command.

Hope this helped,

Jan Schenkel.

Quartam Reports for Revolution
<http://www.quartam.com>

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com