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

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

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

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

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

[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!