Commands and Topics for 4D For ADO
Preface
DBGateway_Connect
(host; connStr)
Longint
DBGateway_Close
(connID)
DBGateway_ErrorCode
(connID)
Longint
DBGateway_ErrorString
(connID)
String
DBGateway_Select
(connID; sqlQuery)
Longint
DBGateway_Execute
(connID; sqlQuery)
DBGateway_FieldCount
(selectID)
Integer
DBGateway_FieldName
(selectID; fieldIndex; fieldName)
DBGateway_NextRow
(selectID)
Integer
DBGateway_GetStringField
(selectID; fieldIndex; fieldValue)
DBGateway_GetTextField
(selectID; fieldIndex; fieldValue)
DBGateway_GetIntegerField
(selectID; fieldIndex; fieldValue)
DBGateway_GetRealField
(selectID; fieldIndex; fieldValue)
DBGateway_GetLongIntField
(selectID; fieldIndex; fieldValue)
DBGateway_GetPictureField
(selectID; fieldIndex; fieldValue)
DBGateway_GetBlobField
(selectID; fieldIndex; fieldValue)
DBGateway_GetDateField
(selectID; fieldIndex; day; month; year)
DBGateway_GetTimeField
(selectID; fieldIndex; hour; minutes; seconds)
DBGateway_CloseSelect
(selectID)
DBGateway_AddStringParameter
(connID; tagIndex; paramValue)
DBGateway_AddIntegerParameter
(connID; tagIndex; paramValue)
DBGateway_AddTextParameter
(connID; tagIndex; paramValue)
DBGateway_AddLongIntParameter
(connID; tagIndex; paramValue)
DBGateway_AddRealParameter
(connID; tagIndex; paramValue)
DBGateway_AddDateParameter
(connID; tagIndex; paramValue)
DBGateway_AddPictureParameter
(connID; tagIndex; paramValue)
DBGateway_AddBlobParameter
(connID; tagIndex; paramValue)