MySQL error writing to a table

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

Posted by Jim Barbaruolo on March 08, 2012 at 13:24:48: Uploaded files: 2

I have been changing our Existing MySql ODBC coded programs over to the new MySQL interface code. The Comet32 compiled objects (and running under Comet32), write correctly to MySql Tables without a problem. However, If I compile the same programs under Comet(16), and run them under Comet32, a error occurs when the program attempts to write to the MySql table. The Error is as follows:

"You have an error in your SQL syntax; Check the manual that corresponds to your MySql server version for the right syntax to use near" followed by the data string in the write format, followed by ' at line 1'

It is my understanding that the MySql stuff should work compiled under either Comet16 or Comet32 as long as the program is executed with Comet32. Is this correct?

I have attached my code for review.

Thanks!

Follow Ups:


Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]