Does Revolution Allow use of Sqlite VIEWS
wildelec at bossig.com
Tue Dec 30 11:19:27 CST 2008
I am in need of knowing if Revolution supports Sqlite VIEWS.
I am using the revDataFormQuery to return DB information
I can do a Select * From (view name) and that is it.
If I try to add a WHERE statement or an ORDER BY statement I get the
revdberr (SQL or database error)
If I write the code to assemble SQL that accesses the tables directly every
thing works fine.
If I access my generated SQL via a variable and put it into another DB front
end my generated SQL works properly.
I would like to save a lot of extra code time.
David J. Lamp
More information about the use-livecode