Bring to NAV a NULL field from SQL

txantxagorri
txantxagorri Member Posts: 23
edited 2008-11-04 in NAV/Navision Classic Client
How can i bring a NULL field from SQL??
Thanks!!

Answers

  • tinoruijs
    tinoruijs Member Posts: 1,226
    txantxagorri wrote:
    How can i bring a NULL field from SQL??
    Thanks!!

    Can you explain what you are trying to achieve? What kind of functionality do you want in NAV?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • txantxagorri
    txantxagorri Member Posts: 23
    I only want to bring one field and save it in a variable, and if this field in SQL is NULL i want to give a empty valor.
  • txantxagorri
    txantxagorri Member Posts: 23
    Thanks, but i have find a solution:

    IF ADOrs.Fields().Item('Field').ActualSize <> 0 THEN
    myField := ''
    ELSE
    myField := ADOrs.Fields().Item('Field').Value

    Byeeeee!
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Thanks for the feedback!

    Can you put (SOLVED) in the title of the first post?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Steele
    Steele Member Posts: 5
    Thanx , i was looking for an answer for this exact problem :)

Categories