Low cost ecommerce web development India flash website design
Deleting Records
Use the SQL DELETE statement to delete one or more records satisfying a
particular criterion.
<HTML>
<HEAD>
<TITLE>Student Records</TITLE>
</HEAD>
<BODY>
<%
Dim DB
Set DB = Server.CreateObject (“ADODB.Connection”)
DB.Mode = adModeReadWrite
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" +
“C:\Databases\Students.mdb”)
DB.Execute (“DELETE * FROM Students WHERE FirstName =
‘Manas’”)
%>
</BODY>
</HTML>
Exercise the utmost caution while using the DELETE statement for two
reasons:
Freelance web designer ASP PHP ecommerce web development India