Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

inserting NULL value 1

Status
Not open for further replies.
wbodger

wbodger

Programmer
Apr 23, 2007
769
0
0
US
I have this code

Code: 
if IsNull(tempFrmInstr) or IsEmpty(tempFrmInstr) or (tempFrmInstr = "") then
tempFrmInstr = ""

but rather than

Code: 
tempFrmInstr = ""

can I just do

Code: 
tempFrmInstr = NULL

to place a null value into that field? It is a nullable field, so I think it should work.

wb
 
Sort by date Sort by votes
Yes.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How to get the intended selected value in a drop-down list ?
Replies
11
Views
138
leifoet
leifoet
leifoet
  • Locked
  • Question
How do I turn the result of a multiplication in a VALUE that can be entered into a database table ?
Replies
12
Views
96
leifoet
leifoet
jennypretty
  • Locked
  • Question
Select unique values from radio button
Replies
5
Views
79
ChrisHirst
ChrisHirst
richwms
  • Locked
  • Question
Session Variable is Null
Replies
2
Views
39
emozley
emozley
PSchubert
  • Locked
  • Question
How to hide HTML output when recordset field value is null? 2
Replies
3
Views
32
PSchubert
PSchubert

Part and Inventory Search

Sponsor

Back
Top