ytoro
|
| Posted: 10/29/2002, 3:30 PM |
|
hi,
is there a way to completely clear a table of its content by a single click
CCS, Access and asp
thanks
ytoro
Thanks for the response
database engine MSAccess with jet 4.0
|
|
|
 |
Nicole
|
| Posted: 10/31/2002, 2:41 AM |
|
Hello,
You should create button or link after clicking on that the drop table data will be done. I suggest you to pass any parameter in order to confirm the operation and execute drop data code in the page After Initialize event. Here is sample code:
if CCGetParam("drop") = true then
'open new connection
Dim conn
Set conn = New clsDBconnection_name
conn.Open
'execute custom query
conn.execute("delete from table_name")
'close connection
conn.Close
Set conn = Nothing
end if
|
|
|
|
|
