ODBC

MÀÀrab ODBC andmebaaside sÀtted, sh juurdepÀÀsuandmed, draiveri sÀtted ja fondikirjeldused.

Kasutajanimi

Sisesta andmebaasi kasutamiseks kasutajanimi.

Parool on nÔutav

TĂ”kestab autoriseerimata kasutaja ligipÀÀsu andmebaasile. Parool on vaja sisestada vaid ĂŒks kord seansi jooksul.

Draiveri sÀtted

Kasuta seda tekstivÀlja vajadusel draiveri lisaparameetrite sisestamiseks.

MĂ€rgistik

Select the code conversion that you want to use to view the database in LibreOffice. This does not affect the database. Choose "System" to use the default character set of your operating system. Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes.

Üldine

Genereeritud vÀÀrtuste hankimine

Enables LibreOffice support of auto-incremented data fields for the current ODBC or JDBC data source. Select this check box if the database does not support the auto-increment feature in its SDBCX layer. In general, the auto-increment is selected for the primary key field.

Automaatselt kasvamise lause

Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field. For example, a typical SQL statement to create a data field is:

CREATE TABLE "tabel1" ("id" INTEGER)

Selleks, et MySQL andmebaasis "id" andmevÀlja automaatselt suurendada, muuda lause jÀrgnevaks:

CREATE TABLE "tabel1" ("id" INTEGER AUTO_INCREMENT)

In other words, enter AUTO_INCREMENT into Auto-increment statement box.

Genereeritud vÀÀrtuste pÀring

Enter an SQL statement that returns the last auto-incremented value for the primary key data field. For example:

SELECT LAST_INSERT_D();

Kasutatakse SQL92 nimepiiranguid

Only allows names that use characters that conform to the SQL92 naming constraints in the data source. All other characters are rejected. Each name must begin with a lower or upper case letter, or an underline ( _ ). The remaining characters can be ASCII letters, underlines, and numbers.

Kataloogi kasutamine failipÔhiste andmebaaside jaoks

Uses the current data source of the Catalog. This is useful when the ODBC data source is a database server. If the ODBC data source is a dBASE driver, leave this check box clear.

Palun toeta meid!