Zeoslib Portal

Can someone please tell me why this only works one time after the aTbl.Edit. If I rem out the four lines for editing the table it iterates through all 49 records. It seems that the Edit and Post will position the file-cursor at the end of the file as I am only ever getting one record changed and it ...

Hi Jan, Thanks for the comment, I was thinking along the same lines. Time to quit with SQLite. With thanks to a guy on another forum, it turned out to be a data limit of dsMaxStringSize=8192 for DataSets. I did some more searching and there is a Data Type for SQLite of BLOB_TEXT - and that appears t...

Man I am making this thing crash and burn a lot. I have a VARCHAR2 Field of 10,000 Bytes and during the initiating process Zeos crashes with invalid data size. Stepping through it, the Size in question is 4223943 which I would agree should invalid. If I can't have 10,000 characters, then how can I h...

Hi All, I had a working system then I decided to change all of the Field names by adding a "z" to the front as some of them were causing problems for Zeos. Things like "From" etc went to "zFrom". So, I deleted all of the Persistent fields, created a new Database and Tab...

OK, the plot thickens. I used a standard D5 Data Aware DBEdit and disable all the TNT stuff just in case. Same error. With only a single input field, this left all but one of the Fields empty for the Post. Back tracking, the SQL text now shows... "SELECT True,5,True,True,False" ...which lo...

Hi All, New user to Zeos; I am using D5 with SQLite3 and I have to use 6.6 Stable as 7. has dropped D5 Package. I am also using the TNT Unicode components. I am converting over from BDE to SQLite3 and the BDE app was running fine. Made all the changes needed and the app runs, but with all empty Tabl...

Thanks, so what was the last stable release that would work with D5?

Hi,

It's been a few years since I last looked in here. I wanted to give Zeos another try but I cannot find what versions of Delphi it is for.

I am retired and still use D5 for personal use. It would make sense to have the basic system requirements obvious on the Portal page.

Thanks

What the MySQL data file is running under (OS) should not matter. You are accessing the MySQL files not Linux.

Easiest way is to install Zeos and go try. Takes all of five minutes.

Bob

Hi All,

SeaWolf helped me with some code for updating a Table but it is twice as much coding as a standard "Update" SQL script.

So why use an Update Object then?

Thanks

Bob

Thanks Seawolf, I have it fixed. Your code got me 80% of the way, but the Record in the grid losing focus was not good. May not be the most elegant solution casting another version of the TDBGrid to expose the Row property, but here it is for others... type ..TTempDBGrid = class(TDBGrid); procedure ...

Thanks, but it does not update the Table until I Close and Open it again and that moves the cursor off the selected line in the TDBGrid. I need some kind of refresh.

Yes, I am using AutoCommit

I am using SQLite3 if that makes a difference.

Bob

Hi All, This is really frustrating. I am trying to use TZUpdate but for the life of me I can't find how to execute or action it. I have scoured the source code and no exec of any kind. I have tried ExecSQL for the parent query, but does nothing either. How do I activate an update???? I have searched...

The only package you must install is ZComponent.dpk All others packages must be compiled OK, thanks. I was following this Tutorial on this site. http://zeos.firmos.at/kb.php?mode=article&k=12 I don't have D7, so I assumed he meant .dpk files ************************************ Open the delphi ...

Hi,

I just unpacked the .zip and tried to Install "ZCore.dpk" and D5 tells me that it is not a design time package.

It loads and compiles without error.

DBob