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. Please Advise, David J. Lamp _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution