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: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/1847780.x6huU0sifq@linux-12
