Zeoslib Portal

More news. I changed the program to use the standard sqlite3 objects supplied with Lazarus for the inserts and it now works fine. Inserts about 1000 rows in a tenth of a second. So now I have a hybrid program part Zeos, part standard. I'm not happy with this mixture so if I can't find a solution I'l...

Hi marupilami, The code I have works in part of the program but not in another, which is what I find confusing. I can upload all the code if you'd like but I don't think I can create a sample that will reliably reproduce the problem. Program begins with action := 'ATTACH DATABASE ' + QuotedStr(histo...

I should add that substituting "Autocommit := false" in place of 'starttransaction' results in the same error.

Hi Jan, I added this line to the code some time earlier but it didn't seem to make any difference: DM1.ZCDeflation.Properties.Add('ExtendedErrorMessage=true'); Running under the IDE I just get "SQL error. SQL Logic Error' Running the exec directly (not under the IDE) gives the same message. Gra...

I am running Lazarus 2.2 under Windows 11 64 bit. I have a program inserting multiple rows into a sqlite3 database using Zeos 7.14. The inserts are very slow so I tried to speed them up by grouping all the inserts into a transaction. Thus: DM1.ZCDeflation.StartTransaction; .. Insert some rows via si...

I thought I'd downloaded the latest version but it's actually 7.2.14. So this post is actually in the wrong forum. I did a quick search but I can't find an actual download link for 8.0. The SQL logic error has now gone away! I deleted the SQL text from the query and connected (from the IDE) ok. Then...

I originally joined this site about a year ago and when I wanted to use it recently found that I'd forgotten the password I'd chosen. The site says that I need to hit the "Forgot Password" button on the login screen but no such button seems to exist. And when I tried to send an email I got...

Hi Jan, Well, your suggestion worked! That's something I wouldn't have thought of. Many thanks. As to why I'm calling ApplyUpdates that's in because another forum a user was having trouble getting the LAST_INSERT_ROWID() function to work (it was always returning zero) and he discovered that he neede...

I'm using Lazarus 2.2 on a 64 bit Windows 10 machine with the latest version of Zeos. I'm writing a Lazarus program that inserts into a sqlite database. The table in question has an auto increment primary key plus a second column. I'm inserting into the table via a Ztable: DMZ.DataModule2.Zdirectory...