SQL Class (clsSQL)

fdmAPI.API.DataWindow.SQL.API Call

Table 58. SQL Class (clsSQL)

API CallMethods/Properties/Object ReferenceDescription
fGetAppIDMethodReturn the application ID for the Load ID passed in.

Inputs: ByVal strLoadID As String

Output: String
fGetLanguageCodeMethodReturns the language code.

Inputs: ByVal AppID As String

Output: String
fGetTopLevelDirectoryMethodReturn top level directory.

Inputs: ByVal AppID As String

Output: String
fOptionLIstForKeyMethodReturns a recordset containing one record with values for the specified option name.

Inputs: ByVal strOptionName As String, Optional ByVal blnReadOnly As Boolean = False, Optional ByVal blnSQLOnly As Boolean = False, Optional ByVal lngMarshalType As Integer = 0, Optional ByVal blnTranslateCaptions As Boolean = False

Output: ADODB.Recordset