Put column data

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
georget
Posts: 7
Joined: Wed 02 Dec 2009 20:48

Put column data

Post by georget » Sun 19 Jun 2011 21:09

Hi-
We are having an issue with, I think, putcolumn data- using DelphiV and VistaDB all involves a column ENROLL. It is defined as VARCHAR(20) in both mysql on-line database and also in vistadb. It is defined as ftString in myLOADER. The column ENROLL in the local database contains data strings, like'2011-01-01'; on uploading the code raises a data conversion error and says '2011-01-01' is not a valid Integer

The load column line is: Sender.putcolumnData('ENROLL', indx,GetString('enroll')); The first row to be uploaded has '2011-01-01' in the ENROLL column

We put a list box on the form and losded the column ENROLL intoi a list box to see if the GetString was correctly used and everything works cool We just canot upload,so we are stuck

Thasnks,

Jennifer

AndreyZ

Post by AndreyZ » Mon 20 Jun 2011 10:53

Hello,

I cannot reproduce the problem. Please try composing a small sample to demonstrate the problem and send it to andreyz*devart*com, including a script to create tables.

Post Reply