Re: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread claudio benghi
On 12/18/06, RB Smissaert [EMAIL PROTECTED] wrote: Yes, and it is nice to know that this is an option. I am using a VB wrapper though and not using the SQLite dll. Will figure something out. RBS In VB.net I once solved this implementing an user function using the ADO.net provider. You can

Re: [sqlite] Design of application using embedded database

2006-11-18 Thread claudio benghi
Upon loading a saved file into the application the database on filesystem is loaded into an ADO.Net DataSet. This is used by the application until the user saves to disk again when all of the changes to the DataSet are saved back to the database on disk. In all of the desktop apps

Re: [sqlite] (New SQLite user) - ANSI Datatypes

2006-11-14 Thread claudio benghi
Hi, I dont' know what SQLite Administrator is doin during the output but I think SQLite stores the data as you inserted it. About this you cold read faq #3 at http://www.sqlite.org/faq.html#q3 Regards, Claudio On 11/14/06, Mario Figueiredo [EMAIL PROTECTED] wrote: Hello everyone, I plan to