RE: [sqlite] [Visual Basic] How do you work with SQLite?
At 23:25 09/08/2007 +0100, RB Smissaert wrote: One, via an ADO recordset after connecting to Interbase with ODBC. [...] Two, via a custom Delphi dll that moves data directly from Interbase to SQLite. This is maybe slightly faster than the first method, but not that much difference. So, no ODBC with this method and no ADO recordset. Thanks for the tip. G. - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] [Visual Basic] How do you work with SQLite?
Several reasons. Main one is that we won't be allowed as this is a third party application clinical database. The other one is that it would cause too much slow-down of the regular clinical front-end application. This is reporting software and apart from some rare exceptions there is no writing back to Interbase. RBS -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: 10 August 2007 02:58 To: sqlite-users@sqlite.org Subject: RE: [sqlite] [Visual Basic] How do you work with SQLite? At 05:25 PM 8/9/2007, you wrote: >I use it mainly to manipulate data obtained from an Interbase database. >All the data will eventually be dumped to Excel. >I use 2 ways to move data from Interbase to SQLite. >One, via an ADO recordset after connecting to Interbase with ODBC. This >recordset will then be dumped to SQLite via the free VB wrapper from Olaf >Schmidt, dhSQLite. Very good and fast wrapper with a rich object model. >Two, via a custom Delphi dll that moves data directly from Interbase to >SQLite. This is maybe slightly faster than the first method, but not that >much difference. So, no ODBC with this method and no ADO recordset. > >Moving data from SQLite to Excel is all done with dhSQLite. This wrapper can >be downloaed from: http://www.thecommon.net/2.html >Very much recommended for anybody who works with VB or VBA. > >RBS RBS, So why can't you manipulate the data in Interbase? It's reasonably fast. Mike - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] [Visual Basic] How do you work with SQLite?
At 05:25 PM 8/9/2007, you wrote: I use it mainly to manipulate data obtained from an Interbase database. All the data will eventually be dumped to Excel. I use 2 ways to move data from Interbase to SQLite. One, via an ADO recordset after connecting to Interbase with ODBC. This recordset will then be dumped to SQLite via the free VB wrapper from Olaf Schmidt, dhSQLite. Very good and fast wrapper with a rich object model. Two, via a custom Delphi dll that moves data directly from Interbase to SQLite. This is maybe slightly faster than the first method, but not that much difference. So, no ODBC with this method and no ADO recordset. Moving data from SQLite to Excel is all done with dhSQLite. This wrapper can be downloaed from: http://www.thecommon.net/2.html Very much recommended for anybody who works with VB or VBA. RBS RBS, So why can't you manipulate the data in Interbase? It's reasonably fast. Mike - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] [Visual Basic] How do you work with SQLite?
I use it mainly to manipulate data obtained from an Interbase database. All the data will eventually be dumped to Excel. I use 2 ways to move data from Interbase to SQLite. One, via an ADO recordset after connecting to Interbase with ODBC. This recordset will then be dumped to SQLite via the free VB wrapper from Olaf Schmidt, dhSQLite. Very good and fast wrapper with a rich object model. Two, via a custom Delphi dll that moves data directly from Interbase to SQLite. This is maybe slightly faster than the first method, but not that much difference. So, no ODBC with this method and no ADO recordset. Moving data from SQLite to Excel is all done with dhSQLite. This wrapper can be downloaed from: http://www.thecommon.net/2.html Very much recommended for anybody who works with VB or VBA. RBS -Original Message- From: Gilles Ganault [mailto:[EMAIL PROTECTED] Sent: 09 August 2007 22:46 To: sqlite-users@sqlite.org Subject: [sqlite] [Visual Basic] How do you work with SQLite? Hello I was wondering: how do you VB developpers work with SQLite? Currently, I use a variant array that I fill with data from SQLite, and use ComponentOne's grid object to display the data through its LoadArray() method; If/once the data is updated by the user, I write the array back to SQLite. Do you use ADO et al? Other ways to connect VB and SQLite? Thank you. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
