SQL::Connection::GenerateRowQualifiers()

Syntax

List as C = <SQL::Connection>.GenerateRowQualifiers( <TableInfo> as SQL::TableInfo )

Argument	Description
List	A CR-LF delimited list of key columns in the format: <DBFColumnName><tab><ArgumentName><crlf>
<SQL::Connection>	A SQL::Connection object.
<TableInfo>	A SQL::TableInfo object for the table created with the DIM statement.

Description

The GenerateRowQualifiers() method generates a list of key columns for a table based on the primary key. This list is used by linked tables to map the column data to the refresh row query generated by the GenerateRefreshRowQuery() method. If the table has no primary key columns, an empty string is returned.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Examples

dim conn as SQL::Connection

dim connString as C

dim ti as SQL::TableInfo

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

if .not. conn.GetTableInfo(ti, "customer")

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

end if

ui_msg_box("Key Column(s)", conn.GenerateRowQualifiers(ti))

conn.close()