Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our news
Partners

SQLite Code Factory online Help

Prev Return to chapter overview Next

Data View

SQLite Code Factory represents data as a grid or as info cards. By default, data is displayed in grids. To change the type of the data representation, use drop-down list at the top of the tab. Both of the data representations supports UNICODE/UTF-8 data. The status bar displays the number of records in the current data set.

 

Note: For databases in UTF-8 encoding it is necessary to specify, which string fields are used to store Unicode data (available options are "Only nvarchar(xx) fields" and "All the string fields"). For databases in UTF-16 encoding no such actions required.

 

To add a new (edit an existing) record, use Data Input Form or type the new field values directly in the grid (card). To export/import data from/to one of available formats, reach Data Export and Data Import modules using corresponding links at the Navigation bar. You can also get SQL dump of the current data set and print current data with enabled preview in WYSIWYG mode.

 

 

See also: SQL Editor, Visual Query Builder



Prev Return to chapter overview Next