Stonefield Query SDK
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