SQL::Connection::GenerateNativeTableName()

Syntax

Table_Name as C = <SQL::Connection>.GenerateNativeTableName( <TableInfo> as SQL::TableInfo )

Description

The GenerateNativeTableName method generates a formatted table name suitable for a SQL query in using the current syntax.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Example

dim conn as SQL::Connection

dim ti as SQL::TableInfo

dim connString as C

dim select_exp as C

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

select_exp = "select Lastname from customer where bill_state_region = 'ma'"

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

end if

ui_msg_box("Native Type String", conn.GenerateNativeTableName(ti))

conn.close()