Skip to main content

tdBOF

Structure​

tdBOF(iDataSet)

Type​

Function

Description​

This function will return '1' or '0', based on whether the select dataset is at beginning of file (first record).

Parameters​

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

Example​

if tdDoSQLRecords(1, 'SELECT COMPANY_NAME FROM COMPANY ORDER BY COMPANY_NAME') then
  tdLast(1)
  while (tdBOF(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))
    tdPrior(1)
  End While
End If