Null Field

[svsuthar1]

I have a check on my Action form where it checks for the field to be not 0 to add to the database... is it possible to be Null... I am not haveing any luck on that...I have tried the following things...

not ISnull(field) and field <> ""

please advise

thanks,

Samir

 

[svsuthar1]

I am trying that, but it give me syntax error Type mismatch string "". The thing is that it stops only when it finds a null value for that field else it saves the other information to the database.

Samir

 

[Chopstik]

Please write the specific line that is generating the error. Also, it might be a good idea to response.write out that variable (the strQuantity variable) to see what it is actually producing.

------------------------------------------------------------------------------------------------------------------------
If you don't have a sense of humor, you probably don't have any sense at all.
- Anonymous

 

[MoLaker]

I think strQuantity is a string and will never be null. It can only be empty or greater. Try

If len(trim(strQuantity)) > 0 Then

 

[svsuthar1]

I am sorry guys I got all of you involved on this... I was updating my back file and not the file that need it to be updated... sorry all for the confusion... It's working with simple strQuantity <> "" Then...


I apologize for this post... it should not have been posted... I give all of you star...

Samir