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_GetAsSQLDate

Name	CNSQuery_GetAsSQLDate
Description	This function will convert a FileMaker Pro Date value into an SQL Date Format suitable for using in an SQL query.
Return Type	Text
Format	CNSQuery_GetAsSQLDate ( FMPDate )
Required Parameters	FMPDate The FileMaker Pro Date to convert to an SQL formatted Date.
Example	Example 1 Returns something like: 2010-03-29 `CNSQuery_GetAsSQLDate( MyDate )`

CNS Query