Zeoslib Portal

Try to change the TTable ASAP after setting up the application. I had the same problem and after digging a little bit on the code I had a massife speedup - i mean REALLY extreme. I suggest you to take some time on this..

Use the backslash

Happy you found the problem.

Yes, could be - I also had quite a lotof problems on a Win98 client connecting to MySQL server on another machine. I've read somewhere that it was a 9x - NT incompatibility...

could be a DLL problem?

oopss.. BDS user..

Can you specify which version of Turbo Delphi are you using? Somewhere I read that Explorer version is not allowed to add any additional component.

.. or find some old Zeos 5.x and open the ZExtra.pas file - it's full of useful procedures.. Even with 6.x I'm still usingit!

I think the idea is to get a full SQL dump, old plain ASCII ..

What's the exact SQL sentence that you are trying to execute?

I'm not 100% sure, but I think you will need to uninstall version 6.1 befor installing the new version. Don't forget to clean ALL the files (especially *.BPL-s)!

About "Application work": Who knows...

Try win1251 instead of cp1251

Try to set it when the connection is started. I do this in the OnConnect event

query1.sql.text = 'SET NAMES cp1251'
query1.execsql;

But include a try-except for non MySQL 5 servers (ex. 3.23.50)

I think it can be done via a special component called ZSequence or ZProcessor (can't remember and didn't used it until now).

No, not so bad, to be honest.

Example of stored procedure usage throug TZQuery:

Query1.SQL.Text := 'Call MYSTOREDPROC()';
Query1.ExecSQL;

Or

Query1.SQL.Text := 'Select MYSTOREDFUNCTION()';
Query1.Open;

It excellently works for my needs... Hope it helps.