Zeoslib Portal

It may be helpfull to add a TZSQLMonitor to your project to find out what query is sent to the server for doing the update. Are the right conditions used, ...
The reason may also be that a BLOB field is used in a where condition that isn't encoded exactly the same as the original value.

Mark

Alex Rosa , Do you think you can get this working correctly for old and new fpc compilers on the 6.6.7 branch? I can't promise a 6.6.7 build within a few days, but if you can provide a working patch we can commit it. And after that I can start thinking about making another try of a 6.6.7 build. Mark

We know VInteger defined as Int64 but after I search at Unit ZVariant.pas Starting at Line 1081 convertion for Vint From String and attach using Integer conversion

Is this also true on 32 bit compilers? And isn't the conversion Integer() working correctly in 64 compilers?

Mark

I'll believe you

Committing it in testing branch now.

Mark

Seems more a question for the DataAbstract forum.

Mark

sfxcc , This would be an extremely difficult feature to implement as it involves evaluating the results you get from this refresh query and guess if the record is already in the dataset (and which record is it then?) or if it should be appended at the end of the dataset. So no... it's not a feature...

Example?

EgonHugeist , CompsSQL , It would be better if this could be introduced in statement (ZQuery) options. That way it can be set for the queries that need it. However, I just committed the patch to testing branch as it would only hurt in cases where not all records of the resultset are really fetched....

Meanwhile we fixed this by introducing the ZURL object as the prefered container for connection properties which takes care of escaping special characters, ... Functionality is unchanged for existing programs. However, now it's possible to store ; as part of the password which wasn't possible before...

Maybe a stupid question, but doesn't this change the way people connect to the database when using the dbc layer directly? Or does this not impact the connect string structure?

Mark

ism,
Thanks for this work! I'll have to figure out how to make the right resource files from these images.

Other users,
What do you think about these icon's? Better or worse?

Mark

sfxcc,

Did this work as expected?

Mark

Pyh,
If you only have one resultset, can't you use a TZQuery?
Connect using a TZConnection.
Then set the TZconnection.dbcconnection noticeprocessor.
Then open the ZQuery and read the data.

Wouldn't that work?

Mark

Does that mean: 'Yes, TEXT fields use less memory and behaviour is identical, so we will use TEXT fields'??

Mark

Actually, I'm wondering if it's desirable to show a resultset when using ExecSQL. That function should only be used to fire sql-statements that perform an Action (update, insert, create, drop, ...). Zeoslib is so nice to return an eventual dataset returned by an executed query, but maybe that makes ...