The sqlite *VIEW* can *create* duration with "SELECT ....., datetime2-datetime1 as Duration" right inside your sql query. Just learn a little about the sql query langrage and you may find exactly what you want for this project and many more to come. :)
Good luck. On Thu, May 20, 2010 at 11:28 AM, Carey Gagnon <[email protected]>wrote: > > > > Not well known but Sqlite has some internal functions that duplicate what > > you > > are doing above. Might save you some troublee: > > http://sqlite.org/lang_datefunc.html > > > > Thanks again Adrian. I've already managed it as was shown in the previous > email, but I will investing gate for the future. > > As far as the create view goes, from my reading, I'm not sure I can use it > as the Records table has no field "duration". It is a virtual field in > dabo. > Unless of course I can substute the table in the from clause (from > Records) > with dataset (from dataset) > > All great pointers folks. > > It's all greatly appreciated. > > Carey > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > _______________________________________________ > 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/[email protected] > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/[email protected]
