🚀 go-pugleaf

Hi there,

I'm trying to figure out the best way to interface between a client
application and a mysql server using ADO. I have tried using TADOTables with
data-aware components to automate the posting process - ie using TADOTable
methods Edit(), Insert(), and Post(). Unfortunately I encountered many
problems using this method, specifically when I tried to post Date values.

Another method I have tried was to use the TADOCommand component and build
SQL query strings based on what the user is doing then passing that string
through to the server. This seems to work well but involves a great deal
more coding and huge modifications to the existing program structure.

As I have little experience working with ADO I was hoping someone could give
me advice on which is the best option to choose given the above information.
If a solution was found to overcome the problem with posting Date values
using the TADOTable component (or some other component that allows
data-aware editing components to connect to it) then that might be the
preferred option.

Currently the MYSQL table I am using is of type InnoDB. I have tried using
TimeStamp, DateTime, and Date field types to post the date. Using the
TimeStamp field I receive an E_Fail exception if any of the TimeStamp fields
have blank data (the TimeStamp field does not allow null values for some
reason). Using the DateTime and Date fields, I receive "Row cannot be
located for updating" errors, although the row is definately available.

I am using MDAC 2.6 and MYSQL 4.0.16 running on a Win2k Server.

Any advice or help that can be offered would be appreciated,

Thankyou,
Jason
Invarion Pty Ltd