Product Documentation

c-treeACE V10.3 Update Guide

Previous Topic

Next Topic

Built-in procedure now returns full version information

The built-in stored procedure fc_get_server_version did not return the "mini" part of the version number as a separate field. The "version" and "build_date" fields of the resultset were not large enough to contain the full string resulting in error -20052 (overflow error) when executing the stored procedure.

The stored procedure has been updated as follows:

  • "version" expanded from 32 to 40 chars
  • "build_date" expanded from 8 to 14 char
  • "ver_mini" added as last column in resultset - This is a new integer value containing the mini revision number (third revision number component). It is the last column (instead of between the "ver_minor" and "ver_revision") so as maintain backward compatibility with existing code that may assume the column positions.

The output of the stored procedure when launched from ISQL is as follows:


VERSION VER_MAJOR VER_MINOR VER_REVISION BUILD_DATE VER_MINI

------- --------- --------- ------------ ---------- --------

10.0.1.60592(Build-121010) 10 0 60592 121010 1

TOCIndex