Commands and Topics for 4D For MySQL
Preface
MySQL_Connect
(server; database; user; password)
Longint
MySQL_LastConnectFailure
String
MySQL_Close
(connID)
MySQL_AddIntegerParameter
(connID; key; paramValue)
MySQL_AddLongintParameter
(connID; key; paramValue)
MySQL_AddRealParameter
(connID; key; paramValue)
MySQL_AddStringParameter
(connID; key; paramValue)
MySQL_AddTextParameter
(connID; key; paramValue)
MySQL_AddDateParameter
(connID; key; paramValue)
MySQL_AddPictureParameter
(connID; key; paramValue)
MySQL_AddBlobParameter
(connID; key; paramValue)
MySQL_Select
(connID; query)
Longint
MySQL_Execute
(connID; statement)
MySQL_ErrorCode
(connID)
Longint
MySQL_ErrorString
(connID)
String
MySQL_FieldCount
(selectID)
Integer
MySQL_GetFieldName
(selectID; fieldIndex; fieldName)
MySQL_NextRow
(selectID)
Integer
MySQL_GetStringField
(selectID; fieldIndex; fieldValue)
MySQL_GetDateField
(selectID; fieldIndex; day; month; year)
MySQL_GetIntegerField
(selectID; fieldIndex; fieldValue)
MySQL_GetLongIntField
(selectID; fieldIndex; fieldValue)
MySQL_GetTextField
(selectID; fieldIndex; fieldValue)
MySQL_GetRealField
(selectID; fieldIndex; fieldValue)
MySQL_GetTimeField
(selectID; fieldIndex; hour; minutes; seconds)
MySQL_GetPictureField
(selectID; fieldIndex; fieldValue)
MySQL_GetBlobField
(selectID; fieldIndex; fieldValue)
MySQL_CloseSelect
(selectID)