Zeoslib Portal

Downloading Zeoslib version 6.6.0-beta is possible to enable this functionality! Follow these steps: 1. Locate: procedure TZMySQLCachedResolver.PostUpdates(Sender: IZCachedResultSet into: ZDbcMySqlResultSet.pas 2. Edit: remove PATCH [1185969] comments 3. Build and install 4. Enjoy! Byez, Andrea Tha...

Downloading Zeoslib version 6.6.0-beta is possible to enable this functionality! Follow these steps: 1. Locate: procedure TZMySQLCachedResolver.PostUpdates(Sender: IZCachedResultSet into: ZDbcMySqlResultSet.pas 2. Edit: remove PATCH [1185969] comments 3. Build and install 4. Enjoy! Byez, Andrea Than...

If i use auto generated index values (as primary for later use as foreign reference) there are is this std approach to enter new data: 1.) run a select statment, to check if entry already exists 2a.) if entry exists, use returned id as reference or 2b.) insert new entry and query for auto generated...

I've download Zeoslib-6.5.1-rev113 I use Delphi 7 and 5.0.26-community-nt DROP TABLE IF EXISTS `abc_pm`.`vendor_of`; CREATE TABLE `abc_pm`.`vendor_of` ( `vendor_id` int(10) unsigned default NULL, `producer_id` int(10) unsigned default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; I when I try to acce...

Hi, I've decied to migrate to zeoslib-6.5.1 for mysql5.0 support... 1. I'have downloaded: ZEOSLIB - 20061003 Testing branch(rev 102) (zip 12.8MB) 2. I've extracted all files to: C:\Programmi\Borland\Delphi7\Lib\Zeoslib-6.5.1-beta\ 3. I've added to Delphi 7 libray path: C:\Programmi\Borland\Delphi7\L...

It is possible to send the patch as a svn diff to current testing branch? If it doesn't look to 'hacky' it will be done in a minute (don't take that literally :wink: ) It would save us all a lot of work, as I think you'va already tried the fix and are satisfied. Mark Referring to: http://zeos.firmo...

Hi. I'm sorry about the late reply - I've been away for a while.. I'm not trying to do any altering of the database structure. What I'm doing is inserting, updating and deleting records. So, yes I thought you should be able to do rollbacks then. But is the code to do it witch I submitted above corr...

I've modified TZUpdateSQL component adding a LastInsertIdSQL and AutoColumnIndex properties trying to emulate TZTable behaviour. I've added after normal PostUpdates operation a query execution to get new field index from database. But now I've a problem finding a connection to make the query, how c...

I've modified TZUpdateSQL component adding a LastInsertIdSQL and AutoColumnIndex properties trying to emulate TZTable behaviour. I've added after normal PostUpdates operation a query execution to get new field index from database. But now I've a problem finding a connection to make the query, how ca...

Please post the code of you create table sql script and the log of TZSQLMoinitor.

Byez,
Andrea

Hi! It's very easy. As you wrote in the subject, it's last_insert_id(). Use a new ZReadOnlyQuery with the SQL 'select last_insert_id() as LID'. After you have done a Post and ApplyUpdates (I'm not sure if the last one is really necessary) of your Insert, close and open the LID query. Then you have ...

I've attached an example using ZeosDBO-6.1.5-patch2. I'think that is better use ZeosDBO-6.1.5-patch2 to start understanding Zeoslib, because is a stable version, so you don't mix your errors with Zeoslib bugs. PS: Look at file comment of attached file --- Ti ho allegato un'esempio che usa ZeosDBO-6....

Hello folks, I'm using Delphi 7, Mysql 4, and ZeosDBO 6.1.5 Is possible to have auto generated field values using TZQuery and TZUpdateSQL after an insert? Any suggest? Thanks a lot. PS: I can't use TZTable because I'have to fetch only few records from a big table that contains thousand of record. --...

I'want to partecipate to this project. Who am I: There are simple way to start to collaborate with you? I'm not a supercoder: I've made a simple TDBTreeView (a bit buggy, but working quite fine not released, I'm going to GPL it very soon); I'm developing an office application for my business using D...

zippo wrote:RecNo is also a TDataset implementation if I'm not wrong..

Yes it is, just a stilistic note!

Regards,
Andrea