Re: [dabo-users] Grid from SQLite Views

On Friday, March 02, 2012 01:56:16 PM Dewald Jacobs wrote:

> Hi,

> I have a SQLite database with a View (created with the command CREATE VIEW,

> just to be clear) that was created by combining 2 tables plus and an added

> column to compute JULIANDAY. How would I go about adding this View in a

> grid in Class Designer? I want to treat this view exactly the same as a

> normal table and have tried to implement it as such, but have failed to do

> so.

> Any tips or advice would be much appreciated.

> Thanks

> Dewald

I don't use SQLite.

But, looking at the code - dbSQLite.py - the views are not retrieved.

Something like

select name from sqlite_master where type = 'view'

is needed.

Question is how best to add in the views and will anything need changing to

support ClassDesigner.

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com