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!

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

Validation check box

Status
Not open for further replies.

JJ297

Programmer
Joined
Jun 27, 2007
Messages
30
Location
US
Could someone please help me I can't get null into the database. I'm trying to achieve...

if displayedQues = "Y" then I want nondisplayedques to go into the
database as null. What do I need to do? This is what I have thus
far.


Dim displayedQues As Char = "Y"
Dim nonDisplayedQues As Char = "N"


If (RadioYes.Checked) Then
displayedQues = "Y"
End If


If (RadioNo.Checked) Then
nonDisplayedQues = "N"
End If


Thanks for your assistance.


 
Your code looks like VB code, not VFP code. Are you using VFP tables for data storage?

In VFP to assign a null value to a field the code is:

Code:
REPLACE MyField with .NULL. IN MyTable

pamela
 
Thanks, I've figured it out.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top