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 4990
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
OFCOURSE ONE STATMENT NOW I HAVE A LOOP THRU THE RECORDSET AND A UPDATE
ACCORDINGLY
SELECT Max(EmailsDatabase.SentOn) AS MaxOfSentOn,...
|
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 another function. Could someone help
me fix my code.
Sean
|
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 , sometimes doesn't ,
I saw the textbox show "289" and then stop , but the statment runs very
well.
|
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 perform an Create to
one table followed by update to another table .
for e.g. user hits save in a window/screen.
|
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 qry comes for a perticular row which is part
of SELECT qry i want to know that whether UPDATE will wait for
completing SELECT qry or not,
or it...
| |
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 field in table2.
What I have is a form that is linked to Table2. If the users want to
change a field in the main database (table1), they fill 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 create a update statment to perform the data manipulation.but i am not able to write the update statments.I have two tables..Tab_Bookings and ...
|
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 understand what I'm doing wrong since the update statment looks like one that would be generated by Visual Studio when working with datasets
Private Sub...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| | |