[sqlite] ANN: Delphi/Cpp builder ASQLite3 components for SQLite3.0.x released
Today the first version of the open source Delphi components for SQLite 3.0.2 is released. It can be downloaded from sqlite.aducom.com. To work you need the correct dll of SQLite3.dll. This is not on the current website due to the fact that not all of the api is correctly exported. You need the sqlite3.dll from http://squeakycode.net/ This version has all the documented api set exported. Best regards, Albert Drent aducom software
[sqlite] sqlite3.dll
While converting my Delphi components to version 3 I found out that the documented function sqlite3_exec... is not exported in the sqlite.dll. Is it an idea to rename this dll to sqlite3.dll? Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] sqlite3.dll
While converting my Delphi components to version 3 I found out that the documented function sqlite3_exec... is not exported in the sqlite.dll. Is it an idea to rename this dll to sqlite3.dll? Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] SQL syntax
Is there a document describing changes in sql statements, especially on pragma's? Which pragma's are understood? Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Saving BLOBs in Sqlite
SQLite saves data as null terminated strings. So it's only capable to store CLOBS. In cvs there seems to be two functions to escape null characters but they are not available in the sqlite.dll version 13. It appears that all development effort is put into a complete new version, so I'm affraid these functions will not be available in a short notice. You can use escape routines of your own but if other app's will need the same database you might face compatibility problems. It's been an isue to us rather a while now. Albert Drent aducom software > Dear sirs, > > I am trying to develop techniques to save BLOBs in Sqlite. What is the best > way to save jpg(S), bmp(s), etc? > > Would it be best to use GetBitmapBits ("gdi32" library) and then save to > Sqlite as a byte array or is there a more efficient method? > > I am new to Sqlite but it seems to be an amazing tool! > > I look forward to any help and I thank you in advance for your input. > > Sincerely, > Ed Porter > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] version 14
Hi, The real question was if it's possible to deploy sqlitedll version 14 containing the escape routines you mentioned in a previous post. This will make blob fields implementable in our components. I understood that these routines are already available in cvs. best regards, Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] release 14
Hi, Is it possible to do a release 14 of the sqlite.dll with the support of real blobs? (It's available in cvs?) Or will I have to wait for the full new version? Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] CVS branch
Will there be a version 14 with blob support? (The escape routines are needed in the dll, but are only available in cvs?) Will the experimental version 3.0 and follow-up also be available as a dll binary? (Windows). I would like to investigate differences in an early stage for modification of Delphi components. Don't want to compile it by myself. Best regards, Albert Drent > Users who download SQLite sources directly from CVS should note > that the stable code base is now on a branch. The trunk will not > compile or function at this time. Unless you want to work on the > new, experimental version 3.0 of SQLite you should do the following > from CVS: > > cvs update -r version_2 > > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] PRAGMA empty_result_callbacks
We thought that this was a problem too, but investigating we found out that in version 12 the execution of the pragma did not trigger the callback, but version 13 does. Which means that you have to ignore this first trigger, since it contains no data. Albert Drent aducom software > Hi, I just upgraded from 2.8.12 to 2.8.13 via RPM. I was wondering if > anyone else noticed that PRAGMA empty_result_callbacks seems to break > stuff now. Whenever I execute a statement with that pragma, my callback > function can't get any column name information. Do I need to update my > code for the .13 release? I downgraded back to the .12 release, and > everything works fine. > > Here is the query I used which works fine on 2.8.12, but doesn't work on > 2.8.13: > > PRAGMA empty_result_callbacks = ON; select * from test > > Any help I can get would be greatly appreciated! > > --Aaron > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] A proposal for SQLite version 3.0
As a developer of Delphi components for SQLite I would recommend a new function for both releases to investigate the fileversion. Perhaps it's already there. Of course you can open a database and wait for an exception to occur, but this is not a very clean way of doing things. Having this possibility it would mean that the single component set will be able to handle both sqlite versions, and call different routines and allocate different dll, depending on the version of the file. function GetSQLiteFileVersion(FileId : pChar) : cardinal; albert drent aducom software - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Sorry for the repeated reply
Something terrible went wrong here. Again sorry. Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Using sqlite with C++Builder6
If you know how to apply Delphi components into C++Builder then you might give the components of sqlite.aducom.com a try. Albert > I have it working under Windows 2000 using BCB 6. > > -Original Message- > From: Eli Wheaton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 4:47 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] Using sqlite with C++Builder6 > > > Hi All, > > I'm having a problem trying to get SQLite to work with a C++Builder6 > project. > Does anyone have any advice on how to do this? > > OS: Windows XP > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Using sqlite with C++Builder6
If you know how to apply Delphi components into C++Builder then you might give the components of sqlite.aducom.com a try. Albert > I have it working under Windows 2000 using BCB 6. > > -Original Message- > From: Eli Wheaton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 4:47 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] Using sqlite with C++Builder6 > > > Hi All, > > I'm having a problem trying to get SQLite to work with a C++Builder6 > project. > Does anyone have any advice on how to do this? > > OS: Windows XP > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Using sqlite with C++Builder6
If you know how to apply Delphi components into C++Builder then you might give the components of sqlite.aducom.com a try. Albert > I have it working under Windows 2000 using BCB 6. > > -Original Message- > From: Eli Wheaton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 4:47 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] Using sqlite with C++Builder6 > > > Hi All, > > I'm having a problem trying to get SQLite to work with a C++Builder6 > project. > Does anyone have any advice on how to do this? > > OS: Windows XP > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Using sqlite with C++Builder6
If you know how to apply Delphi components into C++Builder then you might give the components of sqlite.aducom.com a try. Albert > I have it working under Windows 2000 using BCB 6. > > -Original Message- > From: Eli Wheaton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 4:47 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] Using sqlite with C++Builder6 > > > Hi All, > > I'm having a problem trying to get SQLite to work with a C++Builder6 > project. > Does anyone have any advice on how to do this? > > OS: Windows XP > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Using sqlite with C++Builder6
If you know how to apply Delphi components into C++Builder then you might give the components of sqlite.aducom.com a try. Albert > I have it working under Windows 2000 using BCB 6. > > -Original Message- > From: Eli Wheaton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 4:47 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] Using sqlite with C++Builder6 > > > Hi All, > > I'm having a problem trying to get SQLite to work with a C++Builder6 > project. > Does anyone have any advice on how to do this? > > OS: Windows XP > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] sqlite.org ISP problems
Another (very good) provider with 7 * 24hrs support is www.nomonthlyfees.com We use it over a few years now, and even on sunday here (Netherlands) we get fast support by NMF even if it's in the middle of the night in America (where they are). Albert Drent aducom software > Guys, the best hosting company with the best customer service I have had is > from August.NET here in Dallas. They are not too big that you don't get > excellent customer service, yet not too small in that they don't have > enterprise level network infrastructure and capabilities. When you need to > get something done, these are the guys to work with. > > http://www.august.net > > Thanks, > Allan > > -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 31, 2004 9:30 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] sqlite.org ISP problems > > For the past 9 months, www.sqlite.org has been hosted on a virtual server > from www.linode.com. Chris Aker, the proprietor of www.linode.com, has been > very responsive and helpful and has made www.linode.com an excellent > provider. > > That is, until very recently. Chris has lately been completely > unresponsive. I have had support requests in for over two weeks. I've sent > multiple emails. So far, I have not received so much as an acknowledgement. > In appears as if Chris has abandoned his enterprise. > (One hopes Chris has not taken ill) > > This is not a crisis, as long as www.sqlite.org continues to function. But > if something goes wrong, it looks like I will be completely unable to get it > fixed. > > How does this effect you? Two things: > > 1. If www.sqlite.org suddenly stops working, it is > probably because something failed and I cannot > get it fixed. If that happens, please spread > the word for people to use the backup site > (http://www.hwaci.com/sw/sqlite/) until I can > locate another ISP. Unfortunately, CVS and > CVSTrac and the mailing list are not available > on the backup site. > > 2. If you can recommend a good ISP, please do so. > > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Text(3)
For the users using the Delphi components there is a property in TASQLiteTable and TASQLiteQuery to set or reset the 'typeless' property. Setting this property to 'false' (typed) means that all data-aware components of Delphi will react on the defined type (must be delphi compatible) and length, forcing correct data to be entered. Albert Drent sqlite.aducom.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Callback routine (3)
Sorry for my bad English, but I found the previous message not clear enough, As of version 13 the first row containing the metadata has a columncount of 0, the other datarecords has the correct value of the number of fields. In version 12, all records show the correct number of fields in columncount. Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] callback routine [2]
Some additional info: In version 12, when the metadata is sent (showdatatypes is on) then the columns has a valid value on all records, including the first. As of version 13 is doesnt, but it shows 0 on the first record (containing the metadata) and the correct number on the data fields. This must be a bug? Albert Drent aducom software - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] callback routine
Hi, I have created Delphi components for SQLite. All worked well but the newest sqlite.dll is giving me problems. The columncount in the callback routine is always 0 causing my components to crash. Have I missed something or is it a bug? Albert Drent aducom software - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]