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

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