FASTDB Study Notes

FASTDB Study Notes

These days have been learning the use of FASTDB, will be some of the learning experience and notes written for everyone to reference!

The

1,register_in () macro cannot be used in the main function;
2, UPDATE and delete the cursor is updatecurrsor, the other is the general currsor;
3, the current value of the cursor is the object of the current query.
4, the Client server infrastructure program needs to use the CLI interface, the program contains Cli.lib
5, if the use of fastdb.lib in Cbuilder, the link appears in the OMF format problem, directly all the SRC directory files ( There are several CPP from the name can be found on other platforms or can not be used to add to a Cbuilder Lib project inside, and then build fastdb.lib can solve the problem. This problem may also occur when using the CLI, as in the above, Add Cli.cpp,cgistub.cpp,repsock.cpp,stdtp.cpp,w32sock.cpp to a Lib project and generate cli.lib to solve the problem.
6, sharing classes between different databases, first defining class, registering classes with register_unassigned (), using cursors with a pointer to the database you want to manipulate as parameters. This identifies the database that you are manipulating. If you want to insert data, The insert () function is used by a member of the database class. This identifies the databases to be inserted. The
7,fastdb class (that is, the data members of the table must be public), otherwise the external is inaccessible. The fields of the
8,fastdb table can be nested structures or dynamically growing array types. And you can have methods in the table. The
9,fastdb supports AutoIncrement fields, and INT4 types can be declared as AutoIncrement in descriptor.
10, you can export the in-memory database to an XML file using the Export command of the SUBSQL program with FASTDB. The inverse reference of the
11,fastdb guarantees the referential integrity of the data when you delete records in the database. Inverse reference automatically updates when you delete records in the database. The
12,fastdb1.20 supports Cascade deletes later, as long as the corresponding field is declared owner. If the field containing the reference is the owner then the fields are declared with the relation macro.