O'Reilly logo

PowerBuilder® 9: Internet and Distributed Application Development by John D. Olson, Bill Green

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required