Home | Features | Documentation | Sales | Support | SmartWare 4 | Search | About Us | Contact Us
 
 
  Faircom
  Faircom Engine
  ODBC Driver
  Windows Report Editor
  Binary Fields
  SQL Query Editor
  Forms and Controls
  COM and Integration
  Event Driven Programs
  Pocket PC Enabled
  Datasheets
  Debugging Tools
  Typed Variables
  The New SPL Editor
 


 
Faircom Technology

FairComŪ released c-treeSQL Server and new edition of c-tree Plus incorporating an array of interface technology and advanced features.  SmartWare has been integrated into this newest Client Server database engine. Visit FairCom's website to learn more.

 

Faircom Database

Faircom is the database engine of the SmartWare development platform. Currrently SmartWare is using the 7.0 version of the Faircom engine

Faircom Client Server

Client/server computing - increases performance and provides the ability to maintain database integrity, especially in multi-user environments. The basic principle of client/server computing is: applications, or "clients", interact with the server, which manages file operations and communicates with clients.

Faircom User Manual

Faircom File Formats

 

With the use of the Faircom engine SmartWare has three types of database file formats:

 

Local 4

Local 5

Client / Server 5

In the use of the product these file format options will appear in many situations. The Local 4 file format is used for dealing with data from legacy versions.  This format was used prior to the release of SmartWare 4.5.  With the release of SmartWare 4.5 there was the introduction of file formats Local 5 and Client/Server 5. 

 

Client/Server 5 is the format of choice when the data files will be shared across a network.  The use of Client/Server 5 requires the installation of the SmartWare Server from the installation media. This server is the Faircom Server and will appear as a Faircom icon in the taskbar when running.

 

Faircom as a Service

The Faircom Server can be started manually or run as a service.  In many environments the Faircom Server is run as a service on the networks application server.  This service can be setup with a utility found in the Utilities folder of the Faircom install.

To manually install the c-tree Server as a Windows NT/2000/XP Service after installation, run ctntinst.exe, specifying the -install option. You may optionally specify the service name. For example:

c:\faircom\bin.svc> ctntinst -install

c-treeServer Created

See the "c-tree Server Service" section for more information on operating the c-tree Server as a Service.

Faircom Transactions

Faircom Client Server provide a new level of data integrity.  Transactional databases protect the data from corrupt by writing the transaction or not writing the complete transaction. With online transaction processing (OLTP) - the c-tree Server can group a specified set of operations, called a "transaction," and ensure either all of them are done or, if there is a problem, none will be done, e.g., either all of an invoice is processed, or none of it.

Faircom Backup and Recovery

The c-tree Server automatically saves necessary information for use in automatic, or Administrator-specified, backups and for recovery from problems.

Faircom Security Controls

C-tree Server access is controlled with user IDs, passwords, file permissions, and encryption. Users and files may be added to Administrator defined "groups", e.g., shipping department, payroll department.

Faircom - Flexible Configurations

Configurations can be changed for a number of basics such as which communication protocol the c-tree Server uses, memory allocations,  specific users configurations, to a wide range of advanced controls.

 

 

 
 
 
Home | About Us | Contact Us | Copyright