RE: [sqlite] Charting data in VB?

2004-08-02 Thread Frederic Faure
>> You will more than likely need a commercial control to do what you are asking Right, but since everyone seems to recommend _against_ the MSChart control that comes free with VB, I was looking for comments on commercial alternatives. There are so many, that I'm a bit lost. >> How are you con

[sqlite] Charting data in VB?

2004-08-02 Thread Frederic Faure
James >> Plain graphs? Saving? Printing? How is data passed to the chart control? Thx for the reply. All the above, I guess. We'd like to add a Output section in our software so that customers can print pretty graphs from some of the data in SQLite, and that includes bars, lines, and pies, as

[sqlite] Charting data in VB?

2004-08-02 Thread Frederic Faure
Hi, I'm looking for a solution to chart data that live in an SQLite database from a VB app, but there are a lot of components and am a bit at a loss at which to choose. Does some VB developper also experienced with SQLite could recommend one? Is MS Chart (either MSCHART.OCX or MSCHRT20.OCX) good

Re: [sqlite] re: ANN: SQLiteDB, a COM wrapper around sqlite has been released

2004-07-28 Thread Frederic Faure
Ed Porter >> The SQLite code is in the DLL (you do not need to install the SQLite3.02 dll). This wrapper is excellent! As a third party reviewer, I find it to be the best one to date! Thx for the feedback. I'll give it a shot. Fred.

[sqlite] re: ANN: SQLiteDB, a COM wrapper around sqlite has been released

2004-07-27 Thread Frederic Faure
George Ionescu >> I have just released SQLiteDB, a COM wrapper around sqlite written in ATL. Is the SQLite source compiled in the DLL, or do we need to deploy the two DLL's? Thx Fred.

RE: [sqlite] sqlite with Visual Basic

2004-06-19 Thread Frederic Faure
At 13:15 19/06/2004, you wrote: The previous version included the SQLite code in the DLL. This version loads the SQLite DLL at runtime and calls into it - that way there is no built-in dependency on the SQLite version. Very cool :-) Fred. --

RE: [sqlite] sqlite with Visual Basic

2004-06-19 Thread Frederic Faure
"Steve O'Hara" >> If you can think of improvements, let me know. I noticed that the output DLL shrank yet again to 45KB :-) What did you do to make it so small? Fred. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional com

Re: [sqlite] Does Richard have a wish-list @ Amazon?

2004-06-02 Thread Frederic Faure
>> I have a wish-list on Amazon. :-) My name and email address at Amazon are as shown in the signature line below. Since e-mails are automatically removed to avoid spam bots, for those interested, here's the list: http://tinyurl.com/3db5j Fred.

[sqlite] Does Richard have a wish-list @ Amazon?

2004-06-02 Thread Frederic Faure
Hi, BTW, does Richard have a wish-list over at Amazon or Barnes and Noble so that people have an easy way to show their appreciation of the work he does with SQLite? Great make-over of the site. I like it :-) Cheers Fred. - To u

Re: [sqlite] Examples of SQL available?

2004-05-26 Thread Frederic Faure
Joseph Stewart >> What I'm looking for is a good set of SQL examples for more esoteric feature (to me at least) of sqlite Some good online tutorials on SQL: http://www.geekgirls.com/menu_databases.htm http://sqlzoo.net/ http://philip.greenspun.com/sql/ Fred.

[sqlite] Tips & tricks for concurrency?

2004-05-26 Thread Frederic Faure
Hi, I did read the archives, along with information on the web site, and am aware of the risks I take using SQLite in concurrent mode. Still, since over half of our customers still don't have the Net (hence, usually use NetBeui as their network protocol instead of TCP/IP), and asking them to hav

[sqlite] Re: Memory leak with PSVBUTLS32

2004-05-16 Thread Frederic Faure
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] Is the DLL kept in RAM constantly?

2004-05-03 Thread Frederic Faure
Hi, Since the performance of SQLite are so great, my dad and I were wondering if SQLite used a Windows API to tell it not to unload SQLite from RAM even if no program was still calling it, so that the next time a program loaded it, it would still be up and running in RAM, with data also loaded?