SQL Features
The power and memory space needed for a full-blown SQL parser are simply not available on most small devices, so not all statements that you might be accustomed to using on your desktop machine are available on an embedded device. This might change in the near future when the devices get faster. The following SQL statements can be used in UltraLite applications:
Data Manipulation Language— SELECT, INSERT, UPDATE, and DELETE statements can be included. You can use placeholders in these statements that are filled in at runtime.
TRUNCATE TABLE statement— You can use this statement to rapidly delete entire tables.
Transaction control— You can use COMMIT and ROLLBACK statements to provide transaction control within your UltraLite application. ...
Get PowerBuilder® 9: Internet and Distributed Application Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
