Kexi/Handbook

From KDE Wiki Sandbox
Revision as of 22:48, 8 August 2011 by Diggy (talk | contribs) (Initial page update)

← Back

Under Construction
This is a new page, currently under construction!
Information
This handbook for Kexi 2.x is meant to be based on the Kexi Handbook for Kexi 1.1.
Please coordinate any effort with Jarosław Staniek, email: kexi at kde.org


Warning
Links of this handbook are broken because this wiki lacks subpage feature for the Main namespace. There's a plan to fix it. For example "/Kexi Basics/Kexi Databases" should be the same as "Kexi/Handbook/Kexi Basics/Kexi Databases"

Introduction

Kexi Basics

Kexi Databases
Creating a New Database File
The Kexi Main Window
Main application elements
Opening an existing Kexi database file
Opening a database file in the Open Existing Project dialog
Opening an existing Kexi database file by clicking on .kexi file's icon
Using built-in help

Building Simple Databases

Introduction
Designing Database Tables
The Table Designer window
Entering Data Into Tables
Designing Database Queries
Designing Forms
Most important terms
Forms versus tables
Working with form design
Using the Widgets tab
Inserting widgets - text fields
Assigning data sources
Inserting text labels
Actions
Widget layouts
Setting widgets size and position by hand
Setting the tab order
Entering Data Using Forms

Configuring Kexi

Docking and Undocking Windows
Docking and undocking side panels

Command Reference

The Kexi Tab
The Project Tab
The Create Tab
The Data Tab
The External Data Tab
The Tools Tab
The Form Design Tab
The Report Design Tab

Credits and License

Appendix A. Introduction to Databases

What Is a Database?
Database and Spreadsheet
How Is a Database Different From a Spreadsheet?
Database Design
Who Needs a Database?
Database Creation Software

Appendix B. Comparing Kexi to other database applications

Data types

Appendix C. Reserved words for SQL

The following lists contain words that are used internaly by Kexi when dealing with data sources. When designing your database you should do your best to avoid using these reserved words because otherwise you might end up having problems with your database file or even corrupt it.

Kexi SQL Reserved words

This list contains keywords that are resevered for use in Kexi SQL:

  • AFTER
  • ALL
  • ASC
  • BEFORE
  • BEGIN
  • BETWEEN
  • BY
  • CASCADE
  • CASE
  • CHECK
  • COLLATE
  • COMMIT
  • CONSTRAINT
  • CROSS
  • DATABASE
  • DEFAULT
  • DELETE
  • DESC
  • DISTINCT
  • DROP
  • END
  • ELSE
  • EXPLAIN
  • FOR
  • FOREIGN
  • FULL
  • GROUP
  • HAVING
  • IGNORE
  • INDEX
  • INNER
  • INSERT
  • INTO
  • KEY
  • LIMIT
  • MATCH
  • NATURAL
  • OFFSET
  • ORDER
  • OUTER
  • PRIMARY
  • REFERENCES
  • REPLACE
  • RESTRICT
  • ROLLBACK
  • ROW
  • SET
  • TEMPORARY
  • THEN
  • TRANSACTION
  • UNION
  • UNIQUE
  • UPDATE
  • USING
  • VALUES
  • WHEN

Kexi SQLite Driver Reserved words

This list contains keywords that are resevered for use by Kexi SQLite Driver:

  • ABORT
  • ATTACH
  • CLUSTER
  • CONFLICT
  • DEFERRED
  • DEFERRABLE
  • DETACH
  • EACH
  • EXCEPT
  • FAIL
  • GLOB
  • IMMEDIATE
  • INITIALLY
  • INSTEAD
  • INTERSECT
  • ISNULL
  • NOTNULL
  • OF
  • PRAGMA
  • RAISE
  • STATEMENT
  • TEMP
  • TRIGGER
  • VACUUM
  • VIEW

Tools