DSQL Limitations (Application Requirements)
Go Up to Application Requirements
DSQL enables programmers to create flexible applications that are capable of handling a wide variety of user requests. Even so, not every SQL statement can be handled in a completely dynamic fashion. For example, database handles and transaction names must be specified when an application is written, and cannot be changed or specified by users at run time. Similarly, while InterBase supports multiple databases and multiple simultaneous transactions in an application, the following limitations apply:
- Only a single database can be accessed at a time.
- Transactions can only operate on the currently active database.
- Users cannot specify transaction names in DSQL statements; instead, transaction names must be supplied and manipulated when an application is coded.