You are here: Function Reference > Alphabetical Listing > D > DBPrepVars

DBPrepVars

Use this procedure/function to create the DAL variables associated with a database table record.

Syntax

DBPrepVars (Table, PrefixVariable)

Parameter

Description

Table

Enter the name of an open table.

PrefixVariable

PrefixVariable is the name of the DAL variable to associate with the record fields retrieved by the procedure. The default is Table.

The system optionally returns one (1) on success or zero (0) on failure.

If the PrefixVariable parameter has not been previously defined, it is created. The table record fields assigned this prefix may be accessed using the dot (.) operator. For example, assume RECORD is a prefix variable and the table record contains the columns COMPANY, LOB, and POLICYNUM. The values of the individual fields would be referenced as RECORD.COMPANY, RECORD.LOB, and RECORD.POLICYNUM, respectively.

The actual variable names appended with a prefix are taken from the DFD file associated with the table you specified in the Table parameter or using the column names found in the table if there is no DFD file associated with the table.

Possible causes for failure to retrieve the first record include:

Example

Here is an example:

Procedure

Result

Explanation

DBPrepVars("APPIDX","RECORD");

1 or 0

Creates the DAL variables for the APPIDX table. Each column name is appended with the prefix variable RECORD.

See also

© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.