Zeoslib Portal

I'm using the official version 6.6.2 RC.

This code doesn't contain this fix.
I've inserted this fix into my code and it works!

Thx alot for all that help.

Can you close the Bugtracker issue, please?!

http://zeosbugs.firmos.at/view.php?id=121

// if Property ValidateUpdateCount isn't set : assume it's true lValidateUpdateCount := (Sender.GetStatement.GetParameters.IndexOfName('ValidateUpdateCount') = -1) or StrToBoolEx(Sender.GetStatement.GetParameters.Values['ValidateUpdateCount']); lUpdateCount := Statement.ExecuteUpdatePrepared; //---...

Ok, let's see what we get. I'll get into the procedure TZAdoCachedResolver.PostUpdates and the UpdateType is utInserted, what seems to be ok. The FAutoColumnIndex is not bigger than 0 and OldRowAccessor.IsNull(FAutoColumnIndex) is false. Whatever it means. So the condition: if (UpdateType = utInsert...

I poorly understand your procedures so it's hard for me to debug *g*,
but i'll give it a try.... tomorrow.

thx so far.

Hi Mark, i've tried it with MS SQL Server 2005 and Michael has tested it against MS SQL Server 2005 Express. I use ADO as protocol with SQLOLEDB.1 as provider. I can't say what dll version is used. Sorry for that german. The inserts and the updates are not in the Monitor log. There are only the stat...

Hi Michael, ich antworte mal auf deutsch, ich hoffe, dass ist kein Problem. ein TZUpdateSQL noch mit einzubauen ist für uns leider keine geeignete Lösung. Wir haben eine Software, die mit Firebird 2.0 und MSSQL arbeiten soll. Mit Firebird funktioniert ja auch alles soweit und mit den "alten&quo...

Hi, i'm connected to MSSQL_Server via ZEOS Version 6.6.2-RC. When I send direct Statements to the Server everything is fine: zquery.sql.text := 'SELECT * FROM TEST'; zquery.open; or even zquery.sql.text := 'DELETE FROM TEST WHERE bla'; zquery.execsql; But when i try to insert or append like: zquery....

Oops, sorry.
I thought I did it so...

BUT you solved my problem

I've tried my Demo in a VM to check which dlls you need and realized that i've been using still the embedded Version of FireBird 1.5.

With FB20 embedded it works as expected. So it wasn't a ZEOS prob.

Hi there, unfortunately my problem still exists. I've tried it with version 6.6.2-RC and FireBird 2.0. The problem occurs only with the embedded version of FireBird, the server works fine. To demonstrate the problem I've created a simple Demo to reproduce my problem. It's to big to attach, so you ca...

Hi, we use the zeos library V6.5.1 and FireBird V1.5. In order to sort a Query in a german format, so that ä comes after a and not after z, I set the charset of the db to ISO8859_1. In IBExpert the Query 'SELECT NAME FROM TABLE ORDER BY NAME' returns the values in the correct order. But if I try to ...

I've searched the sources for this prob and in ZDbcAdoStatement on Line 471 there is a comment: "Please fix"??

Is it possible that the function TZAdoCallableStatement.GetOutParam causes my prob?


(Sorry, for my english, sounds cruel)

Hm, liegt wohl doch nicht am Jet.OLEDB - Provider:

Access-Version/Jet-Format
-------------- ----------
Access 2.0/Jet 2.0
Access 95/Jet 3.0
Access 97/Jet 3.0
Access 2000/Jet 4.0
Access 2002/Jet 4.0
Access 2003/Jet 4.0

Laut Microsoft zumindest.

hi,

danke für deinen Hinweis, werd da mal weiter suchen. Ja, es ist Access 2003.
Die Tabelle sollte es auf jeden Fall geben und wg. SQLite: mit Firebird geht's auch *g*

Allerdings muss ich leider auch Access unterstützen.
Aber ich schau mal.

Hi, I try to access a MS-ACCESS-DB with Zeos. My table "Tabelle1" has 3 fields ID, TEXT, BOOL. (I know, TEXT is a reserved word, but with other fieldnames it's the same prob) ID is an AutoInc-field, TEXT a string- and BOOL an integerfield. To get the datasets and show them in a grid is no ...