Zeoslib Portal

Hi!

I wonder if is there any way to save a Zeos TZQuery in any way and later restore it back. The possible ways can be a file, a stream, a comonent... etc.

I usually use error string parsing. It works perfectly for my needs. except on E: Exception do begin Result:=false; KnownError:=false; if Pos('Access denied for user',E.Message)>0 then begin // Unknown user KnownError:=true; ErrMsg:='Wrong user'; end; if Pos('Can''t connect to',E.Message)>0 then beg...

I've done it the manual way: Editing DFM files. Be aware that TZQuery.ShowRecords property will magically became empty, so you will need to restore it. Hope it's not a too big project...

I found the error - character # is not allowed.. Thanx - your suggestion helped me a lot!

Good idea.. I'll try

Hi! After a long and happy living with Zeos I have a strange problem and I'm stuck here for several days, grrr.... Upon executing the Processor.Execute method I get an error. Delimiter is set to dtSetTerm. If I runt the script directly in MySQL Query browser, it works OK. I somehow can't understand ...

You're welcome! I'm glad another problem is solved (even if you solved it by yourself, he he he)

More options to test: - Is CachedUpdates set to true? Then set it to false. - Is ReadOnly set to true? Set it to false. - Are you updating a MySQL view instead a table? Try to open another table. - Try to add a Button on the form and write this OnClick event: Dataset.Edit; Dataset.FieldByName('FIELD...

Try to copy it to the application path. Could still not work in design time, but in runtime it should work.

Suggestion: Do not use spaces in table names. Could be a real pain in the ass in database migration (especially to a different type of server)...

1. Check the DLLs
2. Is the query created at runtime? If yes, check the Connection property,.. etc.

if nothing works, post an example source + db.

I have the same problem in a BDS 2006 + MySQL 5.1 application. No threads here.

Sorry, to far for me too... But if I can "remote" help in any way ...

Hello to Slovenia, too.. BTW: When needing commit/rollback control, I usually do it directly via SQL statements, but I admin it is mainly because some bugs in Zeos 5.x ..