Datatype problem with ADO

NaveenReddy
NaveenReddy Member Posts: 53
edited 2005-09-13 in Navision Financials
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

Comments

  • nelson
    nelson Member Posts: 107
    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.
    Nelson Alberto
  • NaveenReddy
    NaveenReddy Member Posts: 53
    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));

Categories