RE: [sqlite] sqlite with Visual Basic

Hi David, Many thanks for your suggestion regarding ddoc.  I had a look at the site and the price is right and it certainly looks like a great way to programmatically create a report. I'll download the evaluation version and give it a try. Thanks again! At 15:17 17/05/2004 +1000, you wrote: Hi Mur

Re: [sqlite] sqlite with Visual Basic

Murray Moffatt wrote: Hi Wind, At 13:02 17/05/2004 +0800, you wrote: You have two choose: 1. search the windows register for the datasource that you created using ODBC Control Panel, you can create the same register entry programmatically. 2. You can just use such a string as your Connect

Re: [sqlite] sqlite with Visual Basic

Hi Wind, At 13:02 17/05/2004 +0800, you wrote: You have two choose: 1. search the windows register for the datasource that you created using ODBC Control Panel, you can create the same register entry programmatically. 2. You can just use such a string as your ConnectionString "Driver={Mi

Re: [sqlite] sqlite with Visual Basic

Murray Moffatt wrote: I'm interested in using SQLite from within a Visual Basic 6 app that I'm writing. I need reporting features and so was looking at using Crystal Reports. I'm guessing that it would be easiest to use SQLite ODBC for accessing the SQLite database, as the VB tools and Crystal

RE: [sqlite] sqlite with Visual Basic

Hi Greg, Many thanks for your reply to my questions. I had a quick look at ActiveReports but once I saw the $499 price tag I didn't bother going any further. That's way too much to spend on my little freeware program! The only reason I was looking at Crystal Reports is because I already have i

RE: [sqlite] sqlite with Visual Basic

Hi Murray, Can I make a suggestion or two. Firstly I wouldn't use Crystal Report. It sucks and I hate it , have a look at ActiveReports from DataDynamics Version 2.0 is fantastic and very light on it's feet (small). The price is great as well. Also ActiveReport supports ADO , DAO, RDO and XM

RE: [sqlite] sqlite with Visual Basic

I'm interested in using SQLite from within a Visual Basic 6 app that I'm writing. I need reporting features and so was looking at using Crystal Reports. I'm guessing that it would be easiest to use SQLite ODBC for accessing the SQLite database, as the VB tools and Crystal Reports support ODBC. Whe

[sqlite] offset of SQL query fail.

Hi all, I am using sqlite ver 2.8.12. and I want to do the SQL statement with offset and limit: but the error occurs at the offset sqlite> select * from tbl offset 4 limit 5; SQL error: near "4": syntax error Is the SQL query wrong ?what is the correct SQL query if it is wrong? thx all! Best

RE: [sqlite] sqlite with Visual Basic

Personally, I use my own wrapper (attached) with Greg Obleshchuk's AGS_SQLite.dll. It is very simple to use (it will generate the SQL code for you): Dim db as ADOSQLite Set db = new ADOSQLite db.Connect "database.db" db.Table = "mytable" db.Action = ActionSelect db.Sort = "id" db.Where = "id < 10

[sqlite] Re: Memory leak with PSVBUTLS32

Jérôme VERITE >> I use the psvbutls32 dll from windows to access SQLite with Visual Basic. Using PSVBUTLS_ExecuteDB with a select statement, I remark a memory leak. Each time I use it, the memory used by my application increase a lot. I hadn't noticed, but according to my dad, there's also a b

[sqlite] Memory leak with PSVBUTLS32

Hi, I use the psvbutls32 dll from windows to access SQLite with Visual Basic. Using PSVBUTLS_ExecuteDB with a select statement, I remark a memory leak. Each time I use it, the memory used by my application increase a lot. Is it a known bug, or a bad use of the API Thanks a lot