The FairCom RTG products allow your Btrieve data to be exposed through SQL, giving you full access to read, write, insert, and delete records. This support is targeted at the most important SQL functionality, which includes:
Reading and writing records using SQL queries
User-defined functions
Stored procedures
Triggers
Views
Joins (including joining a SQL-created table with an ISAM table).
The topics listed in Common Issues are important to remember when developing FairCom RTG applications that use both ISAM and SQL to access the same data files. In addition, keep the following in mind:
A table created through SQL cannot be accessed using FairCom RTG ISAM drivers for Btrieve.
SQL triggers are applicable at the SQL level only; your Btrieve program cannot invoke a SQL trigger.
Referential integrity is applicable at the SQL level only; no check is performed to ensure referential integrity.
If transactions are disabled on Btrieve files, this creates additional considerations to accessing these files at the SQL level: rollbacks do not affect these files; isolation of transaction is not provided; etc.
Developing Stored Procedures
FairCom highly recommends the use of our NetBeans plug-in (found in the sql.stored.procs folder), which significantly simplifies the development, debugging, and deployment of stored procedures.
