T
Tim
I don't know what to use to clear a field in an MSAccess database. I
can update fields in the database and delete whole records but I have
not figured out how to clear a single field.
This is what I am using to update the database.
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=DataBase"
SQL = "UPDATE Table SET "
SQL = SQL & "thefield='" & Request.Form("thefield1") & "', "
SQL = SQL & "theDate='" & FormatDateTime(Now,2) & "' "
SQL = SQL & "WHERE theName = '" & Request.Form("theName") & "' "
Set RSUpdate=Conn.Execute(SQL)
Conn.Close
Set RSUpdate=nothing
I get an error if I try to update a field with a value of nothing "".
can update fields in the database and delete whole records but I have
not figured out how to clear a single field.
This is what I am using to update the database.
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=DataBase"
SQL = "UPDATE Table SET "
SQL = SQL & "thefield='" & Request.Form("thefield1") & "', "
SQL = SQL & "theDate='" & FormatDateTime(Now,2) & "' "
SQL = SQL & "WHERE theName = '" & Request.Form("theName") & "' "
Set RSUpdate=Conn.Execute(SQL)
Conn.Close
Set RSUpdate=nothing
I get an error if I try to update a field with a value of nothing "".