CLASS:

ADOStoredProc

DESCRIPTION:

Represents an object that describes a stored procedure and contains the resulting rowset.

SYNTAX:

[<oRef> =] new ADOStoredProc()

PROPERTY:

DEFAULT:

DESCRIPTION:

baseClassName

ADOSTOREDPROC

Identifies the object as an instance of the ADOStoredProc class 

className

ADOSTOREDPROC

Identifies the object as an instance of a custom class. When no custom class exists, defaults to baseClassName

name

Empty string 

The name of custom object

parent

null

Container form or report 

active

false

Whether the object is open and active or closed.

cacheSize

1

Number of result rows that are cached locally in memory.

commandTimeout

30

In seconds, how long to wait while executing a command before terminating the command and issuing and error.

connected

false

Whether the data object is connected with the data source.

connectionString

Empty string 

Connection statement that describes parameters used to establish a connection with data source.

cursorLocation

0 - Client

Location of the cursor service.

cursorType

4 - Static

Cursor type that can be used.

database

null

A reference to the ADODatabase object to which the object is assigned.

databaseName

Empty string 

Database alias name to which the object is assigned.

executeOptions

0 - Unspecified

Available options that can be used to execute command.

fetchOptions

0 - Unspecified

Available options that can be used to fetched records.

handle

0

ADO statement handle.

lockType

3 - Optimistic

Lock type that will be placed on rows during editing.

maxRows

0

Maximum number of result rows.

params

Object

A reference to an array that contains the ADOParameter objects.

prepared

false

Whether to save a compiled version of a command before execution.

procedureName

Empty string 

Name of the stored procedure.

properties

AssocArray

A reference to Associative array that contains the dynamic properties.

rowset

Object

A reference to the ADORowset object that contains the result rows.

state

0 - Closed

Enum that indicates the state object.

EVENT:

PARAMETERS:

DESCRIPTION:

canClose

Event fired when there’s an attempt to deactivate object; return value determines if the object is deactivated.

canOpen

Event fired when attempting to open object; return value determines if object is opened.

onClose

Event fired after object is successfully closed.

onOpen

Event fired after object is successfully opened.

onProgress

<percent expN>,<type expN>,<status expN>,<msg expC>

Event fired periodically during long-running data processing operations.

METHOD:

PARAMETERS:

DESCRIPTION:

cancel

Cancels execution of a pending, asynchronous method call.

close

Closes object.

open

Opens object.

NOTE: if you get 'Invalid argument for value' OR 'Invalid subscript reference'.

After setting connectionString or databaseName property add:

connected = true

This opens the connection to the database server.

Once the connection is open, setting the procedureName will be able to retrieve the parameter definitions from the server.

for example :    (NOTE: this refers to this form the adoStoredProc is in)

  this.ADOSP = new ADOSTOREDPROC(this)

   with (this.ADOSP)

      left = 1764.0

      top = 132.0

      database = <your database name>

      connected = true

      procedureName = "sp_someprocedureName"

      with (parameters["@ID"])

         type = "SmallInt"

         value = 1234

         length = 4

      endwith

      active = true

   endwith