AsmAdo v1.0 (DLL version) Functions: 


Ado_BeginTrans

Ado_BeginTrans

description

Starts a transaction.

parameters

None.

return value

S_OK if successful, S_FALSE if it failed.


Ado_CloseConnection

Ado_CloseConnection

description

Closes the connection.

parameters

None.

return values

S_OK if successful, S_FALSE if it failed.


Ado_CommitTrans

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

http://win32asm.guyane.nu