ADO in 5.0

gulamdastagir

i have used ADO to insert data into 4.3 DB

but with NAV 5.00 when i run the same code its not inserting data into some fields of certain records whereas for other records in the same table it works fine.


](*,)

Waldo

I doubt this has something to do with the 5.0 version.

Is it always happening with the same table/fields?
What does the debugger tell you?

gulamdastagir

the code written in 4.3 uses field references and record references to insert data into navision tables using the C/AL Validation present in Navision.

however,the same field references and record references dont work in NAV 5.0 and when i debug it just gives a "break on error" message at the line

if NavisionFieldNumbers[i]=5702 then

](*,) ](*,) ](*,)

garak

No, ther must be the error befor the if statement,

let us see more code

David_Singleton

gulamdastagir wrote:

i have used ADO to insert data into 4.3 DB

but with NAV 5.00 when i run the same code its not inserting data into some fields of certain records whereas for other records in the same table it works fine.


](*,)

I had an issue with insert code that worked fine on 4.00sp2 excutables but woudl not work in 5.00

The thread is here: NAV 5.00 SQL problem with INSERT(TRUE)

Maybe its something similar. Maybe try the same change that I did and see if that works.