Zeoslib Portal

Hi Guys,
Earlier on Bernard sent this link.

http://www.delphipraxis.net/164241-de ... ion.html

Follow it to the German site, Use Google translate and log in. Get the PDF and it will explain everything.
Its all good and it works.
M

You are a star! Thanks.
I downloaded the pdf and will give it a try today.

I have been following this thread and hoped that at the end there would some guidlines on how to actually go about installing Zeos on XE2.

I have included a procedure that will prove my point. If you try to open more than 255 fields it gives the error I mentioned. If column count is below then all is well. procedure TForm1.Prove_Max_columns_are_restricted; var mSQL:Tzquery; i:Integer; Number_Columns:String; begin try try Number_Columns...

Hi guys, I recently got a "Range Check error" when executing a simple "select * from tablename" and discovered that it was related to the number of columns in the resultset. It had nothing to do with the number of rows as I tried a table that had one row only. The minute I reduce...

Hi mDeams, I set the connection property to compressed, using all the various methods, and did not notice any change at all. My next option is to write a sever application which listens to the remote requests using sockets. Maybe I can compress the traffic between them myself. It would have been nic...

I think maybe I did not explain myself. Let me first comment on the mysqlimport matter. I have successfully used this utility to load data to a Mysql server. With compression. What I am trying to do is enable compression between the Tconnection and the Mysql server to reduce the traffic when a TzQue...

Hi Friends, If I select to text file, zip the file, copy the file over the wire, unzip and restore the records to a temp file, it is often much faster than a straight select. I am told that if there is a way of compressing the data that I send over the wire, at the level of the connection I could ge...

Hi
In the form's on close or close event try to :
If Zconnection1.connected then Zconnection1.disconnect;
This should close the open connection before the form is destroyed.
Regards
M

Dear Man Supporter,

Use the ZSQLProcessor component instead and load the sql strings into the ZSQLProcessor.script
Make sure that every separate command ends with a ;
then ZSQLProcessor.Execute;

regards
M

I tried installing Zeos on Delphi 2010 a few months ago and found that the distribution and installation was not yet clean and tidy. In my case I rolled back to my previous version and decided to wait for a cleaner installation for Delphi 2010.

Dear Mdeams, I have used the RowsAffected and "show errors" for a while now and while one gives me the number of insertions/edits/deletions , the other gives me the last error. Between the two of them I am able to get most of my work done. There are instances where I create multi-line sql ...

Often use the functions
show errors;
show messages;
but was hoping for a more elegant solution.

Dear Friends. I often send a series of queries, and one often depends on another. While I am able to get the rows updated, I often need to know more about the success or failure of the last query, and would love to know how. What I need to know is:. 1. Was the last query successful?. If not what was...

DevExpress DBPivotGrid.
Check it out.
All the glitz, really expensive, but worth every cent.