Number: TB0034

Availability: As of BuildPro 8.00, licensed users.

Introduction

The BuildPro 8.00 release provides an interface to the Microsoft SQL Server relational database. Contact support@todaysystems.com to obtain licenses.

Current Limitations

The open release contains the following limitation that will be addressed in future release:

The unique identifier (BP_ROWID) must be the last column of each table.

Implementation of BP_ROWID

Under MODE *WRITE, BuildPro requires a unique identifier in every table (as does any database performing multi-table joins). The concern is that SQL Server does not surface a row id or unique identifier by default. In order to work around this issue BuildPro will automatically add a new column to any table built from within BuildPro. The extra column (bp_rowid) is not defined in the table definition nor is it available as part of the file buffer values. Use *RECNO to interrogate the value of "bp_rowid".

The "bp_rowid" column is defined in SQL Server as a auto-increment field and as the table's unique identifier. This column is added by fbuild automatically when building or reformatting the table. For tables created outside of BuildPro, you will need to add this column manually.

Under MODE *READ, the unique identifier is not required.

This provides the minimum effect on existing BuildPro applications.