D3 system information can be obtained directly using this subroutine which is located in the sql,bpnf, file.
This subroutine is equivalent to the FlashBASIC system statement.
subroutine sql_system(value)
The syntax has this parameter:
| Parameter | In/Out | Description |
|---|---|---|
| value | out | On input, this variable should contain an integer index indicating the system function to return. On output, this variable contains the system information. |
Below are some system parameters from ODBC. For a full list of parameters, see the D3 Reference Manual.
| Parameter | Description |
|---|---|
| 12 | Returns the server system time in milliseconds. |
| 18 | Returns the number of ports (potential connections) on the system. |
| 19 | Returns a unique alphanumeric string. This is for obtaining unique primary keys. |
| 21 | Returns today’s date as the number of days since December 31, 1967. |
| 22 | Returns the current port (connection) number. |