Put column data
Posted: 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
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