Re: Re[2]: [sqlite] Problems Insert with Date and Time values
Thank you again for all you work.. Giuliano - Original Message - From: "Ion Silvestru" <[EMAIL PROTECTED]> To: "Giuliano" <sqlite-users@sqlite.org> Sent: Friday, December 14, 2007 10:08 AM Subject: Re[2]: [sqlite] Problems Insert with Date and Time values It seems that "BETWEEN" in SQLite is treated as "BETWEEN..AND selects fields that are between and including the test values", so it can be used instead of ">=" and "<=". - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problems Insert with Date and Time values
Thanks a lot! any suggestion for a query then that read and compare dates, for ex.: SELECT somefiled FROM sometable WHERE datefield1 BETWEEN ' '? AND ' '? How can I query then the string values as date? Thanks again Giuliano - Original Message - From: "Ion Silvestru" <[EMAIL PROTECTED]> To: "Giuliano" <sqlite-users@sqlite.org> Sent: Friday, December 14, 2007 8:55 AM Subject: Re: [sqlite] Problems Insert with Date and Time values >is it possible (how?) to insert into 2 different fields (date) the >following values: 09:30:00(only a time value...) 14/07/07 (only year value, 14th of december 2007) Just store date and/or time as string: "20070714" or "070714", "093000". It is compact, you can sort them easily etc. You can store them also as Integer: 20070714, 93000, this will save space in database, as integers are stored in variable-length format (VarInt). - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Problems Insert with Date and Time values
Hello, is it possible (how?) to insert into 2 different fields (date) the following values: 09:30:00(only a time value...) 14/07/07 (only year value, 14th of december 2007) sorry, I am not be able at all to do that. Many thanks in advance for helping, Giuliano - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Cannot build VC++ VS2005 SQLite3vb
Hello, someone could please help me... I try to build SQLite3VB, following exactly the instruction on the page: http://www.tannertech.net/sqlite3vb/ but at the end of the build process, I get allways the same error, like this: Linking... sqlite3.def : error LNK2001: unresolved external symbol sqlite3_apis sqlite3.def : error LNK2001: unresolved external symbol sqlite3_auto_extension .. for about 48 times... I think is something missing in my configuration, maybe the .def file. help...please.. Giuliano - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Wrapper ADO like for VB6
Thanks, I have seen and it seams to be really interesting. I will try it for sure. Did you also try the dhRPCServer that should act like a server/client? - Original Message - From: "RB Smissaert" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, September 26, 2007 2:47 PM Subject: RE: [sqlite] Wrapper ADO like for VB6 I am using dhSQLite, which you can download from here: http://www.thecommon.net/2.html I have tried several wrappers for VB(A) (about 4 or 5) and this is the best one. Good support as well. RBS -Original Message- From: Giuliano [mailto:[EMAIL PROTECTED] Sent: 26 September 2007 13:35 To: sqlite-users@sqlite.org Subject: [sqlite] Wrapper ADO like for VB6 Hello, I am porting a big program from SQLServ.. to SQLite and I have seen that there are many VB6 wrappers available. I would like to get some suggestion from people who already use one, to be sure to make the right decision (important: ADO like, stability, upgrades etc...) Many thanks in advance, Giuliano - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Wrapper ADO like for VB6
Hello, I am porting a big program from SQLServ.. to SQLite and I have seen that there are many VB6 wrappers available. I would like to get some suggestion from people who already use one, to be sure to make the right decision (important: ADO like, stability, upgrades etc...) Many thanks in advance, Giuliano