You can use the Interactive SQL (ISQL) view to create stored procedures or triggers, but make sure that the painter's SQL statement terminator character is not the same as the terminator character used in the stored procedure language of your DBMS. Stored procedures are not supported in UltraLite databases.
By default, PocketBuilder uses the semicolon as the SQL statement terminator. You can override the semicolon by specifying a different terminator character in the Database painter. To change the terminator character, select Design>Options from the Database painter’s menu bar.
Make sure that the character you choose is not reserved for another use by your database vendor. For example, using the slash character (/) will cause compilation errors with some DBMSs.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
