Ado_BeginTrans
description
Starts a transaction.
parameters
None.
return value
S_OK if successful, S_FALSE if it failed.
Ado_CloseConnection
description
Closes the connection.
parameters
None.return values
S_OK if successful, S_FALSE if it failed.
Ado_CommitTrans
description
Commits a transaction i.e. all changes since the beginning of the transaction are saved.
parameters
None.return value
S_OK if successful, S_FALSE if it failed.
Ado_Execute pwcszSQL:DWORD, ppRecordset:DWORD
description
Executes a SQL statement.
parameters
|
pwcszSQL |
Pointer to a unicode string which is the sql statement that you want to be executed. |
| ppRecordset |
Pointer to a pointer to a _Recordset interface which will be filled by the execute proc. This interface MUST be released by calling Close on ppRecordset when you don't need the recordset anymore. You can pass NULL instead of a pointer if you don't need the recordset. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_ExecuteSP pwcszSPName:DWORD, pVParamArray:DWORD, ppRecordset:DWORD
description
Executes a stored procedure.
parameters
|
pwcszSPName |
Pointer to a unicode string which is the name of the stored procedure to be called. |
| pVParamArray | Pointer to an array of variants which are the parameters of the stored procedure. |
| ppRecordset |
Pointer to a pointer to a _Recordset interface which will be filled by the execute proc. This interface MUST be released by calling Close on ppRecordset when you don't need the recordset anymore. You can pass NULL instead of a pointer if you don't need the recordset. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_Export pwcszQuery:DWORD, pwcszColDelimiter:DWORD, pwcszRowDelimiter:DWORD, pbstrExported:DWORD
description
Exports the result of a sql query to a string.
parameters
| pwcszQuery | Pointer to a unicode string which is the sql statement that you want to be executed. |
| pwcszColDelimiter | Pointer to a unicode string which is the string which will be used to delimit columns. |
| pwcszRowDelimiter | Pointer to a unicode string which is the string which will be used to delimit rows. |
| pbstrExported | Pointer to bstr which will be filled by Export. You MUST free this bstr by calling SysFreeString on pbstrExported when you don't need anymore. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_ExportSP pwcszSPName:DWORD, pVParamArray:DWORD, pwcszColDelimiter:DWORD, pwcszRowDelimiter:DWORD, pbstrExported:DWORD
description
Exports the result of a stored procedure to a string.
parameters
| pwcszSPName | Pointer to a unicode string which is the name of the stored procedure to be called. |
| pwcszColDelimiter | Pointer to a unicode string which is the string which will be used to delimit columns. |
| pwcszRowDelimiter | Pointer to a unnicode string which is the string which will be used to delimit rows. |
| pbstrExported | Pointer to bstr which will be filled by Export. You MUST free this bstr by calling SysFreeString on pbstrExported when you don't need anymore. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_Initialize
description
Initialize the AsmAdoLib. This function MUST be called first.
parameters
None.
return value
S_OK if successful, S_FALSE if it failed.
Ado_OpenConnection pwcszConnectionString:DWORD, pwcszUserID:DWORD, pwcszPassword:DWORD
description
Opens a connection to a database.
parameters
| pwcszCnStr | Pointer to a unicode which is the connection string. |
| pwcszUserId | Pointer to a unicode which is the user id. |
| pwcszPassword | Pointer to a unicode which is the password. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RollbackTrans
description
Rollbacks a transaction i.e. all changes since the beginning of the transaction are discarded.
parameters
None.
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsBof pRecordset:DWORD, pdwResult:DWORD
description
Tells us if we are at the beginning of a recordset.
parameters
| pRecordset |
Pointer to a _Recordset interface. |
| pdwResult |
Pointer to a boolean which tells us if we are at the beginning of the recordset pointed by pRecordset. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsClose pRecordset:DWORD
description
Closes a recordset and releases the interface pointed by pRecordset.
parameters
| pRecordset |
Pointer to an opened _Recordset interface. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsEof pRecordset:DWORD, pdwResult:DWORD
description
Tells us if we are at the end of a recordset.
parameters
| pRecordset |
Pointer to a _Recordset interface. |
| pdwResult |
Pointer to a boolean which tells us if we are at the end of the recordset pointed by pRecordset |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsFirst pRecordset:DWORD
description
Goes to the first record of a recordset.
parameters
| pRecordset |
Pointer to an opened _Recordset interface. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsGetCount pRecordset:DWORD, pdwCount:DWORD
description
Commits a transaction i.e. all changes since the beginning of the transaction are saved.
parameters
| pRecordset |
Pointer to an opened _Recordset interface. |
| pdwCount |
Pointer to a dword which will be filled with the number of records of the recordset. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsGetField pRecordset:DWORD, dwIndex:DWORD, pVResult:DWORD
description
Returns the value of a field from it's index.
parameters
| pRecordset | Pointer to an opened _Recordset interface. |
| dwIndex | Index of the field. |
| pVResult | Pointer to a variant which will be filled with the value of the field. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsGetFieldByName pRecordset:DWORD, pwcszField:DWORD, pVResult:DWORD
description
Returns the value of a field from it's column name.
parameters
| pRecordset | Pointer to an opened _Recordset interface. |
| pbstrField | Pointer to a bstr which is the name of the field. |
| pVResult | Pointer to a variant which will be filled with the value of the field. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsLast pRecordset:DWORD
description
Goes to the last record of a recordset.
parameters
| pRecordset |
Pointer to an opened _Recordset interface. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsNext pRecordset:DWORD
description
Goes to the next record of a recordset.
parameters
| pRecordset |
Pointer to an opened _Recordset interface. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_RsPrev pRecordset:DWORD
description
Goes to the previous record of a recordset.
parameters
| pRecordset |
Pointer to an opened _Recordset interface. |
return value
S_OK if successful, S_FALSE if it failed.
Ado_UnInitialize
description
UnInitialize the AsmAdoLib. This function MUST be called last.
parameters
None.
return value
S_OK if successful, S_FALSE if it failed.
Copyright (c) 2001 Maurice MONTGENIE