kvmskate.blogg.se - Firebird constraint limit

This limitation applies to both downgrade and upgrade of Interbase / Firebird version. Importing recovered results into database of different Interbase / Firebird version may result in loosing data or database objects. It is strongly recommended to use recovery results with the same Interbase / Firebird version as one the corrupted file has been created with. Easy to use, no special user skills required.Improved support for big databases (over 2Gb).Recovers indexes, foreign keys, domains, user-defined fields.

Recovers stored procedures, views, check constraints.

Processes damaged database and saves recovered data into SQL scripts.

Arrays support for all modern versions of InterBase and Firebird.

Returns true if the backend supports "deferrable initiallyĭeferred" foreign key constraints. Returns the true if the database require subquery alias. Returns true if the database supports Update Cascade. Returns the infix for an 'autoincrement' insert statement. SetProperty (const std::string &name, const std::string &value)ĪutoincrementInsertInfix (const std::string & id) const SaveStatement (const std::string & id, SqlStatement *statement) Public Member Functions inherited from Wt::Dbo::SqlConnectionĮxecuteSqlStateful (const std::string &sql)Įxecutes a connection-stateful SQL statement. Returns whether the SQL dialect uses 'ROWS ? TO ?', limit or rownum for partial select results. Returns true if the backend support Alter Table. More.ĭateTimeType ( SqlDateTimeType type) const Returns the suffix for an 'autoincrement' insert statement. More.ĪutoincrementInsertSuffix (const std::string & id) const Returns the SQL statement(s) required to drop an id sequence.

More.ĪutoincrementDropSequenceSql (const std::string &table, const std::string & id) const

Returns the SQL statement(s) required to create an id sequence. More.ĪutoincrementCreateSequenceSql (const std::string &table, const std::string & id) const Returns the 'autoincrement' SQL type modifier. PrepareStatement (const std::string &sql)Įxecute code before dropping the tables. Returns the underlying connection handle. More.įirebird (const std::string &ServerName, const std::string &DatabaseName, const std::string &UserName, const std::string &UserPassword, const std::string &RoleName, const std::string &CharSet=std::string(), const std::string &CreateParams=std::string())Ĭreates and opens a Firebird backend connection.Ĭonnect (const std::string &ServerName, const std::string &DatabaseName, const std::string &UserName, const std::string &UserPassword, const std::string &RoleName, const std::string &CharSet=std::string(), const std::string &CreateParams=std::string())