The global parameter list contains the global parameters of the SqlRemoteAccess library. They can be overwritten specifically for your project in the Library Manager.
The global parameters of the SqlRemoteAccess library allow you to define the size of the following ALIAS for data buffers:
oUserData that must be available in the controller for storing the SQL data read from the SQL database.
oRequestData that must be available in the controller in order to segment the SQL requests into separate strings of a maximum of 200 characters before they are sent to the SQL database.
|
Variable |
Data type |
Value range |
Description |
|---|---|---|---|
|
Gc_uiIpStringSize |
UINT |
– |
Upper limit of the WSTRING for the element wsGwIpaddress in the ST_ConnectionSettings structure. Default value: 15 |
|
Gc_uiMaxRows |
UINT |
1...50 |
Maximum number of rows for the ARRAY of user data. Default value: 20 |
|
Gc_uiMaxColumns |
UINT |
1...50 |
Maximum number of columns for the ARRAY of user data. Default value: 10 |
|
Gc_uiTableWstringLength |
UINT |
20...200 |
Length of the WSTRING in the ARRAY of user data. Default value: 200 |
|
Gc_uiRequestWstringLength |
UINT |
20...200 |
Length of the WSTRING in the ARRAY of request data. Configure a value that corresponds to the length of the SQL requests that you use in your application Default value: 200 |
|
Gc_uiMaxRequest |
UINT |
1...40 |
Upper limit of the ARRAY of request data. Configure a value that corresponds to the length of the SQL requests that you use in your application Default value: 20 |
|
Gc_uiRecBufferLength |
UINT |
512...2000 |
Length of the response buffer in bytes. Default value: 1000 |
|
Gc_uiSendBufferLength |
UINT |
512...2000 |
Length of the send buffer in bytes. Default value: 1000 |
NOTE: The variables Gc_uiRecBufferLength and Gc_uiSendBufferLength define the size of the internal buffers for sending and receiving data. The sizes of these buffers determine the number of cycles that are required to transfer a complete request or response between the controller and the SQL Gateway. Those values you chose may have an impact on the execution time of SQL services and memory, and thus on the overall performance of your application.
