|
FullRecord is a set of templates that are installed in your Clarion development environment with the aid of an installation program. Run the installation program and accept the defaults offered by it. The installation program offers you the option to register the FullRecord template in Clarion, but if you choose not to make use of this functionality, you have to start Clarion and manually register the FullRecord.TPL template (for ABC) and FullRecordLgcy.TPL (for Legacy). You will find these template files in the 3rdparty\template folder inside your Clarion's 6.x folder, or the Accessory\Template\Win folder for your Clarion's 7.x installation.
All our examples applications are installed in the examples\FullRecord2 folder, but the folder may be in different places according to your OS. Pay attention to the installer, it will propose a default folder - take note of where it is, and change it at that time if you don't like the default location.
List of Example Applications
All the examples for Clarion 7.x also work with Clarion 8.x.
All the examples for Clarion 6.x also work with Clarion 7.x or Clarion 8.x.
Folder: FullRecord\
Example
|
Clarion version
|
File driver
|
Comments
|
Fra6.app , fra6.dct
|
C6.3 – ABC
|
TPS
|
With BLOB fields and MEMO fields.
|
FRAIM6.app , fraIM6.dct
|
C6.3 – ABC
|
TPS
|
With BLOB fields , MEMO fields and InMemory tables.
|
frdata6.app , frinspect6.app , frmod6.app , frexe6.app , fra6.dct
|
C6.3 – ABC
|
TPS
|
Multi .DLL , with BLOB fields and MEMO fields.
|
frl6.app , frl6.dct
|
C6.3 – Legacy
|
TPS
|
With BLOB fields and MEMO fields.
|
frldata6.app , frlinspect6.app , frlmod6.app , frlexe6.app , frl6.dct
|
C6.3 – Legacy
|
TPS
|
With BLOB fields and MEMO fields.
|
rsa6.app , fra6.dct
|
C6.3 – ABC
|
TPS
|
With BLOB fields and MEMO fields. + NeatMessage template
|
Fra7.app , fra7.dct
|
C7.3 – ABC
|
TPS
|
With BLOB fields and MEMO fields.
|
FRAIM7 , fraIM7.dct
|
C7.3 – ABC
|
TPS
|
With BLOB fields , MEMO fields and InMemory tables.
|
frdata7.app , frinspect7.app , frmod7.app , frexe7.app , fra7.dct
|
C7.3 – ABC
|
TPS
|
Multi .DLL , with BLOB fields and MEMO fields.
|
frl7.app , frl7.dct
|
C7.3 – Legacy
|
TPS
|
With BLOB fields and MEMO fields.
|
frldata7.app , frlinspect7.app , frlmod7.app , frlexe7.app , frl7.dct
|
C7.3 – Legacy
|
TPS
|
With BLOB fields and MEMO fields.
|
rsa7.app , fra7.dct
|
C7.3 – ABC
|
TPS
|
With BLOB fields and MEMO fields. + NeatMessage template
|
Folder: FullRecord\MSSQL\
Example
|
Clarion version
|
File driver
|
Comments
|
FR6ABSQL.app , FR6SqlB.dct
|
C6.3 – ABC
|
MSSQL
|
With BLOB field.
|
FR6LBSQL.app , FR6SqlB.dct
|
C6.3 – Legacy
|
MSSQL
|
With BLOB fields.
|
FR6LSQL.app , FR6Sql.dct
|
C6.3 – Legacy
|
MSSQL
|
Without BLOB fields.
|
FR6SQL.app , FR6Sql.dct
|
C6.3 – ABC
|
MSSQL
|
Without BLOB fields.
|
FR7ABSQL.app , FR7SqlB.dct
|
C7.3 – ABC
|
MSSQL
|
With BLOB fields.
|
FR7LBSQL.app , FR7SqlB.dct
|
C7.3 – Legacy
|
MSSQL
|
With BLOB fields.
|
FR7LSQL.app , FR7Sql.dct
|
C7.3 – Legacy
|
MSSQL
|
Without BLOB fields.
|
FR7SQL.app , FR7Sql.dct
|
C7.3 – ABC
|
MSSQL
|
Without BLOB fields.
|
Folder: FullRecord\ ODBC-FIREBIRD\DSN-Less\
Example
|
Clarion version
|
File driver
|
Comments
|
FRFBA6.app , FR6.dct
|
C6.3 – ABC
|
ODBC / FireBird
|
Without BLOB fields.
|
FRFBA7.app , FR7.dct
|
C7.3 – ABC
|
ODBC / FireBird
|
Without BLOB fields.
|
Folder: FullRecord\ ODBC-FIREBIRD\SQL-BLOB\
Example
|
Clarion version
|
File driver
|
Comments
|
FR6ABSQL.app , FR6SqlB.dct
|
C6.3 – ABC
|
ODBC / FireBird
|
With BLOB fields.
|
FR6LBSQL.app , FR6SqlB.dct
|
C6.3 – Legacy
|
ODBC / FireBird
|
With BLOB fields.
|
FR7ABSQL.app , FR7SqlB.dct
|
C7.3 – ABC
|
ODBC / FireBird
|
With BLOB fields.
|
FR7LBSQL.app , FR7SqlB.dct
|
C7.3 – Legacy
|
ODBC / FireBird
|
With BLOB fields.
|
Folder: FullRecord\ ODBC-FIREBIRD\ SQL-WithOutBLOB\
Example
|
Clarion version
|
File driver
|
Comments
|
FR6LSQL.app , FR6SQL.dct
|
C6.3 – Legacy
|
ODBC / FireBird
|
Without BLOB fields.
|
FR6SQL.app , FR6SQL.dct
|
C6.3 – ABC
|
ODBC / FireBird
|
Without BLOB fields.
|
FR7LSQL.app , FR7SQL.dct
|
C7.3 – Legacy
|
ODBC / FireBird
|
Without BLOB fields.
|
FR7SQL.app , FR7SQL.dct
|
C7.3 – ABC
|
ODBC / FireBird
|
Without BLOB fields.
|
Folder: FullRecord\ ODBC-GUID\
Example
|
Clarion version
|
File driver
|
Comments
|
FRPGA6GUID.app , FR6GUID.dct
|
C6.3 – ABC
|
ODBC / PostgreSQL
|
Without BLOB fields. Use GUID method for autonumbering in Audit files .
|
FRPGL6GUID.app , FR6GUID.dct
|
C6.3 – Legacy
|
ODBC / PostgreSQL
|
Without BLOB fields. Use GUID method for autonumbering in Audit files .
|
FRPGA7GUID.app , FR7GUID.dct
|
C7.3 – ABC
|
ODBC / PostgreSQL
|
Without BLOB fields. Use GUID method for autonumbering in Audit files .
|
FRPGL7GUID.app , FR7GUID.dct
|
C7.3 – Legacy
|
ODBC / PostgreSQL
|
Without BLOB fields. Use GUID method for autonumbering in Audit files .
|
Folder: FullRecord\ ODBC-PgSQL\DSN-Less\
Example
|
Clarion version
|
File driver
|
Comments
|
FRPBA6.app , FR6.dct
|
C6.3 – ABC
|
ODBC / PostgreSQL
|
Without BLOB fields.
|
FRPBA7.app , FR7.dct
|
C7.3 – ABC
|
ODBC / PostgreSQL
|
Without BLOB fields.
|
Folder: FullRecord\ ODBC-PgSQL\SQL-BLOB\
Example
|
Clarion version
|
File driver
|
Comments
|
FR6ABSQL.app , FR6SqlB.dct
|
C6.3 – ABC
|
ODBC / PostgreSQL
|
With BLOB fields.
|
FR6LBSQL.app , FR6SqlB.dct
|
C6.3 – Legacy
|
ODBC / PostgreSQL
|
With BLOB fields.
|
FR7ABSQL.app , FR7SqlB.dct
|
C7.3 – ABC
|
ODBC / PostgreSQL
|
With BLOB fields.
|
FR7LBSQL.app , FR7SqlB.dct
|
C7.3 – Legacy
|
ODBC / PostgreSQL
|
With BLOB fields.
|
Folder: FullRecord\ ODBC-PgSQL\ SQL-WithOutBLOB\
Example
|
Clarion version
|
File driver
|
Comments
|
FR6LSQL.app , FR6SQL.dct
|
C6.3 – Legacy
|
ODBC / PostgreSQL
|
Without BLOB fields.
|
FR6SQL.app , FR6SQL.dct
|
C6.3 – ABC
|
ODBC / PostgreSQL
|
Without BLOB fields.
|
FR7LSQL.app , FR7SQL.dct
|
C7.3 – Legacy
|
ODBC / PostgreSQL
|
Without BLOB fields.
|
FR7SQL.app , FR7SQL.dct
|
C7.3 – ABC
|
ODBC / PostgreSQL
|
Without BLOB fields.
|
Folder: FullRecord\ SQLAnywhere\
Example
|
Clarion version
|
File driver
|
Comments
|
FR6ABSQL.app , FR6SqlB.dct
|
C6.3 – ABC
|
SQL Anywhere
|
With BLOB fields.
|
FR6LBSQL.app , FR6SqlB.dct
|
C6.3 – Legacy
|
SQL Anywhere
|
With BLOB fields.
|
FR6LSQL.app , FR6Sql.dct
|
C6.3 – Legacy
|
SQL Anywhere
|
Without BLOB fields.
|
FR6SQL.app , FR6Sql.dct
|
C6.3 – ABC
|
SQL Anywhere
|
Without BLOB fields.
|
FR7ABSQL.app , FR7SqlB.dct
|
C7.3 – ABC
|
SQL Anywhere
|
With BLOB fields.
|
FR7LBSQL.app , FR7SqlB.dct
|
C7.3 – Legacy
|
SQL Anywhere
|
With BLOB fields.
|
FR7LSQL.app , FR7Sql.dct
|
C7.3 – Legacy
|
SQL Anywhere
|
Without BLOB fields.
|
FR7SQL.app , FR7Sql.dct
|
C7.3 – ABC
|
SQL Anywhere
|
Without BLOB fields.
|
Notes on the examples:
RSA6.APP
This example use the NeatMessage template to record the messages to messages database and check for the "don't ask again" feature.
FRFBA6.APP
This example uses Firebird files (via ODBC) and is based on ABC. This example app was created with Clarion 6.3, and it should work with any previous version of Clarion 6. You need Firebird installed on your computer to run this example. See the ABC - FullRecord (Without NeatMessage) chapter for more details.
This example shows the recovering of records using ODBC and SQL syntax.
FR6SQL.APP
This example uses MS-SQL files (via the Clarion MS-SQL driver) and is based on ABC. This example app was created with Clarion 6.3, and it should work with any previous version of Clarion 6. You need MS-SQL Server installed on your computer (any version) to run this example. See the ABC - FullRecord (Without NeatMessage) chapter for more details.
This example shows the use of server-side autonumbering of the Audit file.
FR6LSQL.APP
This example is the same as the example above except for the fact that it is based on the Legacy (Clarion) template chain.
FRAIM6.APP
This example uses Clarion’s IMDD files and is based on ABC. This example was created with Clarion 6.3, and it should work with any previous version of Clarion 6. You need the IMDD driver installed on your computer to run this example.
|