After entering the necessary data, hit Enter on your keyboard. Double-click under that newly created row and create another. Once you add all of your data, click Apply to execute the SQL Script.

This example creates the table PROCLIB.PAYLIST and inserts data into it.

List all SQLite databases To prove the database is indeed created, you can look for the todo.db file in the current folder, or simply issue the following command: sqlite> .databases main: ...

For many applications, you want users to be able to add new records. The basic Server Extensions that ship with UltraDev allow you to issue SQL INSERT statements, but only to one table. In many cases, ...