Zeoslib Portal

Try this simple code in D2009: var s:string; p:PAnsiChar; begin s:='ŐőŰű'; p:=PAnsiChar(UTF8String(s)); showmessage(p); end; IMO the problem is that Zeos typecasts string type (multibyte UnicodeString in D2009) to PAnsiChar (byte-sized type) for calling the mysql API. For example: function TZMySQLEm...

'show FULL tables' doesn't implemented in mysql 4.1.16, only 'show tables'.
maybe there's other errors on mysql below 5.0.3. check your mysql docs and write the right statements to zlawmysqlbackup.pas.
i uploaded a new version to the first post with some bugfixes and some new features.

hi Mark yes, with this workaround can't process multiple results with zdbc interface. but i guess if someone can use this 'low level' interface, he doesn't need this workaround. anyway, zdbc is too high for me, hahh. as i can see, the CALL stmt always returns more resultset (or work like this way), ...

when running a stored proc with call stmt on mysql, the next statement will raise a Lost connection to mysql server error. this is because multiple-result processing is required when calling a sp with call stmt (see http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html ). zeosdbo proces...

piper62's idea is foolproof. here's the corresponding part of the mysql 5.0 reference: "You can retrieve the most recent AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. These functions are connection-specific, so their return values are not a...

I wrote a component to create backup from databases. Sorry for posting here, I can't find any email address to zeos dev.team. Delete this thread if this is not the right place for posting this component. Component for Delphi (tested on D7) to backup MySQL databases (5.0.3 and above) based on ZeosLib...

Yes, it doesn't look very nice. I wrote it to log in users to the application. This method worked perfectly in D4 with BDE. I rewrote this part of my code, placed the log in code to MainForm.FormShow, but the form shows then closes if the user click cancel on log in form. It doesn't look very nice t...

Running a query in TZQuery without Application.Run in the project source cause Runtime error 216. See the uploaded demo project.