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 SkipVought 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
Jun 27, 2007
30
0
0
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top