SQLite

ScreenShots

Manage

Analyse

Export

Import

Generate RB code

Download

Setup

 

Features

  • dialogs for creation, deletion of tables, indexes
  • ability to rename, reindex tables
  • ability to add and drop columns
  • create new database
  • open any existing database
  • export tables as csv or sql
  • import tables from csv or sql files
  • a menu showing all db's
  • ability to see the master tables
  • ability to see the temporary tables and indexes
  • ability to browse data from on any table
  • ability to sort browsed data on any column
  • allows editing and deleting selected record while browsing a table's data
  • allows adding, saving and changing blob data
  • remembers the last used db and table

Manage

Tables Add and Delete Tables to the Database
Feilds Add Change and Delete fields to a table. Define type such as interger and the size.
Index Add and Change indexes to the table
Query Using the Query button you can enter any valid SQL command. You can update, change, or select from tables. You can add indexes, fields, delete fielsd. Basically any valid SQL command is accepted.

Analyze

Using the Cross reference, you can find out file relationships. It tells you how tables are related to each other

Export

Export the Schema or Data in standard SQL format.
Export Data in CAV format ready for Spread Sheets

Import

Usinq the [Query] button you can enter or past in SQL commands.
Import the Schema or Data in standard SQL format.
Import Data in CAV format ready for Spread Sheets

Generate RB code

Usinq the [Query] button you can enter or past in SELECT statements. Any valid sql command including sub-selects, Inner and Outer joins.
After you execute the code, it gives you the option to generate the RB code for that query.

Setup

After you download the SQLite.zip file, You need to create a Run Basic project called sqlite. Unzip the SQLite.zip file into the run basic project. Then run the project