devxlogo

Detect Null Or Zero-Length Fields In A Database

Detect Null Or Zero-Length Fields In A Database

This syntax is much faster than using an If.Then.Else construct to detectnull or zero-length fields, and it will ensure that an error will not occur.For strings:

 Dim sVar As String.sVar = "" & ds!sField

For numbers:

 Dim nVar As Integer.nVar = 0 & ds!nField

This assumes that ds is a dynaset and sField and nField are two fieldsin that dynaset.

devx-admin

Share the Post: