Zeoslib Portal

Wild_Pointer , It's maybe a lot easier. When scanning a dataset row by row it shouldn't be necessary to set the hourglass. So can you test this solution: Set the hourglass when Rowcount = 0 (all rows) OR RowCount - CurrentRows.Count >1 (more than 1 row) Of course, that makes it still slower for peo...

bgzretry,
The only way to improve the performance is checking if the update statements use indexes.
Also, when NamaRs is a number field you shouldn't use quotes around the parameter in your query as they may make it impossible for the database server to use indexes.

Mark

OK, found the code. But you made your patch from new version to old version, so it's an inverted patch. But just looking to your patch makes me worry: wouldn't that only return 1 column for all tables? Adding 'and c.number = 0' looks to me 'allow only 1 column for each table in the resultset'. Can y...

This is a bug? No, it's rather a feature that's not supported for Oracle. If you want that behaviour with oracle you should use a TZSequence component to fill the auto-increment value. If I'm not mistaken it's almost impossible to retrieve the autincremented column in the oracle OCI interface the w...

NiksenH , Sorry for not reading your question good enough. Indeed, I remember the post you refer to. I see two possible solutions. - Write a TZAbstractRODataset method OpenFromIZResultset. When you publish that for the TZReadOnlyQuery that may work fine. - Make a component/class similar to ZSQLMeta...

Thanks Marco!

I hope we didn't upset you by doing some extra cleanup already. I only did the easy part (removing unused defines).
Don't hesitate when you see room for more improvements. The Delphi12_up stuff is still a huge job.

Mark

Actually, it would be nice if somebody tried to find out how exactly you can add a new plaindriver object for a specific dll with the new plaindriver model in zeoslib 7. When we rewrote this code we had the idea it would allow us to provide a feature that actually could create a new driver object ba...

Your icons are more clear, indeed. Would you be able to do the update for all icons? And could you manage to get them in the right formats for the source code of zeoslib? What I don't see is the small zeoslib icon that was in the old version. It gave the components some reference to the zeoslib comp...

Can the database file be readonly?

paweld , I'm wondering where you have found the original code line... 'sysobjects o on (o.id = c.id) where o.name = %s and c.number=0'. Maybe I'm just seeing over it... What's your exact zeoslib 6.6 version? Can you browse the code in the 6.6-patches branch and trunk on sourceforge to check if the ...

Hi Tintinux, I have no idea what the reason is or could be. Some guesses: - zeoslib strips part of the filename when spaces are included. Debugging the zeoslib SSL code for mysql can show this. See the ZDbcMysql.pas unit. In this case : send us a patch ith the fiw please - mysql expects a special fo...

Why are you using IZResultset instead of just using a TZQuery which IS a TDataset descendant??
If you have a reason to do this, that's alright for me. Then you can check the code in the components source directory of zeoslib to see how the conversion is done there.

Mark

Correction! Apparently there's some odbcsql package in the fpc source code directory. No idea if it can be used to start a new driver, however.

Mark

pingy,
As long as fpc/lazarus can't provide an oledb replacement and nobody writes his own odbc/ado driver for zeoslib this will not become available. There are 2 reasons for this:
- licence issue with oledb unit
- no volunteering developers to write a new zeoslib driver

Mark

pawelp,
You may be a candidate to use the testing-egonhugeist branch. This is a new effort to make zeos 7 work better with different codepages. It's written by a german, so you might even check with him directly if your case would be a good one to try his code on.

Mark