> > 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]
