tdFieldByNameAsDateTime

Structure

tdFieldByNameAsDateTime(iDataSet, sFieldName)

Type

Function

Description

This function retrieves the field value designated by sFieldName as a date/time for the selected dataset - only applicable to date/time-based fields. Note: the value that is returned is actually a float value - just as would be returned from a Delphi dataset with FieldbyName('MyField').AsDateTime.

Parameters: 2

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

sFieldName=name of the field to be retrieved.

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 MAX(SERVICE_DATE) AS MAX_SERVICE_DATE FROM GAGES WHERE COMPANY = '' & sCompanyName & ''') then

fMaxDate = tdFieldbyNameAsDateTime(2, 'MAX_SERVICE_DATE')

End If

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

'Most Recent Gage Put Into Service On: ' & DateToStr(fMaxDate))

tdNext(1)

End While

End If |