473,324 Members | 2,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

SQL update statment, using ACCESS yes/no

VB.net 2003, 1.1, webapplication
hey there connecting to an Access database.
There is a field in the database that is yes/no
What do I pass in to the datbase to make it check the box, or uncheck
it? I have tried "yes", "no", "true", "false", but i cant get it right

e.g
SQL = UPDATE Users SET Name = TRUE WHERE ID = 1

anyone got a clue?

Jul 4 '06 #1
3 4975
whhoops, never mind now

Jul 4 '06 #2
Hello, Bonzol,

I also would have expected that SQL to work. Perhaps the problem is
somewhere else. Can you try running the query from directly within
Access? That might provide a clue as to whether the problem is with the
query or the web-app.

Cheers,
Randy
Bonzol wrote:
VB.net 2003, 1.1, webapplication
hey there connecting to an Access database.
There is a field in the database that is yes/no
What do I pass in to the datbase to make it check the box, or uncheck
it? I have tried "yes", "no", "true", "false", but i cant get it right

e.g
SQL = UPDATE Users SET Name = TRUE WHERE ID = 1

anyone got a clue?
Jul 4 '06 #3
Try using 1 for true and 0 for false - that should work
R. MacDonald wrote:
Hello, Bonzol,

I also would have expected that SQL to work. Perhaps the problem is
somewhere else. Can you try running the query from directly within
Access? That might provide a clue as to whether the problem is with the
query or the web-app.

Cheers,
Randy
Bonzol wrote:
VB.net 2003, 1.1, webapplication
hey there connecting to an Access database.
There is a field in the database that is yes/no
What do I pass in to the datbase to make it check the box, or uncheck
it? I have tried "yes", "no", "true", "false", but i cant get it right

e.g
SQL = UPDATE Users SET Name = TRUE WHERE ID = 1

anyone got a clue?
Jul 4 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: elie chucrallah | last post by:
Dear Sirs, I have the following select query and i need to update the field EmailLastReceivedDate (showing null in the select) to the values in the field MaxOfSentOn using access 2000 query ...
2
by: sean | last post by:
Hi, I am trying to update an access database using an SQL statement, I keep getting an syntax error in update statment. I am passing in strChkBoxValue as a string value which is declared in...
6
by: Agnes | last post by:
For i = 1 to 5000 Me.txtCounter.text = i 'As I found the textbox didn't update itself, I add (Me.txtCounter.update) '.... some calculation statment end for Me.txtcounter.update sometimes work...
0
by: Solution Seeker | last post by:
Hi, We are using vb.net for creating a Windows Application. We are using layered approach, with a UI layer, Logic, Db Access layer etc. we are encountering a peculiar problem when we try to...
5
by: parwal.sandeep | last post by:
Hello grp! i'm using INNODB tables which are using frequently . if i fire a SELECT query which fetch major part of table it usually take 10-20 seconds to complete. in mean time if any UPDATE...
2
by: Brett | last post by:
My database has 2 tables: Table1 & Table2. If a field is not null on a record in table2, then the not null fields in table1 that correspond to the records in table1 needs to be updated to match the...
2
by: ramdil | last post by:
Hi All Please help me .Hope i have described my problem clearly below. I have a condition where i need to update some data in table from the value taken from another table.So basically i need to...
3
by: Michel Esber | last post by:
Hi all, DB2 V8 LUW FP 15 There is a table T (ID varchar (24), ABC timestamp). ID is PK. Our application needs to frequently update T with a new value for ABC. update T set ABC=? where ID...
1
praclarush
by: praclarush | last post by:
I'm trying to connect to a access database and post an update to a row in a table though code with Visual Basic 2005, but when I do, I'm getting a Syntax error with the update statment. I don't...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.