Bring to NAV a NULL field from SQL

txantxagorri

How can i bring a NULL field from SQL??
Thanks!!

tinoruijs

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?

txantxagorri

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

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

Thanks for the feedback!

Can you put (SOLVED) in the title of the first post?

Steele

Thanx , i was looking for an answer for this exact problem