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? 3 4975
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?
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?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
| | |