Zeoslib Portal

Sorry, I did miss the EnableControls... Do you have anything attached to this query's Before/AfterEdit, or Before/AfterPost? That may be interrupting the process flow of the loop. If So, you may want to disable them and re-enable at the end. ZQuery.AfterPost := nil; try ... finally ZQuery.AfterPost ...

You call DisableControls, but I don't see you calling EnableControls. You also call Application.ProcessMessages in your loop. I understand why you are doing so, but that may cause side-effects. You may want to disable the control used to enter this procedure (such as BitBtn?) as you enter, and re-en...

I have a MySQL database using UCS2_UNICODE_CI collation. I connect to it via Zeos 7.1.3a, within Delphi XE2 (x32) Zeos is configured: ClientCodePage := 'UTF8'; ControlsCodePage := cCP_UTF16; AutoEncodingStrings := True; etc... I have no issues when I post/retrieve Text data from a blob field, I can ...

Had not seen that before, but none-the-less, if you follow the link you get this SQLITE_ENABLE_UPDATE_DELETE_LIMIT This option enables an optional ORDER BY and LIMIT clause on UPDATE and DELETE statements. If this option is defined, then it must also be defined when using the 'lemon' tool to generat...

why is tablename not allowed to set by a parameter? I'm sure there's a reason, but I don't know of any connection component that allows table name value to be a supplied by a parameter. Why does "LIMIT 1" at the end of the upper statement (with corrected table name part) cause the same er...

I think the issue is that you are using a parameter for the table name value. I believe that is not allowed.

Thanks for the quick turn around. Solved the problem.

Much like as explained at the post here: http://zeoslib.sourceforge.net/viewtopic.php?f=38&t=8386 I am also this same error. I am using ZEOS 7.1.3 Stable. I get this error on a ZQuery.Post using MySQL. I see that the patch provided in the other link is for Interbase, so while I applied the patch...

I ended up deleting the ZQuery and Datasource components, added them again, with the same query, and the after adding the fields in the fields editor, I checked the definition of num_days. This time it correctly declared num_days as TLargeintField. Everything seems to be working.

I'm using ZEOS 6.6, Delphi 2006 and MySQL 5.1. I have two different queries with similar selects, that is producing two different declaration types in Delphi The 1st query select ... datediff(curdate(), date_received) as "DaysInLab" from ... The 2nd query select ... datediff(date_closed, d...