SQL::Connection::PrimaryKeyExpression()

Syntax

Key_Expression as C = <SQL::Connection >.PrimaryKeyExpression( TableName as C )

Argument	Description
Key_Expression	The expression that TableName uses to calculate primary index values.
<SQL::Connection>	A SQL::Connection object.
TableName	The name of a table in the back-end database.

Description

The PrimaryKeyExpression() method returns the primary key expression for a table.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Examples

dim conn as SQL::Connection

dim connString as C

connString = "{A5API='Access', FileName='c:\program files\a5v8\mdbfiles\alphasports.mdb'}"

if .not. conn.open(connString)

ui_msg_box("Error", conn.CallResult.text)

end

end if

ui_msg_box("Primary Key Expression", conn.PrimaryKeyExpression("customer"))

conn.close()