SQLAppend

Structure

SQLAppend: String:

Type

Function

Description

This function returns the SQL append character(s) for the current database type. This sql syntax varies between MSSQL, FIREBIRD, and ORACLE - so it is helpful to use this function rather than hardcoding for one database type. This way, if the configuration is synced to a different database type the sql will still function properly. As an example, for MSSQL this function returns '+'. For ORACLE and FIREBIRD it returns '||'.

Parameters: 0

Return Value

String

Example

if tdDoSQLRecords(1, "SELECT (COMPANY " & SQLAppend & " '--' " & SQLAppend & " GAGE_SN) AS KEYFIELD FROM GAGES WHERE COMPANY = 'ABC COMPANY' ORDER BY COMPANY, GAGE_SN") then

ShowMessage("Full Key = " & tdFieldByNameAsString(1, "KEYFIELD"))

End If |