Zeoslib Portal

Thanks for help, I'll try it.

Jiri Matejka

Hi, i'm using Zeos DBO 6.6.0, MySQL 5.0.41 and I need to retrieve result set from stored procedure. I've used TZStoredProc with params like this: StoredProc1:=TZStoredProc.Create(nil); StoredProc1.Connection:=Connection1; StoredProc1.Params.CreateParam(ftInteger, 'param1', ftInput); ... other params...

Hi Mark, thanks for your reply, I'll check it out. I forgot to write that there is a dirty trick to avoid this problem using following query: SELECT CONCAT(p.note,'') FROM table WHERE... So it's enough to concat the field with empty string and than it is correclty considered like string not like mem...

Hi, I use ZeosDBO 6.6.0 and I have a following problem: I use TZQuery to run command "SELECT p.note FROM (oper_premiums p) WHERE p.premid=100" and TDataSource with TDBGrid to display results. When table name is in brackets that the field p.note is considered like memo and shown like memo i...

Thanks, so do you thing the best way (in terms of speed and stability) is to set autocommit to true and use StartTransaction (with automatic switching to autocommit=false) only for statements that require using of transactions?

thanks

Jiri

Hi Mark, thanks for reply. So how can I start transaction manually without StartTransaction? Does it mean that when I call ZConnection.Commit or Rollback then it starts new transaction automatically? I use StartTransaction a lot in my code, mainly in data update or insert blocks... start transaction...

I've installed Zeos DBO 6.6.0 beta, connecting to MySQL 5.0.27, Delphi6 Professional. I have a following problem with ZConnection.AutoCommitMode: When I set ZConnection.AutoCommit to False, then while calling TZConnection.StartTransaction it always raises an exception "Invalid operation in non ...