To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Delphi Delphi Prism Java JavaScript ObjectPAL Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics +OOP Details

	ASP Classic Guides
ASP Classic To/From Conversion Guides ASP Classic and C# ASP Classic and C++ ASP Classic and C++/CLI ASP Classic and Delphi ASP Classic and Delphi Prism ASP Classic and Java ASP Classic and JavaScript ASP Classic and ObjectPAL ASP Classic and Perl ASP Classic and PHP ASP Classic and VB Classic ASP Classic and VB.Net

Cross Ref Guide

ASP CLASSICLANGUAGE

ASP Classic

ASP CLASSICANDACCESS VBATOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

+Statements

+Operators

+Commands

+Database

Edit Record◄╣

+OOP Basics

+OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► ASP Classic

Edit Record (ASP Classic and Access VBA Cross Reference Guide)

By Mike Prestwood

ASP Classic versus Access VBA: A side by side comparison between ASP Classic and Access VBA.

Database

This category documents connecting and using data including database commands, and common technologies used.

Edit Record

[Other Languages]

Languages Focus

This common syntax name documents editing a record as a whole: add/insert, edit, post data, and delete.

ASP Classic: AddNew, Update, Delete

In ASP, using ADO, you use RecordSet.AddNew to add a new record, Recordset.Update to post the record, and RecordSet.Delete to delete it. To edit a record, you open the RecordSet using an editable cursor.

Syntax Example:

The following code snippet adds a record to a given editable RecordSet with FullName and Created fields:

objRS.AddNew

objRS.Fields("FullName") = "Barack Obama"

objRS.Fields("Created")  = Now

objRS.Update

[Not specified yet. Coming...]