Translations:Kexi/Tutorials/Importing SQLite database into Kexi/15/en: Difference between revisions

Latest revision as of 07:10, 3 June 2017

Information about message (contribute)

This message has no documentation. If you know where or how this message is used, you can help other translators by adding documentation to this message.

Message definition (Kexi/Tutorials/Importing SQLite database into Kexi)

*Type a name for every column presented by the schema in the step 3.
*Use the Property Editor on the right hand to give each column in this table proper data type.
**For INTEGER types, eg. ''dateTime INTEGER'' as seen on the schema, select Integer Number in the Data Type column of the Table Designer.
**For REAL types, eg. ''barometer REAL'' as seen on the schema, select Floating Point Number in the Data Type column of the Table Designer.
*In addition, set the ''dateTime'' column as the primary key for the table in the Property Editor.
*Also, ''usUnits'' and ''interval'' columns have NOT NULL specifier assigned. To do the same in Kexi, set Required property to Yes for these columns in the Property Editor.

Type a name for every column presented by the schema in the step 3.
Use the Property Editor on the right hand to give each column in this table proper data type.
- For INTEGER types, eg. dateTime INTEGER as seen on the schema, select Integer Number in the Data Type column of the Table Designer.
- For REAL types, eg. barometer REAL as seen on the schema, select Floating Point Number in the Data Type column of the Table Designer.
In addition, set the dateTime column as the primary key for the table in the Property Editor.
Also, usUnits and interval columns have NOT NULL specifier assigned. To do the same in Kexi, set Required property to Yes for these columns in the Property Editor.