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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

syntax help on UPDATE with boolean

Status
Not open for further replies.
tania20

tania20

Programmer
Joined
Oct 30, 2006
Messages
148
Location
AU
Hi, Can someone please help with my syntax on UPDATE, i know how to use for text and number fileds but not for boolean.RecordSelector is an option button (yes/no)

db.Execute ("UPDATE general_info SET [RecordSelector] = FALSE WHERE strWhere")

Cheers

Tania
 
Sort by date Sort by votes
its ok just worked it out- needed ' ' around strWhere....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question Question
Help With Search Form Results
Replies
15
Views
978
caykamanj1966
caykamanj1966
BJZeak
  • Locked
  • Question Question
Struggling with finding an answer to a simple question
Replies
5
Views
952
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question Question
Running query with parameter from Inputbox
Replies
8
Views
1K
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
2K
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
Forcing Form Updates
Replies
2
Views
820
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top