Functions

Function	CNSQuery_AddField
Function	CNSQuery_AddRecord
Function	CNSQuery_AddTable
Function	CNSQuery_Configure
Function	CNSQuery_EscapeQuotes
Function	CNSQuery_ExecuteSQL
Function	CNSQuery_ExecuteSQLEx
Function	CNSQuery_FieldExists
Function	CNSQuery_FindRecords
Function	CNSQuery_GetAsSQLDate
Function	CNSQuery_GetAsSQLTime
Function	CNSQuery_GetAsSQLTimestamp
Function	CNSQuery_GetBaseTableNames
Function	CNSQuery_GetFMErrorText
Function	CNSQuery_GetFieldIDs
Function	CNSQuery_GetFieldNames
Function	CNSQuery_GetFieldTypes
Function	CNSQuery_GetFieldValueByFind
Function	CNSQuery_GetFieldValueByID
Function	CNSQuery_GetLayoutFieldNames
Function	CNSQuery_GetLayoutIDs
Function	CNSQuery_GetLayoutNames
Function	CNSQuery_GetRecordData
Function	CNSQuery_GetRecordDataColumnCount
Function	CNSQuery_GetRecordDataRowCount
Function	CNSQuery_GetTOIDs
Function	CNSQuery_GetTONames
Function	CNSQuery_LayoutExists
Function	CNSQuery_Register
Function	CNSQuery_RemoveField
Function	CNSQuery_RemoveRecordByFind
Function	CNSQuery_RemoveRecordByID
Function	CNSQuery_RemoveTable
Function	CNSQuery_SetFieldValueByFind
Function	CNSQuery_SetFieldValueByID
Function	CNSQuery_TOExists
Function	CNSQuery_UpdateRecordByFind
Function	CNSQuery_UpdateRecordByID
Function	CNSQuery_Version
Function	CNSQuery_VersionNumber

CNSQuery_GetAsSQLTime

Name	CNSQuery_GetAsSQLTime
Description	This function will convert a FileMaker Pro Time value into an SQL Time Format suitable for using in an SQL query.
Return Type	Text
Format	CNSQuery_GetAsSQLTime ( FMPTime )
Required Parameters	FMPTime The FileMaker Pro Time to convert to an SQL formatted Time.
Example	Example 1 Returns something like: 14:47:43 `CNSQuery_GetAsSQLTime( MyTime )`

CNS Query