FrontPageHowTo.com - FrontPage help & tutorials
Commonly used SQL code...

Use these code snippets in the database wizard to extend the wizards functionality
Note: these examples are using the Northwind database. You must create a method to first display the record you want to edit or delete and then pass a parameter (such as the ID field) to the page containing the code below. Click HERE to see examples on how to pass a parameter.

Delete Statement Example:


Insert Statement Example: This example adds a record to a database table from a form with two text input boxes. You create the form on one page, name the form fields to match the database fields and then submit the form to the page containing this code. See a more detailed example HERE.

 

Update Statement Example: You'll want to start this from a page showing a record in text boxes, edit the record and submit to the page containing this code:

This site was built and is maintained by DJ Web Works.
© 2000. All rights reserved.
Microsoft and FrontPage2000 are registered trade marks of Microsoft Corporation.