Soap.SOAPDm.TSoapDataModule.SAS_GetRecords
Delphi
function SAS_GetRecords(const ProviderName: OleStr; Count: Integer; out RecsOut: Integer; Options: Integer; const CommandText: OleStr; var Params: OleVariant; var OwnerData: OleVariant): OleVariant; virtual; stdcall;
C++
virtual System::OleVariant __stdcall SAS_GetRecords(const System::WideString ProviderName, int Count, /* out */ int &RecsOut, int Options, const System::WideString CommandText, System::OleVariant &Params, System::OleVariant &OwnerData);
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| function | protected | Soap.SOAPDm.pas Soap.SOAPDm.hpp |
Soap.SOAPDm | TSoapDataModule |
Description
Returns a data packet that contains the specified data.
Call SAS_SAS_GetRecords to retrieve a specified number of records. SAS_SAS_GetRecords returns the requested records, starting with the current record of the provider's dataset. Because SOAP data modules are stateless, you may need to reposition the cursor or re-execute a query or stored procedure in the provider's BeforeSAS_GetRecords event handler.
ProviderName gives the name of the provider component that supplies the records.
Count indicates the number or type of records to retrieve. If Count is -1, all records are retrieved. If Count is 0, only metadata is retrieved. If Count is greater than 0, only Count records are retrieved.
RecsOut returns the actual number of records retrieved.
Options indicates what information should be added to the data packet in addition to data. It is a combination of the GetRecordOption constants. For example, the following value requests metadata along with a data packet encoded in XML:
MetaDataOption + XMLOption
MetaDataOption || XMLOption
CommandText specifies an optional SQL statement that replaces the SQL of the provider's query, or the name of a table or stored procedure that replaces the provider's underlying database table or stored procedure. This parameter is ignored if the provider's Options property does not include poAllowCommandText.
Params is a Variant containing any parameters that should be passed to the provider's dataset before it executes to generate the requested data. It returns any output parameters.
OwnerData contains custom information that is supplied by a client dataset's BeforeSAS_GetRecords event handler. This information is passed to the provider's BeforeSAS_GetRecords event handler. OwnerData returns information supplied by the provider's AfterSAS_GetRecords event handler.
Records are returned as a data packet in a Variant.
Note: Applications can only call the protected SAS_SAS_GetRecords method using the IAppServerSOAP interface. To fetch records directly in code from the application server, use the provider component's SAS_GetRecords method.