tdDoSQLRecords

Structure

tdDoSQLRecords(iDataSet, sSQL)

Type

Function

Description

This function will execute sql on one of three temporary datasets that exists in IndySoft solely for the purpose of running custom script sql. These datasets can then be looped and read, as needed, from other 'td*' custom rule functions.

Parameters: 2

iDataSet=# of dataset, must be 1-10. IndySoft provides 10 datasets that can be accessed through 'td*' custom script functions.

sSQL= the sql to be run against the temporary dataset.

Example

if tdDoSQLRecords(1, 'SELECT COMPANY_NAME FROM COMPANY ORDER BY COMPANY_NAME') then

tdFirst(1)

while (tdEOF(1) = '0')

sCompanyName = tdFieldbyNameAsString(1, 'COMPANY_NAME')

iCount = 0

if tdDoSQLRecords(2, 'SELECT COUNT(*) AS COUNTER FROM GAGES WHERE COMPANY = '' & sCompanyName & ''') then

iCount = tdFieldbyNameAsInteger(2, 'COUNTER')

End If

ShowMessage('Company: ' & sCompanyName & Chr(13) &

'Gage Count: ' & IntToStr(iCount))

tdNext(1)

End While

End If |