ADO Error

[AP81]

I have a mySQL database with a Delphi front end application. I use an ADO connection to access the database.

The database holds about 15,000 lines. Eveything works OK, except for one record.

When I try to insert the record, I get the following error message:

EOleException - "Parameter object is improperly defined. Inconsistent or incomplete information was provided."

Now, I tried re-inserting the record into the database (through my application) and found that the error came down to one line:

Payment can be deposited into the following account:

If I remove the colon, it will insert OK. If I put the colon back, it raises the exception again. However, if i add that line to any other record it inserts fine, so there is no problem with the text itself.

If I insert the information into the database (directly through command line) there is no problem, so I am guessing that it is an ADO problem.

I have also tried changing the data type from VARCHAR to TEXT, but it didn't solve the problem.

Can anyone help me?




------------------------------------
There's no place like 127.0.0.1
------------------------------------