Need help checking null values in text type fileds in Visual Basic 5

[Jeev]

Hi

I am working on a project in Visual Basic 5 and SQL Server 7 as database where I need to insert and update data in text type fields.

The problem I am facing is that whenever I check for null values in text type fields I am getting an error trying to insert or update.

Is there a way to check for null values in text fields and bypass it if its true.

Any help would be highly appreciated.

Thanks in advance.

[Ecniv]

isnull function

add & "" to make it a blank string

[Jeev]

Hi

Thanks for your reply but my problem is that using IsNull function, when I check the text fields, it returns null values even if the text field contains valid data.

Also when I am updating text fields in the database I am getting errors.

Is there a way around.

Thanks

[dRAMmer]

Thanks for your reply but my problem is that using IsNull function, when I check the text fields, it returns null values even if the text field contains valid data.

if you are testing for null values in SQL, do it like:

IF YourFld IS NULL 
--do your stuff here
ELSE
--YourFld has a value

Also when I am updating text fields in the database I am getting errors.

What exactly is the error?

[Jeev]

Hi

I get the error invalid use of null. Actually I have got the work around which is to use a temporary variable which I can then check for null instead of check directly the recordset field.

Anyways thanks guys to everybody who responded.

Bye

[dRAMmer]

Originally posted by Jeev
Hi

I get the error invalid use of null. Actually I have got the work around which is to use a temporary variable which I can then check for null instead of check directly the recordset field.

Anyways thanks guys to everybody who responded.

Bye

No need to use a variable.

To get values from a field in your RS object which may contain NULL use:

rs.Fields("Fld_x").Value & ""

if not, you will get the error invalid use of null

To check if the field is null

IsNull(rs.Fields("Fld_x").Value)

Also it's always best if you will post the code you're having problem with