SQL Read String

[robbudge]

Hi all,

I have a manual MySQL insert, that creates a new record in the SQL , with some basic data

Job Number (SQL 'text') start_time (SQL 'Double') Logging_Tag( SQL 'Double')

I have tried using Db.Query & db.QueryToClass with the same result.

if the Job number is purely Numeric everything works fine.

As soon as the job number is Alpha Numeric i get no job number data

it would appear that the query result buffer is purely numerical.

Anyone know of a way around this ?????

[AzeoTech]

DAQFactory won't read BLOB string fields in. It will treat them as numeric data. You need to use either CHAR or VARCHAR field types.