Hi! Metatranz StepSqlite Team proudly announces the release of StepSqlite 3.4a - a power-packed PL/SQL compiler for SQLite. This version adds two great new features and major improvements to error reporting and built-in package support. Join the hundreds who have discovered StepSqlite - the Easiest and Fastest way to write database interfaces for SQLite. StepSqlite alpha is available FREE (and without any sign-up) to try out right from your browser :
http://www.metatranz.com/stepsqlite New Features in version 3.4a ============================ 1. PL/SQL Exception Handling: This was the most popular feature request from a lot of our customers. We are delighted to say that All exception handling constructs of PL/SQL are now available in StepSqlite. Standard exceptions are pre-defined for you: for ex, NO_DATA_FOUND, INVALID_CURSOR etc. Error handling functions are available: SQLCODE, SQLERRM and RAISE_APPLICATION_ERROR. Also See: http://www.metatranz.com/stepsqlite/FAQ.html#q3 2. Function Overloading based on Parameter Type: Write functions with same name which differ by either number or type of parameters. For ex, to_char(i integer, f char) and to_char(d date, f char). The functions can be accessed freely from SQL as well as procedural constructs in your program. 3. Error Reporting: We have greatly improved the error messages generated for compile errors and you should get a more accurate line/column info now. 4. Built-in Packages: Several new functions have been added for effortless migration from Oracle to SQLite: 1. NVL 2. DECODE 3. ROWNUM = 1 , ROWNUM < expr , ROWNUM <= expr 4. TO_CHAR for date 5. TO_CHAR for numeric type 6. Use of 'IS NULL' in procedural constructs. It follows the Oracle semantics of empty-string = null. IF part_name is null THEN ... END IF; 7. Use of LIKE operator in procedural constructs. IF part_name like 'T!%' ESCAPE '!' THEN ... END IF; 8. Use of BETWEEN operator in procedural constructs. IF part_no between 10 and 20 THEN ... END IF; More details, benefits, tutorial and FAQ at: http://www.metatranz.com/stepsqlite Send inquiries to: info @ metatranz.com Send feedback to: feedback @ metatranz.com About Metatranz: ------------------------ Metatranz LLC is committed to bringing the power and convenience of big-database tools to the small-database world by using innovative techniques and latest technology while preserving the small, fast and reliable. * Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Metatranz LLC is Not associated with, endorsed by, or sponsored by the Oracle Corp. Sincerely Yours, The Metatranz StepSqlite Team http://www.metatranz.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users