Zeoslib Portal

OK, problem worked around, but not a solution. On a wild Hare, I created a 5G Truecrypt container and formatted it NTFS and copied the Folder structure to it and it all works perfectly. So, while not AN answer, it appears to me that this IS a MSoft problem, or maybe an SQLite3 problem. Suffice to sa...

Hi All, I was just copying a system (been working for years on win7) over to win8 and everything runs (9 other programs) except the two apps that use SQLite3. This was built using D5ent and ZEOS 6.6. Can't go to Zeos 7 as it will not compile in D5 and I really do not want to convert this to 2007. Bo...

Hi, did some searching here and nothing helps. Read the Help system, same. tblFiles.EmptyDataSet; Sometimes it shows tblFiles.RecordCount as = to 0 and other times it does not. I need to re-use a temporary Table 30-times per run of my application and I need to empty it before EVERY use. I also tried...

Hi all, D5 and SQLite... I have a weird thing going on. I have an application that is working fine until I post some data to another database. It all works as expected and returns to the main screen without error -- but as soon as I click any button on the main form, including "Close" I ge...

Thanks DD, I didn't realize that a 64-bit version would only run on other 64-bit PCs. I thought I had to have the 64-bit for this PC because it was a 64-bit. I am using the 32-bit .dll as the end application will run on both 64 and 32.

Thanks, I will give that a try.

Thanks for going to that trouble, but I had already tried something like that and it would not copy the data to the new record. It created and empty record. Here's what I tried... for i:=1 to tblFrom.FieldCount-1 do // Start from 1 to skip the AutoInc begin if tblTo.FindField(tblFrom.Fields[i].Field...

Hi All, Is there an easy way to copy a record o the same table? I have an SQLite database that the user may often want to have almost the same stuff in another record, and just change one or two fields. Is there something like BatchMove that I can copy all but the AutoInc field? There are no no uniq...

Thanks Jan, But that would only be true when the file is opened. If the user adds or deletes records then it will not work. I am getting around it for the time being with a query, this may be useful for others as it ignores any filtering etc... function GetAllRecCount : String; begin qryStock.Close;...

Thanks Jan,

I didn't read the download page fully the first time. I just grabbed the 64-bit Lazarus because I had a 64-bit PC.

I went back and read and it said pretty much use the Lazarus 32-bit and that's what I did.

Thanks for the reply anyway.

Hi, D5 and v6 Zeos. I'd like to know the actual RecordCount of a DataSet. If it is Filtered then RecordCount only returns the available records as Filtered. TDbf has an ExactRecordCount which always shows the total Records regardless of Filtering or Indexes. Does Zeos have anything like that? I want...

Hi All,

I have just installed Lazerus x64 and it appears that Zeos Connection needs an x64 version of SQLite. So far my searches have failed. Anyone know of the existence?

I guess I need to uninstall Lazerus and install the x86 version? Yes? No?

Thanks

Thanks for the reply Jan, but if there is an active Index then a sequential edit will not work. The Index has to be cleared before the Edit. Let's say you need to change a bunch of Accounts by resetting a Status Boolean. [align=left] tbl.IndexFieldNames:='Account Asc'; tbl.First; while not (tbl.EOF)...

Hi All, Is there a procedure for clearing and setting the IndexFieldNames? I have the following code and when I want to Edit an account I have to clear that Index and after the Post I need to reset it. I just want to be sure I am not risking corruption to the Database. Is this OK? If not, how should...

OK, problem solved with thanks to another forum. I had a Sequence set in the Table and that was conflicting with one of the updating fields. DUH. I knew it had to be me!! LOL

This Zeos stuff is proving to be very robust. Only used it for a week or so, but am impressed.