Datatype problem with ADO

NaveenReddy

Hi Guys,
I am trying to get data from Mysql database into navision, everything works good but when i try to get data from BIGINT datatype from Mysql navision is giving a error saying it doesnot support this data type.

Is there any way to get the data from BIGINT from Mysql to navision
using ADO. Error is generated at this line

ADOrs.Fields.Item('RecordNo').Value;
where ADOrs is activex data type and RecordNo is BigInt.

Thanks
Naveen Reddy

nelson

Maybe you can try the following work around:
http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=8011&SearchTerms=ado
It's for a different unsupported data type but it may also work for bigint.

NaveenReddy

Thanks Man,
It works Great...this what i did



Try defining a function called "ReadADOFieldDecimal"


Local Parameters
adField Automation 'Microsoft ActiveX Data Objects 2.7 Library'.Field
Local ReturnValue
DecimalValue Decimal
Local Variables
adStream Automation 'Microsoft ActiveX Data Objects 2.7 Library'.Stream

Code
CREATE(adStream);
adStream.Open;
adStream.WriteText(adField.Value);
adStream.Position := 0;
IF EVALUATE(DecimalValue,adStream.ReadText) THEN ;


Then call the function:
NaviTable.NaviField := ReadADOFieldDecimal(adRecordset.Fields.Item(FieldNo));