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: Setting up Options          Step 2: Create a Stonefield Query Project          Step 3: Customizing the Data Dictionary          Step 4: Specify Configuration Settings          Step 5: Test Your Project          Step 6: Deploy to Your Users Stonefield Query Studio          Introduction      Working with Stonefield Query Studio              Menu and Toolbar Functions              Panels          Creating a New Stonefield Query Project          Opening an Existing Stonefield Query Project      Data Dictionary              Adding a Database to the Data Dictionary              Database Properties              Table Properties              Creating a Subtable              Creating a Virtual Table              Field Properties              Creating a Calculated Field              Creating a Relation              Relation Properties              Refreshing the Data Dictionary              Viewing Table Contents              Filtering the Data Dictionary              Expression Builder              Versioning          Application Views          Creating a Data Group          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              URL for Technical Support Site              Company Web Site              Company Name              Support Contact Information              Logo Image File              Icon File              Registry Key for Earlier Version              URL for News Feeds              Tag for News Feed              Number of Days for Demo Version              Allow Multiple Data Sources              User Can Manage Data Sources              Table to Test              Default Table for New Reports              Default Data Group for New Reports              Default Application View for New Reports              Description for Data Sources              Description for Data Groups              Description for Application Views              User Can Edit SQL Statement              Use DSNless Connection              Share Database Connections              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              Display "All" Data Group              Use a Schema for Queries              Use Application Views by Default              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              Script Languages              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.BeforeShowWizard                  Application.GetDefaultTargetAppDir                  Application.GetShortcutParameters                  Application.ReportsExplorerActivated                  Application.ReportsExplorerReady                  Application.SetupMenu                  Application.Shutdown                  Application.ValidateCommonDir                  Application.ValidateTargetAppDir                  DataEngine.AfterDataEnvironmentCleared                  DataEngine.AfterDataGroupsLoaded                  DataEngine.AfterResultSetRetrieved                  DataEngine.BeforeCreateSQLStatement                  DataEngine.BeforeResultSetRetrieved                  DataEngine.BeforeSendSQLStatementToDatabase                  DataEngine.FilterChanged                  DataEngine.FinalizeSQLStatement                  DataEngine.GetCustomMetaData                  DataEngine.GetDataSourceDescription                  DataEngine.GetObjectVersion                  DataEngine.HandleSQLError                  Options.Changed                  Options.Settings                  Options.Validate                  OutputOptions.Settings                  Registration.Settings                  ReportEngine.AfterGetFolders                  ReportEngine.AfterReportPrepared                  ReportEngine.AfterRunReport                  ReportEngine.BeforeRunReport                  ReportEngine.SetReportProperties                  ReportEngine.SetupCrystalReport                  Scheduler.GetCommandLine                  Setup.Changed                  Setup.Settings                  Setup.Validate          Stonefield Query Security          Multi-Language Support          Encrypting a Project          Launching Stonefield Query          Importing a Data Dictionary          Querying the Data Dictionary Deploying Stonefield Query          Creating a Help File          Providing Sample or Standard Reports          Providing Sample or Standard Templates          Changing the File Description for SFQuery.exe          Creating a Setup Executable Tutorials      Creating a Project              Microsoft Access              Microsoft SQL Server      Accessing Multiple Data Sources              Allowing the User to Manage Data Sources              Microsoft Access and SQL Server Northwind              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              GetDataSetFieldName              GetINIValue              GetRegistryValue              GetValuesCollection              PromptUserForValue              SetINIValue              SetRegistryValue              SetViewerLicenses              ShowErrorMessage              ShowStatus              Shutdown              UpdateProgressBar      Collections              AddItem              Clear              Item              RemoveItem          AppView Object          AppViews Collection          AppViewField Object          AppViewFields Collection          CustomJoin Object          CustomJoins Collection      Database Object              ExecuteSQLStatement              OpenDataSource Method      Databases Collection              GetMainDatabase      DataEngine Object              AddToFavorites              AddToFields              AddToWhere              GetFieldsFromSQLStatement              GetTablesFromSQLStatement              GetValuesForField              GetValuesForParameter              ODBCFilterToLocalFilter      DataSource Object              Connect              Disconnect      DataSources Collection              AddItem Method          Field Object          Fields Collection          FilterCondition Object          FilterConditions Collection          Join Object          Joins Collection          Parameters Collection      Report Object              CreateOutput              GetReportFilter              GetReportFooter              GetReportHeader              RunReport              SetOutputToFile      ReportEngine Object              GetFolders              GetReport              GetReports              PreviewReport              PrintReport              RunReport              RunReportToFile          ReportField Object          ReportFields Collection          Sort Object          Sorts Collection          Table Object          Tables Collection      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 Stonefield Query Studio          Filling the Data Dictionary Automatically          Getting Diagnostic Information          Handling GMT Fields          Licensing Reports          Linking to Google Maps          Outputting Rich Text Fields      Running Stonefield Query from Other Applications              Command-Line Interface              SQProxy Object              Using SQProxy in .Net Applications              Sample ASP.Net Web Application          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 Case-Insensitve Joins          Using SQLXML for a Data Source Technical Reference          Data Dictionary Table Structure          Registry Settings          Security Tables          Stonefield Query Directories          Stonefield Query Project Files      Stonefield Query .NET Wrapper Classes          Namespace SFQWrapper              Class AppView                      Caption                      DataGroup                      ErrorMessage                      Fields                      Key                      MainList                      Order                      ParentKey              Class AppViewField                      Caption                      ErrorMessage                      FieldName                      Heading                      Order              Class AppViewFields                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class AppViews                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class AskAtRuntimeValues                      AddItem              Class CustomJoin                      ErrorMessage                      JoinType                      Table1                      Table2              Class CustomJoins                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class Database                  ExecuteSQLStatement                          ExecuteSQLStatement                  OpenDataSource                          OpenDataSource                      Active                      Connected                      CurrentDataSource                      DatabaseName                      DataSourceName                      DataSources                      Description                      ErrorMessage                      MainDatabase                      Quiet              Class Databases                      AddItem                      Clear                      GetMainDatabase                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class DataEngine                      AddToFavorites                      AddToFields                      AddToWhere                      GetFieldsFromSQLStatement                      GetTableFromSQLStatement                      GetTablesFromSQLStatement                  GetValuesForField                          GetValuesForField                  GetValuesForParameter                          GetValuesForParameter                      AppViews                      Databases                      ErrorMessage                      ExcludeConditions                      Fields                      FilterConditions                      IncludeJoinsInWhere                      Joins                      PerformJoins                      Tables              Class DataSource                      Connect                      Disconnect                      BaseURL                      CommandTimeout                      ConnectionHandle                      ConnectionString                      ConnectionTimeout                      Database                      Datasource                      Description                      Driver                      DSN                      ErrorMessage                      Method                      OtherConnectInfo                      Password                      Server                      Specifier                      Type                      UserDefined                      UserName                      UseTemplate                      WSDLURL              Class DataSources                  AddItem                          AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class Field                      Alias                      AllowValues                      Calculated                      Caption                      Comment                      Decimals                      ErrorMessage                      Exact                      Expression                      Favorite                      FieldList                      FieldName                      Filterable                      Format                      Heading                      Length                      Order                      Other                      OutputLength                      OutputType                      Picture                      Reportable                      Roles                      Sortable                      SQExpression                      Type                      UserDefined                      ValuesMethod                      Version              Class Fields                  AddItem                          AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      AliasFilter                      Count                      ErrorMessage              Class FilterCondition                      AskAtRunTime                      CaseSensitive                      Condition                      Connection                      Display                      ErrorMessage                      FieldName                      IncludeInDisplay                      Operator                      Values                      ValueType              Class FilterConditions                  AddItem                          AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      AskAtRuntimeOnly                      Count                      ErrorMessage              Class Folder                      CreatedAt                      CreatedBy                      FolderName                      HasChildren                      HasFolders                      HasParent                      ID                      ParentID              Class Folders                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class Join                      ChildExpression                      ChildTable                      ErrorMessage                      JoinExpression                      JoinName                      JoinType                      ParentExpression                      ParentTable                      Version                      Weight              Class Joins                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class Parameter                      Name                      Value              Class Parameters                  AddItem                          AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class ReflectionService                      CallMethod                      GetProperty                      SetProperty              Class Report                      CreateOutput                      GetAskAtRuntimeFilter                      GetAskAtRuntimeFilterCount                      GetReportFilter                      GetReportFooter                      GetReportHeader                      RunReport                  SetOutputToFile                          SetOutputToFile                          SetOutputToFile                      Advanced                      AllowDuplicates                      AllowEmptyResultSet                      AllowFilter                      AllowSort                      AskAtRunTime                      BCCRecipients                      CCRecipients                      Comments                      CustomJoins                      DataGroup                      DisplayFilter                      Distinct                      EmailBody                      EmailSubject                      EncodedName                      EndPage                      EraseFile                      ErrorMessage                      ExcludeConditions                      Fields                      FilterConditions                      Footer                      ForEachMode                      HaveGroupedFields                      Header                      ID                      Margin                      Orientation                      Output                      OutputFileName                      Recipients                      Records                      ReportName                      ReportType                      ShowTotalsInGroupHeader                      Sorts                      SQLSelect                      StartPage                      Summary                      Timestamp                      UserName              Class ReportEngine                      FillTreeView                  GetFolders                          GetFolders                      GetReport                  GetReports                          GetReports                  RunReport                          RunReport                          RunReport                          RunReport                          RunReport                  RunReportToFile                          RunReportToFile                          RunReportToFile                          RunReportToFile                          RunReportToFile                          RunReportToFile                      ErrorMessage              Class ReportField                      Alias                      AllowValues                      Autofit                      BackColor                      Bookmark                      Calculated                      Caption                      Chart                      ChartFormat                      ChartInputMask                      ChartOrder                      ChartTotalType                      Comment                      CursorFieldName                      DataTrimming                      Decimals                      ErrorMessage                      Exact                      Expression                      Favorite                      FieldList                      FieldName                      Filterable                      FontAlign                      FontBold                      FontItalic                      FontName                      FontSize                      FontUnderline                      ForeColor                      Format                      Group                      GroupCount                      GroupOnOneLine                      Heading                      HPosition                      Length                      NewPage                      NoTotalsForOneRecord                      Order                      Other                      OutputLength                      OutputType                      Picture                      Reportable                      ResetPage                      Roles                      ShowPercent                      Sortable                      SQExpression                      Suppress                      TotalType                      Type                      UseDefaultFormat                      UseDefaultFormatForChart                      UserDefined                      ValuesMethod                      Version                      VPosition                      Width                      WidthOnReport              Class ReportFields                  AddItem                          AddItem                          AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class Reports                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class Settings                      Address1                      Address2                      City                      Company                      Contact                      Country                      Email                      Fax                      Phone                      PostalCode                      Region              Class SFQApplication                  AddProperty                          AddProperty                      Decrypt                      Encrypt                      Execute                      GetDataSetFieldName                  GetINIValue                          GetINIValue                      GetProperty                  GetRegistryValue                          GetRegistryValue                          GetRegistryValue                      GetValuesCollection                  PromptUserForValue                          PromptUserForValue                          PromptUserForValue                      SetINIValue                      SetProperty                  SetRegistryValue                          SetRegistryValue                      ShowErrorMessage                      ShowStatus                      Shutdown                      UpdateProgressBar                      ApplicationDataDirectory                      ApplicationDirectory                      ApplicationName                      CanEditReports                      DataEngine                      ErrorMessage                      Parameters                      ProjectDirectory                      ReportEngine                      ReportsDirectory                      SerialNumber                      ShortApplicationName                      TargetApplicationDirectory                      TimeZoneDesc                      TimeZoneOffset                      Users                      Version              Class Sort                      Alias                      Ascending                      Caption                      ErrorMessage                      FieldName                      Group                      Order              Class Sorts                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class Table                      Alias                      Caption                      Database                      DataGroup                      ErrorMessage                      Location                      OriginalTable                      Reportable                      Roles                      Schema                      SubTableFilter                      UserDefined                      Version                      Virtual              Class Tables                      AddItem                      Clear                  Item                          Item                  RemoveItem                          RemoveItem                      Count                      ErrorMessage              Class User                      Administrator                      Advanced                      ErrorMessage                      FirstName                      LastName                      License                      Password                      Roles                      UserName              Class Users                      AddItem                      Clear                  GetLicenseCount                          GetLicenseCount                      IsValidUser                  Item                          Item                      Login                  RemoveItem                          RemoveItem                      Administrator                      Advanced                      Count                      ErrorMessage                      UserName              Class ValueItem                      IncludeTime                      Value              Class Values                  AddItem                          AddItem                          AddItem                      Clear                      Item                      RemoveItem                      Count          Namespace SQProxyWrapper              Class SQProxy                  LoadProject                          LoadProject                          LoadProject                          LoadProject                      ErrorCode                      ErrorMessage                      Parameters                      ProjectLoaded                      ProxyTimeout                      SQApplication          Structure of Reports Table Frequently Asked Questions          Business Issues          Configuration Issues          Database Issues          Other Issues          Reporting Issues          Script Issues