Zeoslib Portal

Hi.

Thnx for the reply. That was actually what i tought might be the reason. But, when i looked closer at my code, the Locate on the MySql-table on (ACPI_ID) isnt a string, it is actually an integer, wich makes it pretty strange...

Hi. Im trying to optimize my code somewhat. Usually when i only do an update from a SqlServer-query to an MySql-table it goes very fast. Altough this seems to differ from table to table. if not (Locate('ACIP_ACPI_ID;ACIP_ACIPT_ID',VarArrayOf([ADOQGeneral.FieldByName('Va_Ref_Id').AsString,'1']),[])) ...