Zeoslib Portal

mdaems, Thank you! I tried your first solution and it worked perfectly. And the second one was simply the best! I have no code in my forms anymore to persist data as zeos makes many data conversions automatically, for example date formats. I created three procedures per table one for insertion, anot...

Thanks for your answer. What you mean with row by row? Can you give me a snippet of both examples you gave me? It's just because I never did the way you are proposing, so I don't know how to accomplish this.

Best regards!

Well, the Person table is the master, as person could be an employee, a visitor visiting the company and doesn't have a RegNo as an employee does, but have other fields that Person doesn't have and employee neither. I made something like specialization(something like class inheritance, but in databa...

I made a very small test case to show you what I'm pointing. If you go, line by line, executing the code and put a watch to ZQuery1Id.Value you'll see that the field is not refreshed staying with a value of 0 after ApplyUpdates. All fields still filled normally after ApplyUpdates but Auto Increment ...

Yes, you pointed it, but I couldn't make it work because, even with your snippet, I didn't understand how to use this option, it would be better to understand if your snippet was a real use case as I made mine. But, what I noticed is that, even after ZQuery.ApplyUpdates, ZConnection.Commit and ZQuer...

well, the value is not being filled even after the error. I don't know anything about zeos code, I have absolutely no idea where in the code it should be taking the next auto increment value from the database. I asked this, because I saw in one of the changelogs that zeos supports MySQL auto increme...

During ApplyUpdates it's generating the SQL and executing it, but it's not returning the auto increment value to the master query ID field. Here is my SQL trace coming from ZSQLMonitor 2013-08-29 00:01:23 cat: Execute, proto: mysql-5, msg: INSERT INTO person (Id, name) VALUES (NULL, 'Edit1') --> Thi...

I'm trying to persist two tables with master-detail relationship in MySQL 5.6 and, when I do ApplyUpdates on the master, the auto increment field stays with 0 as value. I need the auto increment value, so I can link the detail table with the master table's ID field coming from ApplyUpdates. I'm usin...

Hello, I'm trying to get the next insertion ID of the master table to put it to the detail's MasterFK field and persist both of the tables in one single commit. How can I accomplish this? What I tried to do is something like ZConnection options: AutoCommit = FALSE TransactionIsolationLevel = tiReadC...

It's very easy to build Zeos for XE3, seek for packages\DelphiXE3 folder, double click ZeosDbo.groupproj file, let Delphi open the project group. Next on the right hand side of your screen there will be several packages, left click the one with a gear and click install, let it compile and it will sh...

EgonHugeist , I made some tests and they apparently indicate that this property does exactly this. But I don't have a way to prove that this is true, because using ZSQLMonitor don't put any LIMIT on the select. Also, putting master detail relationship on the query, only generate SQL output text for...

It's just a doubt about what this property is for. Does it stands for query result pagination? Like I have 1000 rows from a query, if I put FetchRow to 100 will it fetch 100 rows at a time as needed? I couldn't find any Zeos documentation giving details on how does it work and what the components pr...

EgonHugeist , Thanks for your help. I need a code snippet that uses doUpdateMasterFirst. How does it work? If I put the detail table in edit or insert mode the master table will too be put on those modes automatically? To this work properly I have to fill MasterSource with the the Master's DataSour...

EgonHugeist , How I have to setup my query objects to accomplish what you suggested, what I have to put in what property? My concern is with memory usage on large datasets making the application on the client side very slow or overloading the server. I'm looking forward, too, to make query result p...

Well, I've never used those options because I never understood them well, didn't find any documentation about. I know that there is a way to link master and detail tables with MasterSource, LinkedFields and MasterFields properties in a way that one stays in sync with the other, but I've already hear...