Stonefield Query SDK 
Introduction What's New in This Version Licensing Demo Version Software Maintenance Technical Support Copyright 
Quick Start Sample Project Step 1: Create a Stonefield Query Project Step 2: Fill in the Data Dictionary Step 3: Specify Configuration Settings Step 4: Test Your Project Step 5: Deploy to Your Users Working with the Configuration Utility Introduction Menu and Toolbar Functions Creating a New Stonefield Query Project Opening an Existing Stonefield Query Project Data Dictionary Adding a Database to the Data Dictionary Database Properties Creating a Virtual Table Table Properties Creating a Subtable Creating a Calculated Field Field Properties Creating a Relation Relation Properties Refreshing the Data Dictionary Viewing Table Contents Filtering the Data Dictionary Creating a Data Group Expression Builder Creating a User Group Configuration Settings Application Name Short Application Name Display Application Name Support Multi-Languages Default Language Message for Invalid Directory Support Email Sales Email Sales Phone Support Fax Number Company Web Site Company Name Logo Image File Icon File Registry Key for Earlier Version Allow Multiple Data Sources User Can Manage Data Sources Default Table for New Reports Default Data Group for New Reports Description for Data Sources Description for Data Groups User Can Edit SQL Statement Use DSNless Connection Include Joins in the WHERE Clause Stonefield Query Performs Joins Default for Auto-Adding DISTINCT Allow Queries on Multiple Data Sources Enable Table/Field Favorites Need Target Application Directory Target Application's Name Message for Invalid Target App Directory Support Online Updates URL for Online Updates Username for Online Updates Password for Online Updates Updates File for Online Updates Support Maintenance Reminder Scripts Creating a New Script Adding Existing Scripts to a Project User-Defined Scripts Data Object Scripts GetDataSources OpenDataSource Select Event Scripts About.Settings Application.AfterSetup Application.BeforeLogin Application.BeforeSetup Application.GetDefaultTargetAppDir Application.ReportsExplorerActivated Application.ReportsExplorerReady Application.Shutdown Application.ValidateCommonAppDir Application.ValidateTargetAppDir DataEngine.AfterDataEnvironmentCleared DataEngine.AfterDataGroupsLoaded DataEngine.AfterResultSetRetrieved DataEngine.BeforeCreateSQLStatement DataEngine.BeforeResultSetRetrieved DataEngine.FilterChanged DataEngine.FinalizeSQLStatement DataEngine.GetCustomMetaData Options.Changed Options.Settings Options.Validate Registration.Settings ReportEngine.AfterGetFolders ReportEngine.AfterReportPrepared ReportEngine.AfterRunReport ReportEngine.BeforeRunReport Scheduler.GetCommandLine Setup.Changed Setup.Settings Setup.Validate Stonefield Query Security Multi-Language Support Encrypting a Project Launching Stonefield Query Creating Project Documentation Importing a Data Dictionary Deploying Stonefield Query Creating a Help File Providing Sample or Standard Reports Providing Sample or Standard Templates Creating a Setup Executable Tutorials Creating a Project Microsoft Access Microsoft SQL Server Microsoft Visual FoxPro Accessing Multiple Data Sources Allowing the User to Manage Data Sources Access and SQL Server Northwind Different Visual FoxPro Data Sources Accessing Local and Remote SQL Server Databases Calculated Fields That Call Scripts Joins Between Different Databases Stonefield Query Object Model Application Object AddProperty Decrypt Encrypt Execute GetINIValue GetRegistryValue GetValuesCollection PromptUserForValue SetINIValue SetRegistryValue ShowErrorMessage ShowStatus Shutdown UpdateProgressBar Collections AddItem Item RemoveItem DataEngine Object AddToWhere GetFieldsFromSQLStatement GetTableFromSQLStatement GetTablesFromSQLStatement GetValuesForField GetValuesForParameter Databases Collection GetMainDatabase Database Object ExecuteSQLStatement OpenDataSource Method DataSources Collection AddItem Method DataSource Object Connect Disconnect Fields Collection Field Object FilterConditions Collection FilterCondition Object Joins Collection Join Object Parameters Collection Tables Collection ReportEngine Object GetFolders GetReport GetReports RunReport RunReportToFile Table Object Users Collection GetLicenseCount IsValidUser Login User Object How To Activating Stonefield Query Adding an Existing Data Dictionary to a Project Converting FoxFire Reports to Stonefield Query Converting Stonefield Reports to Stonefield Query Creating a Branded Version of Stonefield Query Creating a Values Method Script for a Field Displaying a Splash Screen Executing Custom Code in the Configuration Utility Filling the Data Dictionary Automatically Getting Diagnostic Information Handling GMT Fields Licensing Reports Linking to Google Maps Running Stonefield Query from Other Applications Command-Line Interface SQProxy Object Specifying Libraries to Load Updating From Visual MaxFrame Professional Updating Stonefield Query to the Latest Version Using a Stored Procedure for Data Access Using a Text File for a Data Source Using a Web Service for a Data Source Using SQLXML for a Data Source Technical Reference Data Dictionary Table Structure Registry Settings Security Tables Stonefield Query Directories Stonefield Query Project Files Structure of Reports Table Frequently Asked Questions Business Issues Configuration Issues Database Issues Other Issues Reporting Issues Script Issues