SQL::Connection::GenerateNativeColumnName()

Syntax

Native_Column_Name as C = <SQL::Connection>.GenerateNativeColumnName( Name as C )

Argument

Description

Native_Column_Name

The formatted column name.

<SQL::Connection>

A SQL::Connection object.

Name

The initial column name.

Description

The SQL::Connection::GenerateNativeColumnName() methods generates a formatted column 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 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("Native Column Name", conn.GenerateNativeColumnName("lastname"))

conn.close()

See Also

SQL::Connection Object