Search found 81 matches

by mparak
09.04.2006, 00:04
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Stupid Question - Raising errors from Delphi 5.0
Replies: 3
Views: 3489

Stupid Question - Raising errors from Delphi 5.0

Dear friends, Unless I stick all database (Zeos - MySQL) activity between the following error trap, I get no feedback for SQL errors. Clearly I need to change some setting in Delphi to be more strict with errors. Try // // Database activity here // Except on e:Exception do ShowMessage(e.message); En...
by mparak
04.04.2006, 07:04
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Using SSL security to protect MySQ server
Replies: 3
Views: 3897

Using SSL security to protect MySQ server

We have setup a host of servers using dynamic IP mapping and while the standard username password seems a reasonable measure of privacy, we need to furhther encrypt the traffic. SSL seems to be the answer, (If we only knew how to get the Zeos components to be aware of the layer) Any ideas, ? Warmest...
by mparak
27.03.2006, 08:06
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Get mysql_affected_rows() in Delphi
Replies: 2
Views: 3260

Thank you, It obviously helps to "phone a friend"

The answer you gave was elegant and simple. I am just surprised that I struggled with something that obvious.
Well I suppose we often "over think" a problem when in fact the solution is staring us in the face.

Warmest Regards

M Parak
Durban
South Africa
by mparak
26.03.2006, 13:52
Forum: ZDBC (ZEOS Database Connectivity)
Topic: MySQLDump and Restore from within Delphi
Replies: 3
Views: 6559

MySQLDump and Restore from within Delphi

Hi I recently needed to copy a medium sized table (200 000 records) from a MySQL server to the local MySQL database. My users have no file shares to the server and can access MySQL only. As we could not find a reliable and fast method we resorted to a primitive method of contructing a batch file (te...
by mparak
26.03.2006, 12:35
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Get mysql_affected_rows() in Delphi
Replies: 2
Views: 3260

Get mysql_affected_rows() in Delphi

I am a newbie to this forum and am unsure of how all of this works. What I need, is a little help with getting the results of my Insert, Update, Delete queries. The Mysql help forums suggest the mysql_affected_rows() function but I am unable to find a way to use this (PHP?) function using Zeoz in De...