SqlUtilTableIsAttached - cDbUpdateFunctionLibrary

Checks if a table is connected to SQL.

Parameters: String sTableName String sFieldName

Parameter	Description
sDriverID	The database driver ID
hTable	Table handle (Filelist.cfg number)

Syntax

Function SQLUtilTableIsAttached String sDriverID Handle hTable Returns Boolean

Call:

Get SQLUtilTableIsAttached MSSQLDRV_ID Customer.File_Number to bOK

Description

Checks if the passed table number; 1) Has a Filelist.cfg entry that points to SQL. 2) It has an .int file. If both are True the table should already be connected to SQL and the function returns True.

Example

Procedure OnClick

Boolean bOK

Get SQLUtilTableIsAttached of ghoDbUpdateFunctionLibrary Sales.File_Number to bOK

Send Info_Box ("The Sales table" * If(bOK,"does", "doesn't") * "exist as an SQL table.")

End_Procedure