Does your Sqlite support views

[David_USA]

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 use other front ends my generated SQL works properly.

I would like to save a lot of extra code time.

Please Advise,

David J. Lamp

[strongbow]

Hi David

I am using Sqlite views with the database query tool with a WHERE clause.

Can you post the statement that causes the error?

cheers

Alan

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 use other front ends my generated SQL works properly.

I would like to save a lot of extra code time.

Please Advise,

David J. Lamp