CHAPTER 1
Introducing FileFlex
FileFlex Features and Benefits... FileFlex System Capacities...
CHAPTER 2
FileFlex 3 Release Notes
FileFlex 3.0.1 Release Notes... New FileFlex 3.0 Features... New Functions... Modified Functions... Obsoleted Features and Functions...
CHAPTER 3
Distributing FileFlex in Your Projects
Licensing FileFlex... Terms and Conditions... Older FileFlex Releases...
CHAPTER 4
Using FileFlex with FoxPro and Access
Using FileFlex with FoxPro... Using FileFlex with Access...
CHAPTER 5
Interacting with FileFlex
FileFlex Has Its Own Data Files... FileFlex Standard Data File Formats... FileFlex Data Types... Managing Multimedia Data... Wrapper Scripts... Calling FileFlex Functions... Initiating FileFlex Operations... Terminating FileFlex Operations...
CHAPTER 6
FileFlex and Director
Database Access in Director... Designing Databases for Use in Director Productions... Using FileFlex with Director... FileFlex Adds Database Commands to Lingo... Cross Platform Considerations... Upgrading from Earlier FileFlex Releases... A Sample Lingo Session with FileFlex...
CHAPTER 7
Creating Databases
Executing the DBCreate Function... Automatic Databases... Describing the Database... Example...
CHAPTER 8
Managing Data Files
Opening and Selecting Database Files... Default File Paths... Navigating in the Database...
CHAPTER 9
Reading Data from a Database File
Retrieving a Field by Name... Reading a Record into a Container... Retrieving a Memo Field... Retrieving a Record into Global Variables... Retrieving a List of Matches...
CHAPTER 10
Adding and Updating Data
Changing Field Values from a Container... Changing a Memo Field from a Container... Changing a Field's Value from Global Variables... Adding a New Record to the Database... Multiple Database Update Technique...
CHAPTER 11
Deleting Records
Marking Records for Deletion... Unmarking Delete-marked Records... Physically Removing Marked Records... Physically Deleting Records... Determining if a Record is Deleted... Tutorial: Navigating Over Deleted Records...
CHAPTER 12
Understanding Expressions
Expression Constants... Field Names... Intrinsic Functions and Operators... Logical Operators... String Constants in Expressions... FileFlex Intrinsic Functions... Constructing Search Expressions...
CHAPTER 13
Ultra-fast Searching with Indexes
Index Basics... Sort Orders and Tags... Automatic "Structural" Indexes... Index Files Supported... When Indexes are Updated Automatically... Opening and Using Index Files... Opening an Index File... Selecting a Sort Order Tag... Finding a Record by Tag... Building a Seek Expression... Creating a New Index... Creating an Index Expression... Creating a Filter Expression... Checking an Index File for Currency... Reindexing a File... Closing an Index File...
CHAPTER 14
Understanding FileFlex Relations
Creating a Relation Tree... Selecting Relations... Adding Relations... Building a Relational Query Expression... Accelerating a Relational Query... Sorting the Query Results... Relations and Navigation... Closing the Relation...
CHAPTER 15
Searching a Database in Order
The DBQuery Function... Finding the Next Match...
CHAPTER 16
Full-Text Search and Retrieval
Easy Full-Text Search... Building a Complex Indexed Full-Text Search... Constructing a Full-Text Index... Searching Using a Full-Text Index...
CHAPTER 17
Office-Quality Encryption
Encryption Limits... Standalone Encryption (DBEncrypt and DBDecrypt)... Dynamic, On-the-Fly Encryption Functions...
CHAPTER 18
Tables, Columns, and Counting
Counting the Total Number of Records... Calculate an Average... Calculate the Sum of a Field... Finding out the Number of Records in a Given Set... Retrieving Lists of Matches... Padding Strings and Columns... Filling a Column With a Character... Combining Columns Into a Table... Tutorial: Building HTML Tables...
CHAPTER 19
Multi-user FileFlex
File Locking... Record Locking... Preventing Deadlock... Multi-user Functions... Setting the Sharing Mode... Locking a Record... Locking An Entire Database... Unlocking a Database... Updating Relations...
CHAPTER 20
Character Translation
Creating Character Translation Utility Scripts... Translating Characters Using FileFlex... Standalone Case Conversion Functions...
CHAPTER 21
Printing from FileFlex Databases
How to design a report... Report Components... Adding the First Component to the Report... Adding Text to the Report... Adding Variables to the Report... Creating a Text Style... Assigning a Style... Running the Example... Hooking FileFlex to mPrint... More on mPrint... Printing Multiple Records... Questions...
APPENDIX A
Result Code Reference
Positive Result Codes... Basic Error Codes... General Disk Access Errors... Database Specific Errors... Index File Specific Errors... Multi-user errors... Expression Evaluation Errors... Memo Errors... Relation and Acceleration Errors... Other FileFlex Errors...
APPENDIX B
FileFlex Support
FileFlex Headquarters on the Web... FileFlex Discussion Boards... The FileFlex Mailing List... How to Get Technical Support...
APPENDIX C
FileFlex Historical Release Note Archive
FileFlex 2.0.5 Release Notes... FileFlex 2.0.3 Release Notes... FileFlex 2.0.2 Release Notes... FileFlex 2.0.1 Release Notes... FileFlex 2.0 Release Notes... FileFlex 1.7.1 to 1.7.4 Fix Notes... FileFlex 1.7 Release Notes... FileFlex 1.6 Release Notes... FileFlex 1.5 Release Notes...
APPENDIX D
FileFlex 3 Distribution License