I think you can change to this:
If (Trim(lblLabel(38).Caption) =3D "" Then
	strSQL =3D "Update ra set raCode =3D NULL"
else
...
end if
cn.execute strSQL

Because the sql statement will be evaluated by the rdbms.

Gavin

-----Original Message-----
From: -=DE=E4z=EB=F1k=F6=AC [mailto:news@l...]
Sent: Thursday, November 14, 2002 9:23 PM
To: professional vb
Subject: [pro_vb] Inserting a Null Value


does anyone know why this can't insert a null value to a particular 
field
i'm using vb6 and mySQL

strSQL =3D "Update ra " & _
"set raCode =3D '" & IIf(Trim(lblLabel(38).Caption) =3D "", Null,
lblLabel(38).Caption) & "' "
cn.execute strSQL

everytime i execute this statement the raCode fields always contain a 0

raCode
type: bigInt
Length/set: 20
Default:


lewell



The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was 
but
the weight remains the same. The contents is being sent by weight and 
not by
volume.