AquilaLibrary
Table Of Contents

This document is split into the following sections:

Library Description:


			

Services

The following table lists the Services defined in "AquilaLibrary":

APIService

						
BaseAquilaService

						
Protocols(BaseAquilaService)

						
TigerService(BaseAquilaService)

						
ReportingService2

						
MobileService

						
ReportingService
Designed for use in hosting queries etc, to also make accessible via ODATA
FileService
Service for transferring files between server and client
MetaService
This is the service that allows the database to be upgraded either the meta-data or the meta-structure.
RegistrationService

						
Telemedicine(BaseAquilaService)
Collection of Telemedicine Related Datasets
iBIDSvc

						
LoginService

						
AquilaService

						
Service APIService

The following table lists the Operations defined in "APIService":

QueryPatients

							
GetPatientListAPI

							
GetPatientByID

							
GetPatientCount

							
EchoTest

							
GetDatasetJson

							
GetSchemaTablesJson

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method QueryPatients


					

Parameters:

Flag Name Type Description
In QueryObj Person

							

Return Value:

Flag Name Type
Result Result TROArray_API_Types_Patient_

Oxygene Syntax:

method APIService.QueryPatients(const QueryObj: Person) : TROArray_API_Types_Patient_;

C# Syntax:

public TROArray_API_Types_Patient_ APIService.QueryPatients(Person QueryObj);

Method GetPatientListAPI


					

Parameters:

Flag Name Type Description
In givenname WideString

							
In familyname WideString

							
In nhsnumber WideString

							
In hospitalnumber WideString

							
In gender WideString

							

Return Value:

Flag Name Type
Result Result TROArray_API_Types_Patient_

Oxygene Syntax:

method APIService.GetPatientListAPI(const givenname: WideString ; const familyname: WideString ; const nhsnumber: WideString ; const hospitalnumber: WideString ; const gender: WideString) : TROArray_API_Types_Patient_;

C# Syntax:

public TROArray_API_Types_Patient_ APIService.GetPatientListAPI(WideString givenname , WideString familyname , WideString nhsnumber , WideString hospitalnumber , WideString gender);

Method GetPatientByID


					

Parameters:

Flag Name Type Description
In id WideString

							

Return Value:

Flag Name Type
Result Result Patient

Oxygene Syntax:

method APIService.GetPatientByID(const id: WideString) : Patient;

C# Syntax:

public Patient APIService.GetPatientByID(WideString id);

Method GetPatientCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method APIService.GetPatientCount() : Integer;

C# Syntax:

public Integer APIService.GetPatientCount();

Method EchoTest


					

Parameters:

Flag Name Type Description
In body Person

							

Return Value:

Flag Name Type
Result Result Patient

Oxygene Syntax:

method APIService.EchoTest(const body: Person) : Patient;

C# Syntax:

public Patient APIService.EchoTest(Person body);

Method GetDatasetJson


					

Parameters:

Flag Name Type Description
In SchemaTableName WideString

							
In WhereXML WideString

							
In IncSchema Boolean

							
In IncProps Boolean

							
In IncData Boolean

							
In IncBlobs Boolean

							
In IncNullFields Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method APIService.GetDatasetJson(const SchemaTableName: WideString ; const WhereXML: WideString ; const IncSchema: Boolean ; const IncProps: Boolean ; const IncData: Boolean ; const IncBlobs: Boolean ; const IncNullFields: Boolean) : WideString;

C# Syntax:

public WideString APIService.GetDatasetJson(WideString SchemaTableName , WideString WhereXML , Boolean IncSchema , Boolean IncProps , Boolean IncData , Boolean IncBlobs , Boolean IncNullFields);

Method GetSchemaTablesJson


					

Parameters:

Flag Name Type Description
In IncProps Boolean

							
In IncSchema Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method APIService.GetSchemaTablesJson(const IncProps: Boolean ; const IncSchema: Boolean) : WideString;

C# Syntax:

public WideString APIService.GetSchemaTablesJson(Boolean IncProps , Boolean IncSchema);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method APIService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String APIService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method APIService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary APIService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method APIService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary APIService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method APIService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer APIService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method APIService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer APIService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method APIService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String APIService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method APIService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String APIService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method APIService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary APIService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method APIService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary APIService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method APIService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer APIService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method APIService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer APIService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method APIService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String APIService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method APIService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void APIService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method APIService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void APIService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method APIService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray APIService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method APIService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray APIService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service BaseAquilaService

The following table lists the Operations defined in "BaseAquilaService":

GetDatasetJson

							
GetSchemaTablesJson

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method GetDatasetJson


					

Parameters:

Flag Name Type Description
In SchemaTableName WideString

							
In WhereXML WideString

							
In IncSchema Boolean

							
In IncProps Boolean

							
In IncData Boolean

							
In IncBlobs Boolean

							
In IncNullFields Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method BaseAquilaService.GetDatasetJson(const SchemaTableName: WideString ; const WhereXML: WideString ; const IncSchema: Boolean ; const IncProps: Boolean ; const IncData: Boolean ; const IncBlobs: Boolean ; const IncNullFields: Boolean) : WideString;

C# Syntax:

public WideString BaseAquilaService.GetDatasetJson(WideString SchemaTableName , WideString WhereXML , Boolean IncSchema , Boolean IncProps , Boolean IncData , Boolean IncBlobs , Boolean IncNullFields);

Method GetSchemaTablesJson


					

Parameters:

Flag Name Type Description
In IncProps Boolean

							
In IncSchema Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method BaseAquilaService.GetSchemaTablesJson(const IncProps: Boolean ; const IncSchema: Boolean) : WideString;

C# Syntax:

public WideString BaseAquilaService.GetSchemaTablesJson(Boolean IncProps , Boolean IncSchema);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method BaseAquilaService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String BaseAquilaService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method BaseAquilaService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary BaseAquilaService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method BaseAquilaService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary BaseAquilaService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method BaseAquilaService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer BaseAquilaService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method BaseAquilaService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer BaseAquilaService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method BaseAquilaService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String BaseAquilaService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method BaseAquilaService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String BaseAquilaService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method BaseAquilaService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary BaseAquilaService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method BaseAquilaService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary BaseAquilaService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method BaseAquilaService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer BaseAquilaService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method BaseAquilaService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer BaseAquilaService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method BaseAquilaService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String BaseAquilaService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method BaseAquilaService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void BaseAquilaService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method BaseAquilaService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void BaseAquilaService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method BaseAquilaService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray BaseAquilaService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method BaseAquilaService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray BaseAquilaService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service Protocols

The following table lists the Operations defined in "Protocols":

Service TigerService

The following table lists the Operations defined in "TigerService":

Service ReportingService2

The following table lists the Operations defined in "ReportingService2":

GetDatasetJson

							
GetSchemaTablesJson

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method GetDatasetJson


					

Parameters:

Flag Name Type Description
In SchemaTableName WideString

							
In WhereXML WideString

							
In incSchema Boolean

							
In incProps Boolean

							
In incData Boolean

							
In incBlobs Boolean

							
In incNullFields Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method ReportingService2.GetDatasetJson(const SchemaTableName: WideString ; const WhereXML: WideString ; const incSchema: Boolean ; const incProps: Boolean ; const incData: Boolean ; const incBlobs: Boolean ; const incNullFields: Boolean) : WideString;

C# Syntax:

public WideString ReportingService2.GetDatasetJson(WideString SchemaTableName , WideString WhereXML , Boolean incSchema , Boolean incProps , Boolean incData , Boolean incBlobs , Boolean incNullFields);

Method GetSchemaTablesJson


					

Parameters:

Flag Name Type Description
In IncProps Boolean

							
In IncSchema Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method ReportingService2.GetSchemaTablesJson(const IncProps: Boolean ; const IncSchema: Boolean) : WideString;

C# Syntax:

public WideString ReportingService2.GetSchemaTablesJson(Boolean IncProps , Boolean IncSchema);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService2.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String ReportingService2.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService2.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary ReportingService2.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService2.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary ReportingService2.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService2.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer ReportingService2.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService2.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer ReportingService2.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService2.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String ReportingService2.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService2.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String ReportingService2.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService2.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary ReportingService2.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService2.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary ReportingService2.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService2.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer ReportingService2.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService2.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer ReportingService2.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService2.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String ReportingService2.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method ReportingService2.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void ReportingService2.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method ReportingService2.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void ReportingService2.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method ReportingService2.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray ReportingService2.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method ReportingService2.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray ReportingService2.SimpleUpdateData(SimpleDeltaArray aDelta);
Service MobileService

The following table lists the Operations defined in "MobileService":

GetJson

							
GetDatasetJson

							
GetSchemaTablesJson

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method GetJson


					

Parameters:

Flag Name Type Description
In aSchemaTableName WideString

							
In aSelectFields StringArray

							
In aWhereXML WideString

							
In aSortColumnName WideString

							
In aInclSchema Boolean

							
In aMaxRows Integer

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method MobileService.GetJson(const aSchemaTableName: WideString ; const aSelectFields: StringArray ; const aWhereXML: WideString ; const aSortColumnName: WideString ; const aInclSchema: Boolean ; const aMaxRows: Integer) : WideString;

C# Syntax:

public WideString MobileService.GetJson(WideString aSchemaTableName , StringArray aSelectFields , WideString aWhereXML , WideString aSortColumnName , Boolean aInclSchema , Int32 aMaxRows);

Method GetDatasetJson


					

Parameters:

Flag Name Type Description
In SchemaTableName WideString

							
In WhereXML WideString

							
In IncSchema Boolean

							
In IncProps Boolean

							
In IncData Boolean

							
In IncBlobs Boolean

							
In IncNullFields Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method MobileService.GetDatasetJson(const SchemaTableName: WideString ; const WhereXML: WideString ; const IncSchema: Boolean ; const IncProps: Boolean ; const IncData: Boolean ; const IncBlobs: Boolean ; const IncNullFields: Boolean) : WideString;

C# Syntax:

public WideString MobileService.GetDatasetJson(WideString SchemaTableName , WideString WhereXML , Boolean IncSchema , Boolean IncProps , Boolean IncData , Boolean IncBlobs , Boolean IncNullFields);

Method GetSchemaTablesJson


					

Parameters:

Flag Name Type Description
In IncProps Boolean

							
In IncSchema Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method MobileService.GetSchemaTablesJson(const IncProps: Boolean ; const IncSchema: Boolean) : WideString;

C# Syntax:

public WideString MobileService.GetSchemaTablesJson(Boolean IncProps , Boolean IncSchema);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MobileService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String MobileService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MobileService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary MobileService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MobileService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary MobileService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MobileService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer MobileService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MobileService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer MobileService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MobileService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String MobileService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MobileService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String MobileService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MobileService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary MobileService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MobileService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary MobileService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MobileService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer MobileService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MobileService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer MobileService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MobileService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String MobileService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method MobileService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void MobileService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method MobileService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void MobileService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method MobileService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray MobileService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method MobileService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray MobileService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service ReportingService

The following table lists the Operations defined in "ReportingService":

DependencyCountForPatient

							
GetQueryTableList

							
GetDatasetJson

							
GetSchemaTablesJson

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method DependencyCountForPatient


					

Parameters:

Flag Name Type Description
In Patient_ID WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService.DependencyCountForPatient(const Patient_ID: WideString) : Integer;

C# Syntax:

public Integer ReportingService.DependencyCountForPatient(WideString Patient_ID);

Method GetQueryTableList


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result StringArray

Oxygene Syntax:

method ReportingService.GetQueryTableList() : StringArray;

C# Syntax:

public StringArray ReportingService.GetQueryTableList();

Method GetDatasetJson


					

Parameters:

Flag Name Type Description
In SchemaTableName WideString

							
In WhereXML WideString

							
In incSChema Boolean

							
In incProps Boolean

							
In incData Boolean

							
In incBlobs Boolean

							
In incNullFields Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method ReportingService.GetDatasetJson(const SchemaTableName: WideString ; const WhereXML: WideString ; const incSChema: Boolean ; const incProps: Boolean ; const incData: Boolean ; const incBlobs: Boolean ; const incNullFields: Boolean) : WideString;

C# Syntax:

public WideString ReportingService.GetDatasetJson(WideString SchemaTableName , WideString WhereXML , Boolean incSChema , Boolean incProps , Boolean incData , Boolean incBlobs , Boolean incNullFields);

Method GetSchemaTablesJson


					

Parameters:

Flag Name Type Description
In IncProps Boolean

							
In IncSchema Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method ReportingService.GetSchemaTablesJson(const IncProps: Boolean ; const IncSchema: Boolean) : WideString;

C# Syntax:

public WideString ReportingService.GetSchemaTablesJson(Boolean IncProps , Boolean IncSchema);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String ReportingService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary ReportingService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary ReportingService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer ReportingService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer ReportingService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String ReportingService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String ReportingService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary ReportingService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method ReportingService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary ReportingService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer ReportingService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method ReportingService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer ReportingService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method ReportingService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String ReportingService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method ReportingService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void ReportingService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method ReportingService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void ReportingService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method ReportingService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray ReportingService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method ReportingService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray ReportingService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service FileService

The following table lists the Operations defined in "FileService":

UploadChunk

							
UploadFinished

							
SelfTest
1) Make sure there is an UploadFolder value 2) Make sure the folder exists (forceDirectories) 3) Make sure it's writeable
GetFileVersionInfo
Returns the file version info as out params, result is if the fileexists in downloadfolder
GetFileSize

							
GetClientInstallFilename

							
DownloadFileExists

							
GetClientUpgradeFilename

							
GetClientUpgradeFilename64

							
GetApplicationFilesList

							
GetApplicationVersion

							
DownloadApplicationSequence

							
DownloadSequence

							
SelfTestUpload

							
DownloadApplicationSequenceEx

							
DownloadSequenceEx

							
GetApplicationFilesListEx

							
GetApplicationVersionEx

							
LibraryDownloadChunk

							
LibraryUploadChunk

							
LibraryDownloadFile

							
LibraryUploadFile

							
LibraryFileExists

							
LibraryFolderCheck

							
LibraryDiskSpaceKb

							
LibraryDeleteFile

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method UploadChunk


					

Parameters:

Flag Name Type Description
In isFirst Boolean

							
In filename WideString

							
In filedata Binary

							

Return Value:

None.

Oxygene Syntax:

method FileService.UploadChunk(const isFirst: Boolean ; const filename: WideString ; const filedata: Binary);

C# Syntax:

public void FileService.UploadChunk(Boolean isFirst , WideString filename , Binary filedata);

Method UploadFinished


					

Parameters:

Flag Name Type Description
In filenanme WideString

							
In filesize Int64

							

Return Value:

None.

Oxygene Syntax:

method FileService.UploadFinished(const filenanme: WideString ; const filesize: Int64);

C# Syntax:

public void FileService.UploadFinished(WideString filenanme , Int64 filesize);

Method SelfTest

1) Make sure there is an UploadFolder value 2) Make sure the folder exists (forceDirectories) 3) Make sure it's writeable

Parameters:

None.

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method FileService.SelfTest() : Boolean;

C# Syntax:

public Boolean FileService.SelfTest();

Method GetFileVersionInfo

Returns the file version info as out params, result is if the fileexists in downloadfolder

Parameters:

Flag Name Type Description
In aFilename WideString

							
Out aMajor Integer

							
Out aMinor Integer

							
Out aRelease Integer

							
Out aBuild Integer

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method FileService.GetFileVersionInfo(const aFilename: WideString ; aMajor: Integer ; aMinor: Integer ; aRelease: Integer ; aBuild: Integer) : Boolean;

C# Syntax:

public Boolean FileService.GetFileVersionInfo(WideString aFilename , out Int32 aMajor , out Int32 aMinor , out Int32 aRelease , out Int32 aBuild);

Method GetFileSize


					

Parameters:

Flag Name Type Description
In aFilename WideString

							

Return Value:

Flag Name Type
Result Result Int64

Oxygene Syntax:

method FileService.GetFileSize(const aFilename: WideString) : Int64;

C# Syntax:

public Int64 FileService.GetFileSize(WideString aFilename);

Method GetClientInstallFilename


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method FileService.GetClientInstallFilename() : WideString;

C# Syntax:

public WideString FileService.GetClientInstallFilename();

Method DownloadFileExists


					

Parameters:

Flag Name Type Description
In aFilename WideString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method FileService.DownloadFileExists(const aFilename: WideString) : Boolean;

C# Syntax:

public Boolean FileService.DownloadFileExists(WideString aFilename);

Method GetClientUpgradeFilename


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method FileService.GetClientUpgradeFilename() : WideString;

C# Syntax:

public WideString FileService.GetClientUpgradeFilename();

Method GetClientUpgradeFilename64


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method FileService.GetClientUpgradeFilename64() : WideString;

C# Syntax:

public WideString FileService.GetClientUpgradeFilename64();

Method GetApplicationFilesList


					

Parameters:

Flag Name Type Description
In aAppName WideString

							
In ArchitectureFlag Integer

							

Return Value:

Flag Name Type
Result Result TFileInfoArray

Oxygene Syntax:

method FileService.GetApplicationFilesList(const aAppName: WideString ; const ArchitectureFlag: Integer) : TFileInfoArray;

C# Syntax:

public TFileInfoArray FileService.GetApplicationFilesList(WideString aAppName , Int32 ArchitectureFlag);

Method GetApplicationVersion


					

Parameters:

Flag Name Type Description
In aAppName WideString

							
In ArchitectureFlag Integer

							

Return Value:

Flag Name Type
Result Result TFileVersionInfo

Oxygene Syntax:

method FileService.GetApplicationVersion(const aAppName: WideString ; const ArchitectureFlag: Integer) : TFileVersionInfo;

C# Syntax:

public TFileVersionInfo FileService.GetApplicationVersion(WideString aAppName , Int32 ArchitectureFlag);

Method DownloadApplicationSequence


					

Parameters:

Flag Name Type Description
In Filename WideString

							
In aAppName WideString

							
In Architecture Integer

							
In Sequence Integer

							
Out filedata Binary

							
Out filesize Int64

							
InOut Block Integer

							
In ClientDetailsCSV WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.DownloadApplicationSequence(const Filename: WideString ; const aAppName: WideString ; const Architecture: Integer ; const Sequence: Integer ; filedata: Binary ; filesize: Int64 ; var Block: Integer ; const ClientDetailsCSV: WideString);

C# Syntax:

public void FileService.DownloadApplicationSequence(WideString Filename , WideString aAppName , Int32 Architecture , Int32 Sequence , out Binary filedata , out Int64 filesize , ref Int32 Block , WideString ClientDetailsCSV);

Method DownloadSequence


					

Parameters:

Flag Name Type Description
In filename WideString

							
In sequence Integer

							
Out filedata Binary

							
Out filesize Int64

							
InOut Block Integer

							
In ClientDetailsCSV WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.DownloadSequence(const filename: WideString ; const sequence: Integer ; filedata: Binary ; filesize: Int64 ; var Block: Integer ; const ClientDetailsCSV: WideString);

C# Syntax:

public void FileService.DownloadSequence(WideString filename , Int32 sequence , out Binary filedata , out Int64 filesize , ref Int32 Block , WideString ClientDetailsCSV);

Method SelfTestUpload


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method FileService.SelfTestUpload() : Boolean;

C# Syntax:

public Boolean FileService.SelfTestUpload();

Method DownloadApplicationSequenceEx


					

Parameters:

Flag Name Type Description
In Filename WideString

							
In aAppName WideString

							
In Architecture Integer

							
In ChannelID Integer

							
In Sequence Integer

							
Out filedata Binary

							
Out filesize Int64

							
InOut Block Integer

							
In ClientDetailsCSV WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.DownloadApplicationSequenceEx(const Filename: WideString ; const aAppName: WideString ; const Architecture: Integer ; const ChannelID: Integer ; const Sequence: Integer ; filedata: Binary ; filesize: Int64 ; var Block: Integer ; const ClientDetailsCSV: WideString);

C# Syntax:

public void FileService.DownloadApplicationSequenceEx(WideString Filename , WideString aAppName , Int32 Architecture , Int32 ChannelID , Int32 Sequence , out Binary filedata , out Int64 filesize , ref Int32 Block , WideString ClientDetailsCSV);

Method DownloadSequenceEx


					

Parameters:

Flag Name Type Description
In filename WideString

							
In ChannelID Integer

							
In sequence Integer

							
Out filedata Binary

							
Out filesize Int64

							
InOut Block Integer

							
In ClientDetails WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.DownloadSequenceEx(const filename: WideString ; const ChannelID: Integer ; const sequence: Integer ; filedata: Binary ; filesize: Int64 ; var Block: Integer ; const ClientDetails: WideString);

C# Syntax:

public void FileService.DownloadSequenceEx(WideString filename , Int32 ChannelID , Int32 sequence , out Binary filedata , out Int64 filesize , ref Int32 Block , WideString ClientDetails);

Method GetApplicationFilesListEx


					

Parameters:

Flag Name Type Description
In aAppName WideString

							
In ArchitectureFlag Integer

							
In ChannelID Integer

							

Return Value:

Flag Name Type
Result Result TFileInfoArray

Oxygene Syntax:

method FileService.GetApplicationFilesListEx(const aAppName: WideString ; const ArchitectureFlag: Integer ; const ChannelID: Integer) : TFileInfoArray;

C# Syntax:

public TFileInfoArray FileService.GetApplicationFilesListEx(WideString aAppName , Int32 ArchitectureFlag , Int32 ChannelID);

Method GetApplicationVersionEx


					

Parameters:

Flag Name Type Description
In aAppName WideString

							
In ArchitectureFlag Integer

							
In ChannelID Integer

							

Return Value:

Flag Name Type
Result Result TFileVersionInfo

Oxygene Syntax:

method FileService.GetApplicationVersionEx(const aAppName: WideString ; const ArchitectureFlag: Integer ; const ChannelID: Integer) : TFileVersionInfo;

C# Syntax:

public TFileVersionInfo FileService.GetApplicationVersionEx(WideString aAppName , Int32 ArchitectureFlag , Int32 ChannelID);

Method LibraryDownloadChunk


					

Parameters:

Flag Name Type Description
In DatabaseIDs StringArray

							
In sequence Integer

							
Out filedata Binary

							
Out filesize Int64

							
Out filetype WideString

							
InOut block Integer

							
In ClientDetails WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.LibraryDownloadChunk(const DatabaseIDs: StringArray ; const sequence: Integer ; filedata: Binary ; filesize: Int64 ; filetype: WideString ; var block: Integer ; const ClientDetails: WideString);

C# Syntax:

public void FileService.LibraryDownloadChunk(StringArray DatabaseIDs , Int32 sequence , out Binary filedata , out Int64 filesize , out WideString filetype , ref Int32 block , WideString ClientDetails);

Method LibraryUploadChunk


					

Parameters:

Flag Name Type Description
In DatabaseIDs StringArray

							
In isFirst Boolean

							
In filedata Binary

							
InOut filetype WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.LibraryUploadChunk(const DatabaseIDs: StringArray ; const isFirst: Boolean ; const filedata: Binary ; var filetype: WideString);

C# Syntax:

public void FileService.LibraryUploadChunk(StringArray DatabaseIDs , Boolean isFirst , Binary filedata , ref WideString filetype);

Method LibraryDownloadFile


					

Parameters:

Flag Name Type Description
In DatabaseIDs StringArray

							
Out filedata Binary

							
InOut filetype WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.LibraryDownloadFile(const DatabaseIDs: StringArray ; filedata: Binary ; var filetype: WideString);

C# Syntax:

public void FileService.LibraryDownloadFile(StringArray DatabaseIDs , out Binary filedata , ref WideString filetype);

Method LibraryUploadFile


					

Parameters:

Flag Name Type Description
In DatabaseIDs StringArray

							
In filedata Binary

							
InOut filetype WideString

							

Return Value:

None.

Oxygene Syntax:

method FileService.LibraryUploadFile(const DatabaseIDs: StringArray ; const filedata: Binary ; var filetype: WideString);

C# Syntax:

public void FileService.LibraryUploadFile(StringArray DatabaseIDs , Binary filedata , ref WideString filetype);

Method LibraryFileExists


					

Parameters:

Flag Name Type Description
In DatabaseIDs StringArray

							
InOut filetype WideString

							
Out filesizekb Int64

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method FileService.LibraryFileExists(const DatabaseIDs: StringArray ; var filetype: WideString ; filesizekb: Int64) : Boolean;

C# Syntax:

public Boolean FileService.LibraryFileExists(StringArray DatabaseIDs , ref WideString filetype , out Int64 filesizekb);

Method LibraryFolderCheck


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method FileService.LibraryFolderCheck() : Boolean;

C# Syntax:

public Boolean FileService.LibraryFolderCheck();

Method LibraryDiskSpaceKb


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Int64

Oxygene Syntax:

method FileService.LibraryDiskSpaceKb() : Int64;

C# Syntax:

public Int64 FileService.LibraryDiskSpaceKb();

Method LibraryDeleteFile


					

Parameters:

Flag Name Type Description
In DatabaseIDs StringArray

							
InOut filetype WideString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method FileService.LibraryDeleteFile(const DatabaseIDs: StringArray ; var filetype: WideString) : Boolean;

C# Syntax:

public Boolean FileService.LibraryDeleteFile(StringArray DatabaseIDs , ref WideString filetype);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method FileService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String FileService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method FileService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary FileService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method FileService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary FileService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method FileService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer FileService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method FileService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer FileService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method FileService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String FileService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method FileService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String FileService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method FileService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary FileService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method FileService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary FileService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method FileService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer FileService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method FileService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer FileService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method FileService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String FileService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method FileService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void FileService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method FileService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void FileService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method FileService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray FileService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method FileService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray FileService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service MetaService

The following table lists the Operations defined in "MetaService":

UpdateDatabase

							
GetSQLDataset

							
RunSQLCommand

							
IndexReorgRebuild

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method UpdateDatabase


					

Parameters:

Flag Name Type Description
Out NewVerMajor Integer

							
Out NewVerMinor Integer

							
Out ChangeCount Integer

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method MetaService.UpdateDatabase(NewVerMajor: Integer ; NewVerMinor: Integer ; ChangeCount: Integer) : Boolean;

C# Syntax:

public Boolean MetaService.UpdateDatabase(out Int32 NewVerMajor , out Int32 NewVerMinor , out Int32 ChangeCount);

Method GetSQLDataset


					

Parameters:

Flag Name Type Description
In aXMLString WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MetaService.GetSQLDataset(const aXMLString: WideString) : Binary;

C# Syntax:

public Binary MetaService.GetSQLDataset(WideString aXMLString);

Method RunSQLCommand


					

Parameters:

Flag Name Type Description
In aXMLString WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MetaService.RunSQLCommand(const aXMLString: WideString) : Integer;

C# Syntax:

public Integer MetaService.RunSQLCommand(WideString aXMLString);

Method IndexReorgRebuild


					

Parameters:

Flag Name Type Description
In DoReorg Boolean

							
In DoRebuild Boolean

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MetaService.IndexReorgRebuild(const DoReorg: Boolean ; const DoRebuild: Boolean) : Integer;

C# Syntax:

public Integer MetaService.IndexReorgRebuild(Boolean DoReorg , Boolean DoRebuild);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MetaService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String MetaService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MetaService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary MetaService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MetaService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary MetaService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MetaService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer MetaService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MetaService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer MetaService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MetaService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String MetaService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MetaService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String MetaService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MetaService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary MetaService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method MetaService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary MetaService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MetaService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer MetaService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method MetaService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer MetaService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method MetaService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String MetaService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method MetaService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void MetaService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method MetaService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void MetaService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method MetaService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray MetaService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method MetaService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray MetaService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service RegistrationService

The following table lists the Operations defined in "RegistrationService":

Get_IBID_Unit_ID

							
Set_IBID_Unit_ID

							
Validate_IBID_Unit_ID

							
Register

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method Get_IBID_Unit_ID


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method RegistrationService.Get_IBID_Unit_ID() : WideString;

C# Syntax:

public WideString RegistrationService.Get_IBID_Unit_ID();

Method Set_IBID_Unit_ID


					

Parameters:

Flag Name Type Description
In Unit_ID WideString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method RegistrationService.Set_IBID_Unit_ID(const Unit_ID: WideString) : Boolean;

C# Syntax:

public Boolean RegistrationService.Set_IBID_Unit_ID(WideString Unit_ID);

Method Validate_IBID_Unit_ID


					

Parameters:

Flag Name Type Description
In Unit_ID WideString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method RegistrationService.Validate_IBID_Unit_ID(const Unit_ID: WideString) : Boolean;

C# Syntax:

public Boolean RegistrationService.Validate_IBID_Unit_ID(WideString Unit_ID);

Method Register


					

Parameters:

Flag Name Type Description
In RegistrationCode WideString

							
In SubSystemID WideString

							
In RegUserName WideString

							
In RegComputerName WideString

							
In RegOrgCode WideString

							
Out ResultMessage WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method RegistrationService.Register(const RegistrationCode: WideString ; const SubSystemID: WideString ; const RegUserName: WideString ; const RegComputerName: WideString ; const RegOrgCode: WideString ; ResultMessage: WideString) : Integer;

C# Syntax:

public Integer RegistrationService.Register(WideString RegistrationCode , WideString SubSystemID , WideString RegUserName , WideString RegComputerName , WideString RegOrgCode , out WideString ResultMessage);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method RegistrationService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String RegistrationService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method RegistrationService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary RegistrationService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method RegistrationService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary RegistrationService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method RegistrationService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer RegistrationService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method RegistrationService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer RegistrationService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method RegistrationService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String RegistrationService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method RegistrationService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String RegistrationService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method RegistrationService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary RegistrationService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method RegistrationService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary RegistrationService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method RegistrationService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer RegistrationService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method RegistrationService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer RegistrationService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method RegistrationService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String RegistrationService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method RegistrationService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void RegistrationService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method RegistrationService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void RegistrationService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method RegistrationService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray RegistrationService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method RegistrationService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray RegistrationService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service Telemedicine

The following table lists the Operations defined in "Telemedicine":

GetTableCounts

							

Method GetTableCounts


					

Parameters:

Flag Name Type Description
In TableNames StringArray

							
In aCaseID WideString

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method Telemedicine.GetTableCounts(const TableNames: StringArray ; const aCaseID: WideString) : WideString;

C# Syntax:

public WideString Telemedicine.GetTableCounts(StringArray TableNames , WideString aCaseID);
Service iBIDSvc

The following table lists the Operations defined in "iBIDSvc":

InPatientStatus
0 = InPatient 1 = OutPatient 2 = Discharged from Service (i.e. not a patient)
DependencyCalcs

							
DependencyCalcsDateRange

							
IBIDAnalysisCalcs

							
IBIDAnalysisCalcsMulti

							
IBIDAnalysisCalcsDateRange

							
ServerTime

							
CanImportBIBID

							
StartATransaction

							
CommitATransaction

							
RollbackATransaction

							
DependencyCountForPatient

							
IBIDRecordCount

							
DeleteIBID

							
DeleteDependency

							
MoveDependency

							
MoveIBID

							
GetSchemaTablesJson

							
GetDatasetJson

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method InPatientStatus

0 = InPatient 1 = OutPatient 2 = Discharged from Service (i.e. not a patient)

Parameters:

Flag Name Type Description
In Patient_ID WideString

							
In TargetDate DateTime

							
Out Death Boolean

							
Out IBID_MAIN_ID WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.InPatientStatus(const Patient_ID: WideString ; const TargetDate: DateTime ; Death: Boolean ; IBID_MAIN_ID: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.InPatientStatus(WideString Patient_ID , DateTime TargetDate , out Boolean Death , out WideString IBID_MAIN_ID);

Method DependencyCalcs


					

Parameters:

Flag Name Type Description
In DEPENDENCY_ID WideString

							
In UserName WideString

							
In IncIBIDCalcs Boolean

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.DependencyCalcs(const DEPENDENCY_ID: WideString ; const UserName: WideString ; const IncIBIDCalcs: Boolean) : Integer;

C# Syntax:

public Integer iBIDSvc.DependencyCalcs(WideString DEPENDENCY_ID , WideString UserName , Boolean IncIBIDCalcs);

Method DependencyCalcsDateRange


					

Parameters:

Flag Name Type Description
In FromDate DateTime

							
In ToDate DateTime

							
In IncIBIDCalcs Boolean

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.DependencyCalcsDateRange(const FromDate: DateTime ; const ToDate: DateTime ; const IncIBIDCalcs: Boolean) : Integer;

C# Syntax:

public Integer iBIDSvc.DependencyCalcsDateRange(DateTime FromDate , DateTime ToDate , Boolean IncIBIDCalcs);

Method IBIDAnalysisCalcs


					

Parameters:

Flag Name Type Description
In IBID_MAIN_ID WideString

							
In UserName WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.IBIDAnalysisCalcs(const IBID_MAIN_ID: WideString ; const UserName: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.IBIDAnalysisCalcs(WideString IBID_MAIN_ID , WideString UserName);

Method IBIDAnalysisCalcsMulti


					

Parameters:

Flag Name Type Description
In IBID_MAIN_IDS StringArray

							
In UserName WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.IBIDAnalysisCalcsMulti(const IBID_MAIN_IDS: StringArray ; const UserName: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.IBIDAnalysisCalcsMulti(StringArray IBID_MAIN_IDS , WideString UserName);

Method IBIDAnalysisCalcsDateRange


					

Parameters:

Flag Name Type Description
In FromDate DateTime

							
In ToDate DateTime

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.IBIDAnalysisCalcsDateRange(const FromDate: DateTime ; const ToDate: DateTime) : Integer;

C# Syntax:

public Integer iBIDSvc.IBIDAnalysisCalcsDateRange(DateTime FromDate , DateTime ToDate);

Method ServerTime


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result DateTime

Oxygene Syntax:

method iBIDSvc.ServerTime() : DateTime;

C# Syntax:

public DateTime iBIDSvc.ServerTime();

Method CanImportBIBID


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method iBIDSvc.CanImportBIBID() : Boolean;

C# Syntax:

public Boolean iBIDSvc.CanImportBIBID();

Method StartATransaction


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method iBIDSvc.StartATransaction();

C# Syntax:

public void iBIDSvc.StartATransaction();

Method CommitATransaction


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method iBIDSvc.CommitATransaction();

C# Syntax:

public void iBIDSvc.CommitATransaction();

Method RollbackATransaction


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method iBIDSvc.RollbackATransaction();

C# Syntax:

public void iBIDSvc.RollbackATransaction();

Method DependencyCountForPatient


					

Parameters:

Flag Name Type Description
In Patient_ID WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.DependencyCountForPatient(const Patient_ID: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.DependencyCountForPatient(WideString Patient_ID);

Method IBIDRecordCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.IBIDRecordCount() : Integer;

C# Syntax:

public Integer iBIDSvc.IBIDRecordCount();

Method DeleteIBID


					

Parameters:

Flag Name Type Description
In aIBIDMainID WideString

							
In aUserName WideString

							
Out AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.DeleteIBID(const aIBIDMainID: WideString ; const aUserName: WideString ; AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.DeleteIBID(WideString aIBIDMainID , WideString aUserName , out Int32 AffectedRecordCount , WideString aReason);

Method DeleteDependency


					

Parameters:

Flag Name Type Description
In aDependencyID WideString

							
In aUserName WideString

							
Out AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.DeleteDependency(const aDependencyID: WideString ; const aUserName: WideString ; AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.DeleteDependency(WideString aDependencyID , WideString aUserName , out Int32 AffectedRecordCount , WideString aReason);

Method MoveDependency


					

Parameters:

Flag Name Type Description
In aDependencyID WideString

							
In NewPatientID WideString

							
In NewCaseID WideString

							
In NewIBIDMainID WideString

							
In aUserName WideString

							
Out AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.MoveDependency(const aDependencyID: WideString ; const NewPatientID: WideString ; const NewCaseID: WideString ; const NewIBIDMainID: WideString ; const aUserName: WideString ; AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.MoveDependency(WideString aDependencyID , WideString NewPatientID , WideString NewCaseID , WideString NewIBIDMainID , WideString aUserName , out Int32 AffectedRecordCount , WideString aReason);

Method MoveIBID


					

Parameters:

Flag Name Type Description
In aIBIDMainID WideString

							
In NewPatientID WideString

							
In NewCaseID WideString

							
In aUsername WideString

							
Out AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.MoveIBID(const aIBIDMainID: WideString ; const NewPatientID: WideString ; const NewCaseID: WideString ; const aUsername: WideString ; AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.MoveIBID(WideString aIBIDMainID , WideString NewPatientID , WideString NewCaseID , WideString aUsername , out Int32 AffectedRecordCount , WideString aReason);

Method GetSchemaTablesJson


					

Parameters:

Flag Name Type Description
In IncProps Boolean

							
In IncSchema Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method iBIDSvc.GetSchemaTablesJson(const IncProps: Boolean ; const IncSchema: Boolean) : WideString;

C# Syntax:

public WideString iBIDSvc.GetSchemaTablesJson(Boolean IncProps , Boolean IncSchema);

Method GetDatasetJson


					

Parameters:

Flag Name Type Description
In SchemaTableName WideString

							
In WhereXML WideString

							
In IncSchema Boolean

							
In IncProps Boolean

							
In IncData Boolean

							
In IncBlobs Boolean

							
In IncNullFields Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method iBIDSvc.GetDatasetJson(const SchemaTableName: WideString ; const WhereXML: WideString ; const IncSchema: Boolean ; const IncProps: Boolean ; const IncData: Boolean ; const IncBlobs: Boolean ; const IncNullFields: Boolean) : WideString;

C# Syntax:

public WideString iBIDSvc.GetDatasetJson(WideString SchemaTableName , WideString WhereXML , Boolean IncSchema , Boolean IncProps , Boolean IncData , Boolean IncBlobs , Boolean IncNullFields);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method iBIDSvc.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String iBIDSvc.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method iBIDSvc.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary iBIDSvc.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method iBIDSvc.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary iBIDSvc.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer iBIDSvc.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer iBIDSvc.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method iBIDSvc.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String iBIDSvc.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method iBIDSvc.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String iBIDSvc.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method iBIDSvc.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary iBIDSvc.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method iBIDSvc.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary iBIDSvc.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer iBIDSvc.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method iBIDSvc.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer iBIDSvc.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method iBIDSvc.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String iBIDSvc.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method iBIDSvc.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void iBIDSvc.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method iBIDSvc.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void iBIDSvc.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method iBIDSvc.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray iBIDSvc.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method iBIDSvc.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray iBIDSvc.SimpleUpdateData(SimpleDeltaArray aDelta);
Service LoginService

The following table lists the Operations defined in "LoginService":

ChangePassword

							
GetSessionCount

							
createSession

							
deleteSession

							
ClearExpiredSessions

							
Login

							
LoginEx

							
Logout

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method ChangePassword


					

Parameters:

Flag Name Type Description
In OldPassword WideString

							
In NewPassword WideString

							
In Username WideString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method LoginService.ChangePassword(const OldPassword: WideString ; const NewPassword: WideString ; const Username: WideString) : Boolean;

C# Syntax:

public Boolean LoginService.ChangePassword(WideString OldPassword , WideString NewPassword , WideString Username);

Method GetSessionCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method LoginService.GetSessionCount() : Integer;

C# Syntax:

public Integer LoginService.GetSessionCount();

Method createSession


					

Parameters:

Flag Name Type Description
In aloginRequest LoginRequest

							

Return Value:

Flag Name Type
Result Result UserInfo

Oxygene Syntax:

method LoginService.createSession(const aloginRequest: LoginRequest) : UserInfo;

C# Syntax:

public UserInfo LoginService.createSession(LoginRequest aloginRequest);

Method deleteSession


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method LoginService.deleteSession();

C# Syntax:

public void LoginService.deleteSession();

Method ClearExpiredSessions


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method LoginService.ClearExpiredSessions() : Integer;

C# Syntax:

public Integer LoginService.ClearExpiredSessions();

Method Login


					

Parameters:

Flag Name Type Description
In aUserID Utf8String

							
In aPassword Utf8String

							
Out aUserInfo UserInfo

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method LoginService.Login(const aUserID: Utf8String ; const aPassword: Utf8String ; aUserInfo: UserInfo) : Boolean;

C# Syntax:

public Boolean LoginService.Login(Utf8String aUserID , Utf8String aPassword , out UserInfo aUserInfo);

Method LoginEx


					

Parameters:

Flag Name Type Description
In aLoginString Utf8String

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method LoginService.LoginEx(const aLoginString: Utf8String) : Boolean;

C# Syntax:

public Boolean LoginService.LoginEx(Utf8String aLoginString);

Method Logout


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method LoginService.Logout();

C# Syntax:

public void LoginService.Logout();

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method LoginService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String LoginService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method LoginService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary LoginService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method LoginService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary LoginService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method LoginService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer LoginService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method LoginService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer LoginService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method LoginService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String LoginService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method LoginService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String LoginService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method LoginService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary LoginService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method LoginService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary LoginService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method LoginService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer LoginService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method LoginService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer LoginService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method LoginService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String LoginService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method LoginService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void LoginService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method LoginService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void LoginService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method LoginService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray LoginService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method LoginService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray LoginService.SimpleUpdateData(SimpleDeltaArray aDelta);
Service AquilaService

The following table lists the Operations defined in "AquilaService":

ConnectionString

							
ConnectionType

							
StartATransaction

							
CommitATransaction

							
RollbackATransaction

							
ILogTotalCount

							
ILogUnsubmittedCount

							
ILogRecordExportFile

							
ILogChangeStatusFromTo

							
SetPatientDeceased

							
CloseConnection

							
GetServerTime

							
ReadAppSetting

							
WriteAppSetting

							
ResetCacheDate

							
DeleteTestUnits_ILOG_REPL

							
ActiveReplicaUnitIDs

							
PatientCount

							
ServerVersion

							
GetDatabaseVersion

							
GetRecordCount

							
TestTransactions

							
TestAuditXML

							
DeletePatientDemographics

							
DeletePatientFolder

							
MoveFolder

							
MoveImage

							
ReadINIBool

							
ReadINIDateTime

							
ReadINIFloat

							
ReadINIInteger

							
ReadINIString

							
WriteINIBool

							
WriteINIDateTime

							
WriteINIFloat

							
WriteINIInteger

							
WriteINIString

							
GetHash

							
ClearAllSessions

							
GetDatabaseID

							
GetMaxSessionCount

							
GetActiveSessionCount

							
GetActiveSessionDetailsJSON

							
GetUserSessionsInfo

							
ServerLicense

							
UpdateLicense

							
SessionCommand

							
GetMediaStorageMethod

							
GetLibraryPath

							
GetLibraryInfo

							
GetDatabaseProductInfo

							
GetMediaItemStreamJson

							
GetDatasetJson

							
GetSchemaTablesJson

							
GetILOGJson

							
GetAuditTrail

							
DeleteAllSessions

							
DeleteSession

							
ServerLog

							
NHSNumberCheck

							
UpdateRulesFromJSON

							
GetSchema

							
GetData

							
UpdateData

							
ExecuteCommand

							
ExecuteCommandEx

							
GetTableSchema

							
GetCommandSchema

							
SQLGetData

							
SQLGetDataEx

							
SQLExecuteCommand

							
SQLExecuteCommandEx

							
GetDatasetScripts

							
RegisterForDataChangeNotification

							
UnregisterForDataChangeNotification

							
SimpleGetData

							
SimpleUpdateData

							

Method ConnectionString


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.ConnectionString() : WideString;

C# Syntax:

public WideString AquilaService.ConnectionString();

Method ConnectionType


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.ConnectionType() : WideString;

C# Syntax:

public WideString AquilaService.ConnectionType();

Method StartATransaction


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method AquilaService.StartATransaction();

C# Syntax:

public void AquilaService.StartATransaction();

Method CommitATransaction


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method AquilaService.CommitATransaction();

C# Syntax:

public void AquilaService.CommitATransaction();

Method RollbackATransaction


					

Parameters:

None.

Return Value:

None.

Oxygene Syntax:

method AquilaService.RollbackATransaction();

C# Syntax:

public void AquilaService.RollbackATransaction();

Method ILogTotalCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.ILogTotalCount() : Integer;

C# Syntax:

public Integer AquilaService.ILogTotalCount();

Method ILogUnsubmittedCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.ILogUnsubmittedCount() : Integer;

C# Syntax:

public Integer AquilaService.ILogUnsubmittedCount();

Method ILogRecordExportFile


					

Parameters:

Flag Name Type Description
In aFilename WideString

							
In aSnapShotTime DateTime

							
In aUnitID WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.ILogRecordExportFile(const aFilename: WideString ; const aSnapShotTime: DateTime ; const aUnitID: WideString) : Integer;

C# Syntax:

public Integer AquilaService.ILogRecordExportFile(WideString aFilename , DateTime aSnapShotTime , WideString aUnitID);

Method ILogChangeStatusFromTo


					

Parameters:

Flag Name Type Description
In FromStatus Integer

							
In ToStatus Integer

							
In aSnapshotTime DateTime

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.ILogChangeStatusFromTo(const FromStatus: Integer ; const ToStatus: Integer ; const aSnapshotTime: DateTime) : Integer;

C# Syntax:

public Integer AquilaService.ILogChangeStatusFromTo( Int32 FromStatus , Int32 ToStatus , DateTime aSnapshotTime);

Method SetPatientDeceased


					

Parameters:

Flag Name Type Description
In Patient_ID WideString

							
In Date_of_Death DateTime

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method AquilaService.SetPatientDeceased(const Patient_ID: WideString ; const Date_of_Death: DateTime) : Boolean;

C# Syntax:

public Boolean AquilaService.SetPatientDeceased(WideString Patient_ID , DateTime Date_of_Death);

Method CloseConnection


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method AquilaService.CloseConnection() : Boolean;

C# Syntax:

public Boolean AquilaService.CloseConnection();

Method GetServerTime


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result DateTime

Oxygene Syntax:

method AquilaService.GetServerTime() : DateTime;

C# Syntax:

public DateTime AquilaService.GetServerTime();

Method ReadAppSetting


					

Parameters:

Flag Name Type Description
In ModuleName WideString

							
In AttributeName WideString

							
Out AValue WideString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method AquilaService.ReadAppSetting(const ModuleName: WideString ; const AttributeName: WideString ; AValue: WideString) : Boolean;

C# Syntax:

public Boolean AquilaService.ReadAppSetting(WideString ModuleName , WideString AttributeName , out WideString AValue);

Method WriteAppSetting


					

Parameters:

Flag Name Type Description
In ModuleName WideString

							
In AttributeName WideString

							
In AValue WideString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method AquilaService.WriteAppSetting(const ModuleName: WideString ; const AttributeName: WideString ; const AValue: WideString) : Boolean;

C# Syntax:

public Boolean AquilaService.WriteAppSetting(WideString ModuleName , WideString AttributeName , WideString AValue);

Method ResetCacheDate


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method AquilaService.ResetCacheDate() : Boolean;

C# Syntax:

public Boolean AquilaService.ResetCacheDate();

Method DeleteTestUnits_ILOG_REPL


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.DeleteTestUnits_ILOG_REPL() : Integer;

C# Syntax:

public Integer AquilaService.DeleteTestUnits_ILOG_REPL();

Method ActiveReplicaUnitIDs


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result StringArray

Oxygene Syntax:

method AquilaService.ActiveReplicaUnitIDs() : StringArray;

C# Syntax:

public StringArray AquilaService.ActiveReplicaUnitIDs();

Method PatientCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.PatientCount() : Integer;

C# Syntax:

public Integer AquilaService.PatientCount();

Method ServerVersion


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.ServerVersion() : WideString;

C# Syntax:

public WideString AquilaService.ServerVersion();

Method GetDatabaseVersion


					

Parameters:

Flag Name Type Description
Out aMajor Integer

							
Out aMinor Integer

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetDatabaseVersion(aMajor: Integer ; aMinor: Integer) : WideString;

C# Syntax:

public WideString AquilaService.GetDatabaseVersion(out Int32 aMajor , out Int32 aMinor);

Method GetRecordCount


					

Parameters:

Flag Name Type Description
In aTableName AnsiString

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.GetRecordCount(const aTableName: AnsiString ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer AquilaService.GetRecordCount(AnsiString aTableName , WideString aDynamicWhereXML);

Method TestTransactions


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.TestTransactions() : Integer;

C# Syntax:

public Integer AquilaService.TestTransactions();

Method TestAuditXML


					

Parameters:

Flag Name Type Description
In aLogicalName WideString

							
In aIDValue WideString

							
In aPKFieldName WideString

							
In aChangeType Integer

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.TestAuditXML(const aLogicalName: WideString ; const aIDValue: WideString ; const aPKFieldName: WideString ; const aChangeType: Integer) : WideString;

C# Syntax:

public WideString AquilaService.TestAuditXML(WideString aLogicalName , WideString aIDValue , WideString aPKFieldName , Int32 aChangeType);

Method DeletePatientDemographics


					

Parameters:

Flag Name Type Description
In aPatientID WideString

							
In aUserName WideString

							
InOut AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.DeletePatientDemographics(const aPatientID: WideString ; const aUserName: WideString ; var AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer AquilaService.DeletePatientDemographics(WideString aPatientID , WideString aUserName , ref Int32 AffectedRecordCount , WideString aReason);

Method DeletePatientFolder


					

Parameters:

Flag Name Type Description
In aCaseID WideString

							
In aUserName WideString

							
InOut AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.DeletePatientFolder(const aCaseID: WideString ; const aUserName: WideString ; var AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer AquilaService.DeletePatientFolder(WideString aCaseID , WideString aUserName , ref Int32 AffectedRecordCount , WideString aReason);

Method MoveFolder


					

Parameters:

Flag Name Type Description
In aFolderID WideString

							
In NewPatientID WideString

							
In aUserName WideString

							
Out AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.MoveFolder(const aFolderID: WideString ; const NewPatientID: WideString ; const aUserName: WideString ; AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer AquilaService.MoveFolder(WideString aFolderID , WideString NewPatientID , WideString aUserName , out Int32 AffectedRecordCount , WideString aReason);

Method MoveImage


					

Parameters:

Flag Name Type Description
In aImageID WideString

							
In NewTargetID WideString

							
In NewFolderID WideString

							
In NewPatientID WideString

							
In aUserName WideString

							
Out AffectedRecordCount Integer

							
In aReason WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.MoveImage(const aImageID: WideString ; const NewTargetID: WideString ; const NewFolderID: WideString ; const NewPatientID: WideString ; const aUserName: WideString ; AffectedRecordCount: Integer ; const aReason: WideString) : Integer;

C# Syntax:

public Integer AquilaService.MoveImage(WideString aImageID , WideString NewTargetID , WideString NewFolderID , WideString NewPatientID , WideString aUserName , out Int32 AffectedRecordCount , WideString aReason);

Method ReadINIBool


					

Parameters:

Flag Name Type Description
In aName AnsiString

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method AquilaService.ReadINIBool(const aName: AnsiString) : Boolean;

C# Syntax:

public Boolean AquilaService.ReadINIBool(AnsiString aName);

Method ReadINIDateTime


					

Parameters:

Flag Name Type Description
In aName AnsiString

							

Return Value:

Flag Name Type
Result Result DateTime

Oxygene Syntax:

method AquilaService.ReadINIDateTime(const aName: AnsiString) : DateTime;

C# Syntax:

public DateTime AquilaService.ReadINIDateTime(AnsiString aName);

Method ReadINIFloat


					

Parameters:

Flag Name Type Description
In aName AnsiString

							

Return Value:

Flag Name Type
Result Result Double

Oxygene Syntax:

method AquilaService.ReadINIFloat(const aName: AnsiString) : Double;

C# Syntax:

public Double AquilaService.ReadINIFloat(AnsiString aName);

Method ReadINIInteger


					

Parameters:

Flag Name Type Description
In aName AnsiString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.ReadINIInteger(const aName: AnsiString) : Integer;

C# Syntax:

public Integer AquilaService.ReadINIInteger(AnsiString aName);

Method ReadINIString


					

Parameters:

Flag Name Type Description
In aName AnsiString

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.ReadINIString(const aName: AnsiString) : WideString;

C# Syntax:

public WideString AquilaService.ReadINIString(AnsiString aName);

Method WriteINIBool


					

Parameters:

Flag Name Type Description
In aName AnsiString

							
In aValue Boolean

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.WriteINIBool(const aName: AnsiString ; const aValue: Boolean);

C# Syntax:

public void AquilaService.WriteINIBool(AnsiString aName , Boolean aValue);

Method WriteINIDateTime


					

Parameters:

Flag Name Type Description
In aName AnsiString

							
In aValue DateTime

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.WriteINIDateTime(const aName: AnsiString ; const aValue: DateTime);

C# Syntax:

public void AquilaService.WriteINIDateTime(AnsiString aName , DateTime aValue);

Method WriteINIFloat


					

Parameters:

Flag Name Type Description
In aName AnsiString

							
In aValue Double

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.WriteINIFloat(const aName: AnsiString ; const aValue: Double);

C# Syntax:

public void AquilaService.WriteINIFloat(AnsiString aName , Double aValue);

Method WriteINIInteger


					

Parameters:

Flag Name Type Description
In aName AnsiString

							
In aValue Integer

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.WriteINIInteger(const aName: AnsiString ; const aValue: Integer);

C# Syntax:

public void AquilaService.WriteINIInteger(AnsiString aName , Int32 aValue);

Method WriteINIString


					

Parameters:

Flag Name Type Description
In aName AnsiString

							
In aValue WideString

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.WriteINIString(const aName: AnsiString ; const aValue: WideString);

C# Syntax:

public void AquilaService.WriteINIString(AnsiString aName , WideString aValue);

Method GetHash


					

Parameters:

Flag Name Type Description
In Hash AnsiString

							
In Str WideString

							
In Salt WideString

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetHash(const Hash: AnsiString ; const Str: WideString ; const Salt: WideString) : WideString;

C# Syntax:

public WideString AquilaService.GetHash(AnsiString Hash , WideString Str , WideString Salt);

Method ClearAllSessions


					

Parameters:

Flag Name Type Description
In aExpiredOnly Boolean

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.ClearAllSessions(const aExpiredOnly: Boolean);

C# Syntax:

public void AquilaService.ClearAllSessions(Boolean aExpiredOnly);

Method GetDatabaseID


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetDatabaseID() : WideString;

C# Syntax:

public WideString AquilaService.GetDatabaseID();

Method GetMaxSessionCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.GetMaxSessionCount() : Integer;

C# Syntax:

public Integer AquilaService.GetMaxSessionCount();

Method GetActiveSessionCount


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.GetActiveSessionCount() : Integer;

C# Syntax:

public Integer AquilaService.GetActiveSessionCount();

Method GetActiveSessionDetailsJSON


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetActiveSessionDetailsJSON() : WideString;

C# Syntax:

public WideString AquilaService.GetActiveSessionDetailsJSON();

Method GetUserSessionsInfo


					

Parameters:

Flag Name Type Description
In UserName WideString

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetUserSessionsInfo(const UserName: WideString) : WideString;

C# Syntax:

public WideString AquilaService.GetUserSessionsInfo(WideString UserName);

Method ServerLicense


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.ServerLicense() : WideString;

C# Syntax:

public WideString AquilaService.ServerLicense();

Method UpdateLicense


					

Parameters:

Flag Name Type Description
In aNewLicense WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.UpdateLicense(const aNewLicense: WideString) : Integer;

C# Syntax:

public Integer AquilaService.UpdateLicense(WideString aNewLicense);

Method SessionCommand


					

Parameters:

Flag Name Type Description
In SessionID WideString

							
In CommandType Integer

							

Return Value:

Flag Name Type
Result Result Boolean

Oxygene Syntax:

method AquilaService.SessionCommand(const SessionID: WideString ; const CommandType: Integer) : Boolean;

C# Syntax:

public Boolean AquilaService.SessionCommand(WideString SessionID , Int32 CommandType);

Method GetMediaStorageMethod


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.GetMediaStorageMethod() : Integer;

C# Syntax:

public Integer AquilaService.GetMediaStorageMethod();

Method GetLibraryPath


					

Parameters:

None.

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetLibraryPath() : WideString;

C# Syntax:

public WideString AquilaService.GetLibraryPath();

Method GetLibraryInfo


					

Parameters:

Flag Name Type Description
Out aTotalKb Int64

							
Out aFreeKb Int64

							
Out IsUNC Boolean

							
Out aLibraryPath WideString

							
Out aStorageMethod Integer

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.GetLibraryInfo(aTotalKb: Int64 ; aFreeKb: Int64 ; IsUNC: Boolean ; aLibraryPath: WideString ; aStorageMethod: Integer);

C# Syntax:

public void AquilaService.GetLibraryInfo(out Int64 aTotalKb , out Int64 aFreeKb , out Boolean IsUNC , out WideString aLibraryPath , out Int32 aStorageMethod);

Method GetDatabaseProductInfo


					

Parameters:

Flag Name Type Description
Out MachineName WideString

							
Out ServerName WideString

							
Out ProductVersion WideString

							
Out ProductLevel WideString

							
Out ProductEdition WideString

							
Out FullVersionText WideString

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.GetDatabaseProductInfo(MachineName: WideString ; ServerName: WideString ; ProductVersion: WideString ; ProductLevel: WideString ; ProductEdition: WideString ; FullVersionText: WideString);

C# Syntax:

public void AquilaService.GetDatabaseProductInfo(out WideString MachineName , out WideString ServerName , out WideString ProductVersion , out WideString ProductLevel , out WideString ProductEdition , out WideString FullVersionText);

Method GetMediaItemStreamJson


					

Parameters:

Flag Name Type Description
In aMediaID WideString

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetMediaItemStreamJson(const aMediaID: WideString) : WideString;

C# Syntax:

public WideString AquilaService.GetMediaItemStreamJson(WideString aMediaID);

Method GetDatasetJson


					

Parameters:

Flag Name Type Description
In SchemaTableName WideString

							
In WhereXML WideString

							
In IncSchema Boolean

							
In IncProps Boolean

							
In IncData Boolean

							
In IncBlobs Boolean

							
In IncNullFields Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetDatasetJson(const SchemaTableName: WideString ; const WhereXML: WideString ; const IncSchema: Boolean ; const IncProps: Boolean ; const IncData: Boolean ; const IncBlobs: Boolean ; const IncNullFields: Boolean) : WideString;

C# Syntax:

public WideString AquilaService.GetDatasetJson(WideString SchemaTableName , WideString WhereXML , Boolean IncSchema , Boolean IncProps , Boolean IncData , Boolean IncBlobs , Boolean IncNullFields);

Method GetSchemaTablesJson


					

Parameters:

Flag Name Type Description
In IncProps Boolean

							
In IncSchema Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetSchemaTablesJson(const IncProps: Boolean ; const IncSchema: Boolean) : WideString;

C# Syntax:

public WideString AquilaService.GetSchemaTablesJson(Boolean IncProps , Boolean IncSchema);

Method GetILOGJson


					

Parameters:

Flag Name Type Description
In TableName WideString

							
In PKName WideString

							
In PKValue WideString

							
In incDetailTables Boolean

							
In incPrivateDelta Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetILOGJson(const TableName: WideString ; const PKName: WideString ; const PKValue: WideString ; const incDetailTables: Boolean ; const incPrivateDelta: Boolean) : WideString;

C# Syntax:

public WideString AquilaService.GetILOGJson(WideString TableName , WideString PKName , WideString PKValue , Boolean incDetailTables , Boolean incPrivateDelta);

Method GetAuditTrail


					

Parameters:

Flag Name Type Description
In ID WideString

							
In IDFieldName WideString

							
In SubSystemName WideString

							
In incPrivateDelta Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.GetAuditTrail(const ID: WideString ; const IDFieldName: WideString ; const SubSystemName: WideString ; const incPrivateDelta: Boolean) : WideString;

C# Syntax:

public WideString AquilaService.GetAuditTrail(WideString ID , WideString IDFieldName , WideString SubSystemName , Boolean incPrivateDelta);

Method DeleteAllSessions


					

Parameters:

Flag Name Type Description
In aCurrentSessionID WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.DeleteAllSessions(const aCurrentSessionID: WideString) : Integer;

C# Syntax:

public Integer AquilaService.DeleteAllSessions(WideString aCurrentSessionID);

Method DeleteSession


					

Parameters:

Flag Name Type Description
In aSessionID WideString

							
In IsExpired Boolean

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.DeleteSession(const aSessionID: WideString ; const IsExpired: Boolean) : Integer;

C# Syntax:

public Integer AquilaService.DeleteSession(WideString aSessionID , Boolean IsExpired);

Method ServerLog


					

Parameters:

Flag Name Type Description
In LineFrom Integer

							
In LineTo Integer

							
In ClearDown Boolean

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.ServerLog(const LineFrom: Integer ; const LineTo: Integer ; const ClearDown: Boolean) : WideString;

C# Syntax:

public WideString AquilaService.ServerLog( Int32 LineFrom , Int32 LineTo , Boolean ClearDown);

Method NHSNumberCheck


					

Parameters:

Flag Name Type Description
In NHSNumber WideString

							
In PATIENT_ID WideString

							

Return Value:

Flag Name Type
Result Result WideString

Oxygene Syntax:

method AquilaService.NHSNumberCheck(const NHSNumber: WideString ; const PATIENT_ID: WideString) : WideString;

C# Syntax:

public WideString AquilaService.NHSNumberCheck(WideString NHSNumber , WideString PATIENT_ID);

Method UpdateRulesFromJSON


					

Parameters:

Flag Name Type Description
In aRulesJson WideString

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.UpdateRulesFromJSON(const aRulesJson: WideString);

C# Syntax:

public void AquilaService.UpdateRulesFromJSON(WideString aRulesJson);

Method GetSchema


					

Parameters:

Flag Name Type Description
In aFilter Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method AquilaService.GetSchema(const aFilter: Utf8String) : Utf8String;

C# Syntax:

public Utf8String AquilaService.GetSchema(Utf8String aFilter);

Method GetData


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							
In aTableRequestInfoArray TableRequestInfoArray

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method AquilaService.GetData(const aTableNameArray: StringArray ; const aTableRequestInfoArray: TableRequestInfoArray) : Binary;

C# Syntax:

public Binary AquilaService.GetData(StringArray aTableNameArray , TableRequestInfoArray aTableRequestInfoArray);

Method UpdateData


					

Parameters:

Flag Name Type Description
In aDelta Binary

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method AquilaService.UpdateData(const aDelta: Binary) : Binary;

C# Syntax:

public Binary AquilaService.UpdateData(Binary aDelta);

Method ExecuteCommand


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aParameterArray DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.ExecuteCommand(const aCommandName: Utf8String ; const aParameterArray: DataParameterArray) : Integer;

C# Syntax:

public Integer AquilaService.ExecuteCommand(Utf8String aCommandName , DataParameterArray aParameterArray);

Method ExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aCommandName Utf8String

							
In aInputParameters DataParameterArray

							
Out aOutputParameters DataParameterArray

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.ExecuteCommandEx(const aCommandName: Utf8String ; const aInputParameters: DataParameterArray ; aOutputParameters: DataParameterArray) : Integer;

C# Syntax:

public Integer AquilaService.ExecuteCommandEx(Utf8String aCommandName , DataParameterArray aInputParameters , out DataParameterArray aOutputParameters);

Method GetTableSchema


					

Parameters:

Flag Name Type Description
In aTableNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method AquilaService.GetTableSchema(const aTableNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String AquilaService.GetTableSchema(StringArray aTableNameArray);

Method GetCommandSchema


					

Parameters:

Flag Name Type Description
In aCommandNameArray StringArray

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method AquilaService.GetCommandSchema(const aCommandNameArray: StringArray) : Utf8String;

C# Syntax:

public Utf8String AquilaService.GetCommandSchema(StringArray aCommandNameArray);

Method SQLGetData


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method AquilaService.SQLGetData(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer) : Binary;

C# Syntax:

public Binary AquilaService.SQLGetData(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords);

Method SQLGetDataEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aIncludeSchema Boolean

							
In aMaxRecords Integer

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Binary

Oxygene Syntax:

method AquilaService.SQLGetDataEx(const aSQLText: Utf8String ; const aIncludeSchema: Boolean ; const aMaxRecords: Integer ; const aDynamicWhereXML: WideString) : Binary;

C# Syntax:

public Binary AquilaService.SQLGetDataEx(Utf8String aSQLText , Boolean aIncludeSchema , Int32 aMaxRecords , WideString aDynamicWhereXML);

Method SQLExecuteCommand


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.SQLExecuteCommand(const aSQLText: Utf8String) : Integer;

C# Syntax:

public Integer AquilaService.SQLExecuteCommand(Utf8String aSQLText);

Method SQLExecuteCommandEx


					

Parameters:

Flag Name Type Description
In aSQLText Utf8String

							
In aDynamicWhereXML WideString

							

Return Value:

Flag Name Type
Result Result Integer

Oxygene Syntax:

method AquilaService.SQLExecuteCommandEx(const aSQLText: Utf8String ; const aDynamicWhereXML: WideString) : Integer;

C# Syntax:

public Integer AquilaService.SQLExecuteCommandEx(Utf8String aSQLText , WideString aDynamicWhereXML);

Method GetDatasetScripts


					

Parameters:

Flag Name Type Description
In DatasetNames Utf8String

							

Return Value:

Flag Name Type
Result Result Utf8String

Oxygene Syntax:

method AquilaService.GetDatasetScripts(const DatasetNames: Utf8String) : Utf8String;

C# Syntax:

public Utf8String AquilaService.GetDatasetScripts(Utf8String DatasetNames);

Method RegisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.RegisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void AquilaService.RegisterForDataChangeNotification(Utf8String aTableName);

Method UnregisterForDataChangeNotification


					

Parameters:

Flag Name Type Description
In aTableName Utf8String

							

Return Value:

None.

Oxygene Syntax:

method AquilaService.UnregisterForDataChangeNotification(const aTableName: Utf8String);

C# Syntax:

public void AquilaService.UnregisterForDataChangeNotification(Utf8String aTableName);

Method SimpleGetData


					

Parameters:

Flag Name Type Description
In Request SimpleRequestInfoArray

							

Return Value:

Flag Name Type
Result Result SimpleDataResultArray

Oxygene Syntax:

method AquilaService.SimpleGetData(const Request: SimpleRequestInfoArray) : SimpleDataResultArray;

C# Syntax:

public SimpleDataResultArray AquilaService.SimpleGetData(SimpleRequestInfoArray Request);

Method SimpleUpdateData


					

Parameters:

Flag Name Type Description
In aDelta SimpleDeltaArray

							

Return Value:

Flag Name Type
Result Result SimpleDeltaArray

Oxygene Syntax:

method AquilaService.SimpleUpdateData(const aDelta: SimpleDeltaArray) : SimpleDeltaArray;

C# Syntax:

public SimpleDeltaArray AquilaService.SimpleUpdateData(SimpleDeltaArray aDelta);
Event Sinks

The following table lists the Event Sinks defined in "AquilaLibrary":

Structs

The following table lists the Structs defined in "AquilaLibrary":

Person(TBaseAPIType)

						
PersonName(TBaseAPIType)

						
PostalAddress(TBaseAPIType)

						
Patient(Person)

						
TableRequestInfo

						
DataParameter

						
SimpleRequestInfo

						
SimpleDataParameter

						
SimpleDataResult

						
SimpleFieldInfo

						
SimpleDelta

						
SimpleDeltaChange

						
TFileInfo

						
TFileVersionInfo

						
LoginRequest

						
UserInfo

						
TableRequestInfoV5(TableRequestInfo)

						
ColumnSorting

						
TableRequestInfoV6(TableRequestInfo)

						
TBaseAPIType

						
SimpleDataResultEx(SimpleDataResult)

						
SimpleRequestInfoEx(SimpleRequestInfo)

						
Struct Person

The following table lists the fields defined in "Person":

Field Data Type Documentation
Name PersonName

							
Address PostalAddress

							
DateOfBirth WideString

							
Gender WideString

							
Struct PersonName

The following table lists the fields defined in "PersonName":

Field Data Type Documentation
GivenName WideString

							
FamilyName WideString

							
Struct PostalAddress

The following table lists the fields defined in "PostalAddress":

Field Data Type Documentation
POSTCODE_1 WideString

							
POSTCODE_2 WideString

							
Struct Patient

The following table lists the fields defined in "Patient":

Field Data Type Documentation
PATIENT_ID WideString

							
NHS_NUMBER WideString

							
HOSPITAL_NUMBER WideString

							
VULNERABLE_PERSON Boolean

							
Struct TableRequestInfo

The following table lists the fields defined in "TableRequestInfo":

Field Data Type Documentation
UserFilter Utf8String

							
IncludeSchema Boolean

							
MaxRecords Integer

							
Parameters DataParameterArray

							
Struct DataParameter

The following table lists the fields defined in "DataParameter":

Field Data Type Documentation
Name Utf8String

							
Value Variant

							
Struct SimpleRequestInfo

The following table lists the fields defined in "SimpleRequestInfo":

Field Data Type Documentation
SQL Utf8String

							
Table Utf8String

							
Where Utf8String

							
Parameters SimpleDataParameterArray

							
MaxRecords Integer

							
IncludeSchema Boolean

							
SimpleMode Boolean

							
Struct SimpleDataParameter

The following table lists the fields defined in "SimpleDataParameter":

Field Data Type Documentation
DataType SimpleDataType

							
Name Utf8String

							
Value Utf8String

							
Struct SimpleDataResult

The following table lists the fields defined in "SimpleDataResult":

Field Data Type Documentation
TableName Utf8String

							
FieldInfo SimpleFieldInfoArray

							
Data StringArrayArray

							
Struct SimpleFieldInfo

The following table lists the fields defined in "SimpleFieldInfo":

Field Data Type Documentation
Name Utf8String

							
DataType SimpleDataType

							
Hidden Boolean

							
Struct SimpleDelta

The following table lists the fields defined in "SimpleDelta":

Field Data Type Documentation
TableName Utf8String

							
Fields StringArray

							
Rows SimpleDeltaChangeArray

							
Struct SimpleDeltaChange

The following table lists the fields defined in "SimpleDeltaChange":

Field Data Type Documentation
OldValues StringArray

							
NewValues StringArray

							
Error Utf8String

							
Mode SimpleDataMode

							
Struct TFileInfo

The following table lists the fields defined in "TFileInfo":

Field Data Type Documentation
FileName WideString

							
Size Integer

							
TypeName WideString

							
Struct TFileVersionInfo

The following table lists the fields defined in "TFileVersionInfo":

Field Data Type Documentation
Major Integer

							
Minor Integer

							
ReleaseNum Integer

							
Build Integer

							
Struct LoginRequest

The following table lists the fields defined in "LoginRequest":

Field Data Type Documentation
username WideString

							
password WideString

							
Struct UserInfo

The following table lists the fields defined in "UserInfo":

Field Data Type Documentation
SessionID Utf8String

							
UserID Utf8String

							
Privileges StringArray

							
Attributes VariantArray

							
UserData Binary

							
Struct TableRequestInfoV5

The following table lists the fields defined in "TableRequestInfoV5":

Field Data Type Documentation
WhereClause Xml

							
DynamicSelectFieldNames StringArray

							
Sorting ColumnSorting

							
Struct ColumnSorting

The following table lists the fields defined in "ColumnSorting":

Field Data Type Documentation
FieldName Utf8String

							
SortDirection ColumnSortDirection

							
Struct TableRequestInfoV6

The following table lists the fields defined in "TableRequestInfoV6":

Field Data Type Documentation
Sql WideString

							
Struct TBaseAPIType

The following table lists the fields defined in "TBaseAPIType":

Field Data Type Documentation
echo WideString

							
Struct SimpleDataResultEx

The following table lists the fields defined in "SimpleDataResultEx":

Field Data Type Documentation
Struct SimpleRequestInfoEx

The following table lists the fields defined in "SimpleRequestInfoEx":

Field Data Type Documentation
Enums

The following table lists the Enums defined in "AquilaLibrary":

SimpleDataType

						
SimpleDataMode

						
ColumnSortDirection

						
Enum SimpleDataType

The following table lists the values defined in "SimpleDataType":

Value Documentation
String

							
Integer

							
Double

							
DateTime

							
Int64

							
Currency

							
Guid

							
Binary

							
Boolean

							
Enum SimpleDataMode

The following table lists the values defined in "SimpleDataMode":

Value Documentation
Insert

							
Delete

							
Update

							
Enum ColumnSortDirection

The following table lists the values defined in "ColumnSortDirection":

Value Documentation
Ascending

							
Descending

							
Arrays

The following table lists the Arrays defined in "AquilaLibrary":

Array Element Type Documentation
TROArray_API_Types_Patient_ Patient

						
StringArray Utf8String

						
TableRequestInfoArray TableRequestInfo

						
DataParameterArray DataParameter

						
SimpleRequestInfoArray SimpleRequestInfo

						
SimpleDataParameterArray SimpleDataParameter

						
SimpleDataResultArray SimpleDataResult

						
SimpleFieldInfoArray SimpleFieldInfo

						
StringArrayArray StringArray

						
SimpleDeltaArray SimpleDelta

						
SimpleDeltaChangeArray SimpleDeltaChange

						
TFileInfoArray TFileInfo

						
VariantArray Variant

						
Exceptions

The following table lists the Exceptions defined in "AquilaLibrary":

EROBaseHttpApiException

						
EROHttpApiRouteException(EROBaseHttpApiException)

						
EROHttpApiRequestException(EROBaseHttpApiException)

						
EROHttpApiException(EROBaseHttpApiException)

						
EROMaxSessionsExceeded

						
Exception EROBaseHttpApiException

The following table lists the fields defined in "EROBaseHttpApiException":

Field Data Type Documentation
Exception EROHttpApiRouteException

The following table lists the fields defined in "EROHttpApiRouteException":

Field Data Type Documentation
Exception EROHttpApiRequestException

The following table lists the fields defined in "EROHttpApiRequestException":

Field Data Type Documentation
Exception EROHttpApiException

The following table lists the fields defined in "EROHttpApiException":

Field Data Type Documentation
Exception EROMaxSessionsExceeded

The following table lists the fields defined in "EROMaxSessionsExceeded":

Field Data Type Documentation
Used RODL Files

The following table lists the external RODL files used by library "AquilaLibrary":