Zeoslib Portal

Got it to work :D Switching Metadata off did the trick. here is the sample code var con : TZConnection; oQry: TZReadOnlyQuery; begin con := TZConnection.Create(nil); //Set your MYSQL Connection info oQry := TZReadOnlyQuery.Create(nil); oQry.Connection := con; oQry.Properties.Add('useresult=True' ); ...

So after doing that was suggested by EgonHugeist, an error was thrown by MySQL Client "command out of sync! You can't run this command now". What I did is to use a "TZReadOnlyQuery" and added the ''useresult=True' to the TZReadOnlyQuery.Properties. Also made sure the IsUnidirecti...

Thank you for the response. As soon as I have tested these suggestions from you, I will give an update.

Good Day all, This is my first post so, it may be in the incorrect space. I am in the process of rewriting an in-house data management app from C# to Pascal using CT. The reason is that the app has to be able to run on the Linux Server that hosts the data and on Windows Desktops and the cross compil...