Appendix

Appendix

This appendix presents additional important D3 ODBC and D3 SQL information.

  1. ODBC conformance
    These ODBC functions are supported on D3 7.5.
  2. SQL language conformance
    Supported and unsupported SQL grammar is listed in this topic.
  3. D3 SQL reserved words
    These words are reserved for use in SQL and ODBC function calls. They should not be used for account names. If these words are found in file names or attribute-defining item names, the name will be prefixed with RSV_ in the resulting SQL table.
  4. Scalar functions
    D3 ODBC supports three types of scalar functions: String, Numeric, and Date/Time.
  5. Calling FlashBASIC subroutines from ODBC clients (UNIX)
    This appendix presents the methods for calling FlashBASIC subroutines from an ODBC client on UNIX only.
  6. D3 SQL catalog
    The D3 SQL Catalog is the Tables file located in the SQL account.
  7. Using SQL syntax to retrieve D3 environment information
    SQL users may need to reference environmental information about the system.
  8. D3 error constants
    The error code returned from the Err object’s Number property is a large negative number. These codes are returned as a result of a run-time error from one of the class library’s methods or properties. Below is a list of D3 Error Constants and their corresponding error codes.
  9. Known limitations
    These known limitations exist.