This topic discusses two sets of directory structures: for Stonefield Query Studio and for Stonefield Query Enterprise (the web application).

Stonefield Query Studio directories

These are the directories for Stonefield Query Studio. Stonefield Query Studio is not deployed to a customer's system.

  • Program folder: the folder you installed Stonefield Query Enterprise in. By default, this folder is under C:\Program Files (x86) (or C:\Program Files for a 32-bit system), but you may have chosen to install it in a different location or on a network server.

  • Data: the Data subdirectory of the program folder contains system data files Studio needs, such as its license file (SQConfig.lic), the error log file if errors occur, diagnostic files, and so forth. All users have read-write permission to this folder since Studio must be able to write to these files.

  • HelpSource: the source of the help files generated for your project.

  • Samples: contains several samples, including a sample project and .NET projects that demonstrate how to create plugins and applications that use Stonefield Query.

  • Setup: contains various files Studio requires.

  • SQWeb: the Stonefield Query Enterprise application. This folder's contents are deployed to your web server (see the section below).

  • Templates: report template files.

  • x64: 64-bit SQLite files.

  • x86: 32-bit SQLite files.

  • Windows: Stonefield Query only installs a single file, HH.EXE (the core help system file) in the Windows folder, and only if that file doesn't already exist. This file is installed (if necessary) on your system even if you installed Stonefield Query on a network server.

  • Windows System: Stonefield Query installs several DLL and OCX files (special system files) it needs in the Windows System folder (usually SysWOW64 on a 64-bit system). These files are only installed if they don't already exist, but are installed on your system even if you installed Stonefield Query on a network server.

  • C:\Program Files (x86)\Common Files\Microsoft Shared\VFP: this folder contains additional DLL files Stonefield Query requires. These are installed on your system even if you installed Stonefield Query on a network server.

Stonefield Query Enterprise directories

These are the directories for Stonefield Query Enterprise:

  • bin, Content, fonts, Scripts, and Views: Stonefield Query program files. You deploy these folders to a customer's system (this is done automatically if you use the Publish function in the File menu).

  • Functions: contains Functions.dll, which has the functions described in the Expressions and Functions Reference. You deploy this folder to a customer's system.

  • Images: contains images used by Stonefield Query Enterprise, including the image specified in the Logo Image File configuration setting. You deploy this folder to a customer's system.

  • Licenses: the Licenses subdirectory of the program folder contains the license files. The Licenses subdirectory of this folder contains user license files. All users have read-write permission to these folders since Stonefield Query must be able to write to these files. You do not deploy this folder to a customer's system, as it is automatically created on their system, unless you're using an unlimited license named Unlimited.lic, in which case you should deploy this file. Do not deploy SFQuery.lic if it exists on your system, as that is your license and is system-specific.

  • Logs: contains Logger.config, which specifies the Log4Net configuration settings, and application log files. All users have read-write permission to these folders since Stonefield Query must be able to write to these files. You deploy this folder to a customer's system but only Logger.config, since the other files are simply logs of previous runs on your system.

  • Plugins: contains ApplicationPlugin.dll, Setup.dll, ValueConverters.dll, and VirtualTables.dll, which provide standard plugin features used by Stonefield Query Enterprise. You deploy this folder to a customer's system.

  • Resources: the Resources subdirectory of the program folder contains the language resource files that come with Stonefield Query. You deploy this folder to a customer's system.

  • Templates: contains report templates. You deploy this folder to a customer's system.

  • x64: 64-bit SQLite files. You deploy this folder to a customer's system.

  • x86: 32-bit SQLite files. You deploy this folder to a customer's system.