Zeoslib Portal

I had a quick look on the web and I can't seem to find a way to get the encodings supported by Postgres.

Does anyone know how to get this?

Sandeep

Ok I'll have a look at and see if there is something in database that I can use to get Encoding. If there is something I'll add a function, as you suggested to metadata units.

Sandeep

I need to show those options in a combobox. I have a app where the user can select the Encoding for a database.

Sandeep

Hi

I need to use CS_Table array in ZDbcPostgreSqlUtils. It is not exposed would it be alright if I put it before Implementation?

Regards

Sandeep

In Zeos with Auto Commit set to True a Transaction is started as soon as the connection is made and committed after that for every operation done(I think that is correct, not 100% sure there). I was wondering what effect it might have to leave the transaction inactive(not calling StartTransaction) u...

Hi Mark I have made some changes to GetIndexInfo method. Please look at them and see if they look alright. function TZInterbase6DatabaseMetadata.GetIndexInfo(const Catalog: string; const Schema: string; const Table: string; Unique: Boolean; Approximate: Boolean): IZResultSet; var SQL, Key: string; b...

Hi Someone on Codegear's newsgroup asked if Zeos still does CommitRetaining when commit is called. I thought Zeos must be doing hard commits but it turns out it does CommitRetaining. This might have a serious effect on 24x7 systems. Hasn't anyone faced this problem yet? Should something be added to ...

To create a SQLite database you need to setup the database file properties in TZConnection and when you connect the database file will be created.

Regards

Sandeep

Hi Mark

I have tested the branch 358 and it works fine with and without ValidateUpdateCount.

Sandeep

Hi Mark I have done the changes. procedure TZGenericCachedResolver.PostUpdates(Sender: IZCachedResultSet; UpdateType: TZRowUpdateType; OldRowAccessor, NewRowAccessor: TZRowAccessor); var Statement : IZPreparedStatement; SQL : string; SQLParams : TObjectList; lUpdateCount : Integer; lValidateUpdateCo...

Have you set the Protocol property of the connection?

Sandeep

Hi I have changed the following function in unit ZDbcGenericResolver to warn if update count <> 1. procedure TZGenericCachedResolver.PostUpdates%u28Sender%u3a IZCachedResultSet; UpdateType%u3a TZRowUpdateType; OldRowAccessor, NewRowAccessor%u3a TZRowAccessor%u29; var Statement%u3a IZPreparedStatemen...

One more thing, It looks like there is no way to get hold of TZQuery.Properties in TZGenericCachedResolver.PostUpdates.

Any ideas how I should go about this?

Sandeep

What should I call this switch?

Should I use something like 'AllowZeroUpdateCount=False'? If this is found then exception is raised.

Sandeep

Ok, we'll do it your way. I agree we should try and keep things simple. Conclusion ( I think): Every updatecount <> 0 is an error In version 6.6 this can raise an error IF requested explicitly by setting a query property In version 6.7 this should raise an error UNLESS this is disabled explicitly by...