Zeoslib Portal

Hello Josef,

You want to pass the column name for your "order by" as a bind variable? I don't think that this is possible.

Best regards,
Rüdiger

Hi Markus,

I thought, when doing a (Z)Table.Open, all records are fetched at once. That's why I always prefer Queries. Am I wrong here?

Best regards,
Rüdiger

Hi Ben!

What kind of problem? I never use CachedUpdates = True, but without ApplyUpdates... nothing in the database, as mbranco has experienced.

Hi!

After ztDocumentos.Post you have to add
ztDocumentos.ApplyUpdates
Only this will bring the posted data finally into the database. It took me some time too to get to that (thanks to the old forum).

HTH
Rüdiger

Query: select * from ANAGRAF where ANA_EAN = :ANA_EAN
before Query.Open: Query.ParamByName('ANA_EAN').AsString:=COD

same for Insert and Update

This surprises me. Is there an index on ANA_EAN? I wouldn't use RecordCount. You could use ZQry.EOF instead. And maybe (I'm not sure about MySQL) using bind variable can speed up queries. With Oracle that would help a lot.

@raider:
The error you cited above comes when you try to install such a package, not by compiling. When something is wrong with compiling, you get "normal" Delphi errors.

Can you execute this update statemeint in the mysql command line tool (mysql) on both systems and see if it is slower on Linux too? Maybe making a script out of your text file. Another thing: what part is slower: the locate or append or insert? If time is important for you maybe it would be better t...

Strange, really. Have you tried to run it in debug mode? Put a stop point on the first query.sql.text:=... and then proceed with F8. Watch if the curser stops a short time on the exec or if it goes right on to the next statement. That would mean that the exec "comes back" before the stored...

If I'm right (haven't done it for some time) it compiles allright when the compiler finds the .pas files. So if you set the project search path to the src folders, as I wrote in my first posting in this thread, it should work.

Greetings,
Rüdiger

You must only compile this package, not install. This is the matter with all packages but ZComponent. Install is only for packages with icons on the palette.

HTH
Rüdiger

But what happens when you don't use sleep? What kind of error message?
Do I understand you right that it depends on the length of your procedure (in that way content matters!) how long the sleep must be?

Slow concerning what? On the same machine (dual boot)?
Has it something to do with Zeos? And if, when? Connecting, opening a query...

I don't think that TZQuery can do that. Take a look at TZSQLProcessor, it has a "script" property where you put your statements in.

Mmh... Open is always better when retrieving a result set, which your second query does. What does your procedure? Another thing: when you are typing these commands at the mysql command prompt, the pause between your first and second pressing "enter" will be longer than sleep(500) which is...