Zeoslib Portal

But what if I wanted to create the query inside the report at run time using a report dialog box.

Any one using FastReport 4.x and ZEOS 6.6.x can provide me with the db connection component for FR so I could be able to connect to the db internally from FR? The only one available in FR NewGroup is for FR 3.x. I have already asked at FR site. No one seems to be using ZEOS there.

After using the login prompt to connect to the database the value of User is blank why? It is blank even if I showed the User property onAfterConnect event.

The max_allowed_packet can be any number. But it needs a server restart to be effective.

As for changing your components to handle large packets, I don't know if it would worth the effort, but it would be better.

Thanks

Solution was simplerer.
MySQL max_allowed_packet variable was set to 1MB. I changed it to 3MB and the problem was solved.

Thanks

I'm trying to store a 2,737,152 bytes file in a MidiumBlob column. But after loading and then I post the record I get "SQL Error: MySQL Server has gone away." and the record is not saved. I don't know where it went!! :wink: But really why did it go away? BTW: I'm able to save size with les...

I don't know how far you got in the routines. But just to let you know:

http://www.sqlmanager.net/en/products/mysql/dbcomparer

I didn't completely understand the last sentence. But I have used on a seperate new application. I used the query with the field as mentioned above "cast(author as char) as author" and the update didn't work. Then I connected the query to UpdateSQL and it worked, as if the changes didn't h...

Thanks, I used UpdateSQL which is a better programming method (IMHO).

Didn't help. The property was true but one of the fields didn't update. The field is retrieved like this: cast(author as char) as author other fields did update. Come to think about it. My question was wrong. After Monitoring the statements with ZMonitor component I noticed that that only field didn...

I know that joins in a select makes a query not-Updatable. Does ZEOS knows that and how could I check if it is updatable or not?

I got confused by which folder I should use:
tags\6.6.1-beta\
branches\firmos_branch
branches\releases
branches\testing
trunk

for example RefreshCurrentRow procedure is not in tags\6.6.1-beta\src\component\ZAbstractDataset.pas file but is in the branches\testing folder.

Shouldn't the ZConnection version property be changed to reflect the current version no.
Thanks

You're right. Thanks again. Data was wrong.

I have a select statement with a function call in MySQL 5.0. It doesn't return any data with Query OK, -1 rows affected as a result, but I remove the function it returns the data I asked for. The result without using the function get 65000 records. What could be the problem? The function is listed i...