firebird 40 language referenceenables explicit conversion between many pairs of data types. Syntax CAST (AS <target_type>) <target_type> ::= | ::= than OCTETS, it is your responsibility to supply the bytes in a sequence that is valid for the target character set. Alternative String Literals Since Firebird 3.0, it is possible to use a character in the master table. These referenced columns are often called target columns. They must be the primary key or a unique key in the target table. They need not have a NOT NULL constraint defined on them 0 码力 | 778 页 | 3.43 MB | 1 年前3
Firebird 2.5 Language Referencethan OCTETS, it is your responsibility to supply the bytes in a sequence that is valid for the target character set. Introducer Syntax for String Literals If necessary, a string literal may be preceded in the master table. These referenced columns are often called target columns. They must be the primary key or a unique key in the target table. They need not have a NOT NULL constraint defined on them table may differ from those in the Foreign Key. If no target columns are specified, the Foreign Key automatically references the target table’s Primary Key. Foreign Key Actions With the sub-clauses0 码力 | 521 页 | 2.30 MB | 1 年前3
firebird language reference 30 rusНазначение: Вставка данных в таблицу. Доступно в: DSQL, ESQL, PSQL. Синтаксис: INSERT INTO target {DEFAULT VALUES | [()] } [RETURNING [INTO ]] [, [:]varname ...] Таблица 5.13. Параметры оператора INSERT Параметр Описание target Имя таблицы или представления, в которую происходит вставка новой записи или записей. colname Столбец Обновление данных в таблице. Доступно в: DSQL, ESQL, PSQL. Операторы DML 306 Синтаксис: UPDATE target [[AS] alias] SET col = newval [, col = newval ...] [WHERE {search-conditions | CURRENT OF cursorname}] 0 码力 | 719 页 | 3.98 MB | 1 年前3
firebird 30 sprachreferenzexplizite Konvertierung zwischen vielen Paaren von Datentypen. Syntax CAST (AS <target_type>) <target_type> ::= | ::= referenzierten Spalte(n) der Mastertabelle vorhanden sind. Diese referenzierten Spalten werden oft als target column bezeichnet. Sie müssen der Primärschlüssel oder ein eindeutiger Schlüssel in der Zieltabelle für Einfügen von Datenzeilen in eine Tabelle Verfügbar in DSQL, ESQL, PSQL Syntax INSERT INTO target {DEFAULT VALUES | [( )] } [RETURNING [INTO ]] 0 码力 | 701 页 | 3.12 MB | 1 年前3
Firebird 2.0 ErrorCodes335544860 blob_convert_error Unsupported conversion to target type BLOB (subtype %d) -413 335544861 array_convert_error Unsupported conversion to target type ARRAY -501 335544327 bad_req_handle Invalid request Violation of FOREIGN KEY constraint "%s" on table "%s" -530 335544838 foreign_key_target_doesnt_exist Foreign key reference target does not exist -530 335544839 foreign_key_references_present Foreign key references invalid_savepoint Unable to find savepoint with name %s in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "%s" Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT0 码力 | 26 页 | 157.59 KB | 1 年前3
Firebird 2.1 ErrorCodes335544860 blob_convert_error Unsupported conversion to target type BLOB (subtype @1) -413 335544861 array_convert_error Unsupported conversion to target type ARRAY -501 335544577 dsql_cursor_close_err Attempt Violation of FOREIGN KEY constraint "@1" on table "@2" -530 335544838 foreign_key_target_doesnt_exist Foreign key reference target does not exist -530 335544839 foreign_key_references_present Foreign key references invalid_savepoint Unable to find savepoint with name @1 in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "@1" -901 335544840 no_update Cannot update -901 3355448420 码力 | 31 页 | 103.24 KB | 1 年前3
Firebird Docwriting Guide GermanAttribut linkend muss immer vorhanden sein; sein Wert sollte die id des zu verlinkenden Elements ( link target) sein. Click here to jump to the introduction 2_01-b06) Java HotSpot(TM) Client VM (build 1.4.2_01-b06, mixed mode) Buildfile: build.xml BUILD FAILED Target `ugh' does not exist in this project. Firebird Docwriting-Anleitung 24 Und so sieht 2_01-b06) Java HotSpot(TM) Client VM (build 1.4.2_01-b06, mixed mode) Buildfile: build.xml BUILD FAILED Target `ugh' does not exist in this project. literallayout (wörtliches Layout) literallayout, wie screen0 码力 | 49 页 | 228.41 KB | 1 年前3
Firebird Null Guide: NULL behaviour and pitfalls in Firebird SQLtry to create a foreign key referencing a target that is neither a primary nor a unique key, Firebird complains that no unique index can been found on the target — even if such an index does exist. In unique or primary key could be found. Even if NULLs are absolutely forbidden in the target key (for instance if the target is a PK), the foreign key column may still contain NULLs, unless this is prevented0 码力 | 69 页 | 479.63 KB | 1 年前3
firebird gfixapplication design, then it is possible that there will be a build up of enough back versions to fill the target page. When the chain of old versions gets too big, Firebird has to move the old versions to a different linux> gfix -shut -force 5 my_employee linux> echo $? 0 linux> gfix -shut -force 5 my_employee Target shutdown mode is invalid for database - "/home/norman/firebird/my_employee.fdb" linux> echo $? 00 码力 | 44 页 | 247.13 KB | 1 年前3
Firebird Docwriting Guide Brazilian Portuguese2_01-b06) Java HotSpot(TM) Client VM (build 1.4.2_01-b06, mixed mode) Buildfile: build.xml BUILD FAILED Target `ugh' does not exist in this project. E aqui como isso é renderizado: D:\Firebird\ma 2_01-b06) Java HotSpot(TM) Client VM (build 1.4.2_01-b06, mixed mode) Buildfile: build.xml BUILD FAILED Target `ugh' does not exist in this project. literallayout literallayout, assim como screen e programlisting0 码力 | 36 页 | 161.44 KB | 1 年前3
共 13 条
- 1
- 2













