ADO in 5.0

gulamdastagir
gulamdastagir Member Posts: 411
edited 2007-08-17 in NAV/Navision Classic Client
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.


](*,)
Regards,

GD

Comments

  • Waldo
    Waldo Member Posts: 3,412
    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?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • gulamdastagir
    gulamdastagir Member Posts: 411
    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

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

    GD
  • garak
    garak Member Posts: 3,263
    No, ther must be the error befor the if statement,

    let us see more code
    Do you make it right, it works too!
  • David_Singleton
    David_Singleton Member Posts: 5,479
    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.
    David Singleton

Categories