Delphi MySQL
Hello lists,
Hello list,
This is my third re-mail on this topic.
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc etc.
I have a very basic project using OOP, Delphi (6), ODBC, ADO Data Aware
Components, Access and MySQL(4.1).
In fact I have two projects, identical except that one connects via odbc to
Access and the other to MySQL.
Briefly:
The project connects with TADOConnection, TADOTable and TDataSource, and
consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read only),
and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
this with full read/write options.
Attempts to write to Access succeed where attempts to write to MySQL fail,
all other things being equal. The MySQL error return states:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near ','detail' SET '('
So far as I can see, all MySQL permissions exist for read/write access to
the DB.
My confusion arises from the fact that to give entry level experience, I
chose data aware controls which I presumed would not need coding to function
at a basic level. This works with Access but apparently not with MySQL.
Clearly I am missing something fundamental regarding differences between
MySQL's and Access's interactions with data aware components.
Can anyone suggest what it is that I am missing and how can I coax my
project to write to MySQL?
Please can you quote my Ref 'Query 2003048'.
With thanks in anticipation,
john
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/03
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Delphi MySQL
Hello lists,
This amends my third re-mail on this topic.
Sorry about that: A point to clarify is that the writes are done using the
update button of the DbNavigator.
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc etc.
I have a very basic project using OOP, Delphi (6), ODBC, ADO Data Aware
Components, Access and MySQL(4.1).
In fact I have two projects, identical except that one connects via odbc to
Access and the other to MySQL.
Briefly:
The project connects with TADOConnection, TADOTable and TDataSource, and
consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read only),
and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
this with full read/write options.
Attempts to write to Access succeed where attempts to write to MySQL fail,
all other things being equal. The MySQL error return states:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near ','detail' SET '('
So far as I can see, all MySQL permissions exist for read/write access to
the DB.
My confusion arises from the fact that to give entry level experience, I
chose data aware controls which I presumed would not need coding to function
at a basic level. This works with Access but apparently not with MySQL.
Clearly I am missing something fundamental regarding differences between
MySQL's and Access's interactions with data aware components.
Can anyone suggest what it is that I am missing and how can I coax my
project to write to MySQL?
Please can you quote my Ref 'Query 2003048'.
With thanks in anticipation,
john
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/03
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Delphi MySQL
Briefly:
The project connects with TADOConnection, TADOTable and TDataSource, and
consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read
only),
and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
this with full read/write options.
Attempts to write to Access succeed where attempts to write to MySQL
fail,
all other things being equal. The MySQL error return states:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near ','detail' SET '('
So far as I can see, all MySQL permissions exist for read/write access to
the DB.
My confusion arises from the fact that to give entry level experience, I
chose data aware controls which I presumed would not need coding to
function
at a basic level. This works with Access but apparently not with MySQL.
Clearly I am missing something fundamental regarding differences between
MySQL's and Access's interactions with data aware components.
Can anyone suggest what it is that I am missing and how can I coax my
project to write to MySQL?
Please can you quote my Ref 'Query 2003048'.
I need more information to help you solve this problem:
1. Did you use default setting of MyODBC?What version? Show me your
connection string.
2. TAdotable:what kind of locktype used?
Try to save use delphi Dataset command like:
TAdotable1.UpdateBacth(); //if you use ltBacthOptimistic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Delphi MySQL Access Components
Hi, You can have a look at the Delphi 56/Kylix 12 single source components from SciBit at www.scibit.com/mysqlcomponents. Kind Regards SciBit MySQL Team -Original Message- From: Pierre du Parte [EMAIL PROTECTED] To: Daniel Kiss [EMAIL PROTECTED] CC: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Delphi MySQL Access Components Sent: Thu, 25 Jul 2002 00:39:12 GMT Received: Thu, 25 Jul 2002 03:02:11 GMT Read: Sat, 30 Dec 1899 00:00:00 GMT Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delphi MySQL Access Components
Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi MySQL Access Components
Daniel, Wednesday, July 24, 2002, 11:23:05 AM, you wrote: DK Can someone tell me what is the best MySQL native component set for Delphi? DK It does not matter if it is commercial, but I need one urgently. I'm not a professional with Delphi+MySQL, but Zeos Library looks fine for me: http://www.mysql.com/downloads/contrib.html You can also find some other Delphi interfaces for libmysql.dll there. I have tried all and decided to use Zeos... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Delphi MySQL Access Components
Hi, Yes, I'm using it actually, but I ask te author if MySQL features will be extended to stored procedures, when will he come out with the new version. He told me that he finished the development of the component set and gave it to sourcesorge.net to continue it. Anyway, the newest version of it is still in beta state. And it never will be finished. So, any other ideas? Thanks, Daniel At 17:22 2002.07.24. +0800, you wrote: Use WinZeos component for delphi 6 Search it on GOOGLE It helps me too R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: Daniel Kiss [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 4:23 PM To: [EMAIL PROTECTED] Subject:Delphi MySQL Access Components Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi MySQL Access Components
Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi MySQL Access Components
Hello Daniel! It works fine. Been using it for several years. Close your connection and query objects and there will be no AV problems... Fredrick - Original Message - From: Pierre du Parte [EMAIL PROTECTED] To: Daniel Kiss [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:39 PM Subject: Re: Delphi MySQL Access Components Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delphi Mysql
What is the best way to connect with Delphi 5/6 to Mysql? Johan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi Mysql
ASTA at www.astatech.com M:) What is the best way to connect with Delphi 5/6 to Mysql? Johan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi Mysql
Hmmm... If your just requiring two tier client server there are several. This one is open source and free. http://sourceforge.net/projects/zeoslib - Original Message - From: Proliant Business Solutions [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, June 10, 2002 2:07 PM Subject: Delphi Mysql What is the best way to connect with Delphi 5/6 to Mysql? Johan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delphi MySQL w/InoDB
Is anyone using ZEOS and Delphi with MySQL w/InoDB? I am wondering how the transaction stuff runs or if it even works with this combination. Many Thanks M;) MySQL database sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
