How to combine Insert and Where clause together??

[blue79]

Hi, I really need help here...
I want to update an 'avaibility' as in yes/no in the database..
Its subjected to only that particular serial number...

Heres my code.

Dim cmdTemp As OleDb.OleDbCommand
cmdTemp = New OleDb.OleDbCommand
cmdTemp.CommandType = CommandType.Text
cmdTemp.Connection = cnnRental

cmdTemp.CommandText = "INSERT INTO Stock (existance) VALUES ('0')"[COLOR=red] <--- how do i add the clause "Where serial = txtSerial.text or '?' to make it to a complete statement?"

cmdTemp.Connection.Open() cmdTemp.ExecuteNonQuery() cmdTemp.Connection.Close

[dburucu]

Hello,

if I understand you correctly:

use UPDATE instad of INSERT.

UPDATE Stock (existance) VALUES ('0') Where serial = '" & txtSerial.text & "'

[blue79]

Hi,
I tried the following command...
cmdTemp.CommandText = "UPDATE Stock (existance) VALUES ('false') Where serial_number = '" + txbRentalSerial.Text + "'"

It gives me "syntax error in Update statement" @@
Can i use 'false' as the existance is yes/no in access...
I tried using '0' too... to no avail.. :_(

[dburucu]

try this...

cmdTemp.CommandText = "UPDATE Stock SET (existance) VALUES ('no') Where serial_number = " & txbRentalSerial.Text

or

cmdTemp.CommandText = "UPDATE Stock SET existance='no' Where serial_number = " & txbRentalSerial.Text

[blue79]

Thanks Chris,

cmdTemp.CommandText = "UPDATE Stock SET existance=false Where serial_number = " & LngNumber

the above command helps... just that i need to make the textbox Clng() before i can pass it in... as i declared serial number as long integer. for the yest/no should put in a true/false instead.

Thanks a million..

Regards,
Henry