Zeoslib Portal

I still have to test it but it looks real sweet.
thanks

True I really loved his comics. I know this is a silly question, but, from mdeams comment above maybe its worthwhile asking Jan (marsupalami) to explain to us how he creates a threaded connection. With a sample. Or example. This would be an education for me and and I sure for lots of Zeos guys out t...

Hooba, (marsupilami) Its not quite what I had in mind. The Switch from local to server is not the problem. What we need is the ability to pre assess the response state of the server before we hit it. If we look at the show processlist during a busy period w can see the long sql queries that take too...

What would be excellent is if we could get feed back from every sql command that takes longer than xx milliseconds. One could then somehow abandon the query and process it later perhaps.

Hi, Our application has local databases and posts to a server. If the server is offline (established by a failed ping) we post local and upload to the server when it is back online. This has served us brilliantly. The problem lies in the fact that occasionally the server is too busy to respond, but ...

Hi,
This problem was resolved by going around Delphi's limitations on the speed of loading large text files.
Its all good.
Mo

Sounds like its worth playing with.
Thanks
Mo

How many fields are you selecting. ?

M

Hi Spijker, I too have hit the wall with the same limitation.
Could not get a decent answer so I broke resultset into multiple part and linked them.
Hope this helps.

M

Hi Mary,
Do you wish to write the formatted value to the table, or read it from the table into a @variable?
Let me know which,
Both are easy.
Mo

Form1.test_Master_Detail; var Master,Detail:TzQuery ds_Master:TDatasource; Begin try Master:=TzQuery.Create(application); Master.connection:=Zconnection1; Detail:=TzQuery.Create(application); detail.connection:=Zconnection1; ds_Master:=TDatasource.Create(application); Master.sql.text:='select * from...

Hi Edson, This very simple. Form1.test_Master_Detail; var Master,Detail:TzQuery ds_Master:TDatasource; Begin try Master:=TzQuery.Create(application); Master.connection:=Zconnection1; Detail:=TzQuery.Create(application); detail.connection:=Zconnection1; ds_Master:=TDatasource.Create(application); Mas...

Hi Guys, The answer was actually quite easy. We all acknowledge the problem that Delphi has loading LARGE text files and this has a workaround. I am now able to load a SQL script file that is tens of megs with thousands of SQL commands, in seconds. If anyone needs the workaround, drop me mail. Live ...

Basically how can I get the ZSQLProcessor to load the huge query quickly.
The script.loadfromfile() is too slow.
Once the SQL is loaded into the script the execution time is very acceptable.

Hi guys, I often use the ZSQLProcessor thingy to run multiple SQL queries against a MySQL server in one go. It usually runs beautifully. More recently I needed to execute a HUGE SQL script. When loading the ZSQLProcessor1.script:=something the system appears to hang. I think maybe it is screening ea...