I have connected Navision to a SQL database using ADO. Certain fields though are causing the following error: This message is for C/AL programmers: This data type is not supported by C/SIDE. You can access data from any of the following data types: VT_VOID, VT_I2, VT_I4, VT_R4, VT_R8, VT_CY, VT_DATE, VT_BSTR and VT_BOOL I saw a previous post which talked about using an Ado.Stream object to handle these values first, but I am getting a type mismatch error when I do this. Any other solutions for this problem or more insight on the Ado.Stream solution? [Duh!]
I have found the reason why the ADO.stream fix doesn’t work for me. The Type mismatch error I am getting is due to the field being null. If I filter out any null values then everything works. Anyone have experience using ADO Streams when null values are involved?
quote:
I have found the reason why the ADO.stream fix doesn’t work for me. The Type mismatch error I am getting is due to the field being null. If I filter out any null values then everything works. Anyone have experience using ADO Streams when null values are involved?
Originally posted by jwilder - 2005 Apr 19 : 13:33:58
is not possible to use fields being NULL - wk-text := varobject.value where varobject is field in automation you can use
wklen := varobject.actualsize; evaluate(wk-numeric,wklen); if wk-numeric > 0 then wk-text := varobject.value;
bye
Moved to SQL Forums