SQLConfiguration SQLConfiguration

Modifying Data  «Prev 

Direct access to the database with Data Environment

Scripting the DE Object

SQL Delete statement

  1. This statement creates a reference to the DE object. The PageObject'sCreateDE method is used. The Data Environment is named DE when it is created. Now it can be referenced in this page via the name.
  2. This statement executes the CustTable command object. The CustTable command object returns all the rows in CustTable.
  3. set rs = DE.rsCustTable creates a recordset object to reference the command objects result set, which is all the rows in the table.
  4. This statement uses the recordset object's moveFirst to make sure we're at the first row. Now, recordset object methods can be used to navigate in and manipulate the data. The file DE.asp includes script to display the recordset in an HTML table.