I need to define more than one relationship between a pair of tables. How do I do that?
You have to create a subtable for the parent table in the relationship. See the Creating a Subtable topic for details.
I have a table of employees that includes a MANAGER_ID field. This field contains the ID for another employee record representing this employee's manager. How do I set this up in Stonefield Query so a user can print the names of employees and their managers?
This type of relationship is called a self-join. Like multiple relationships between tables, you have to create a subtable and then define a relationship between the "main" table and the subtable.
After creating a data dictionary for an application's database on my system, how do I tell Stonefield Query to work with databases on my users' systems, which are in different locations than the one I'm using.
There are two ways you can do this:
If you're using ODBC and you want the user to select the data source via a DSN on their system, set the Connection type property of the database to User can choose DSN. The advantage of this approach is that you don't have to know anything about the data source, such as the server, database name, user name, password, or even which database engine it uses (such as SQL Server vs. Oracle). The downside is that a DSN has to be created on the production server.
You can programmatically define the data sources to use for a database by creating a data engine plugin with a GetDataSources method. This approach is completely transparent to the user but requires that you have complete information about the data source (driver, server, database name, user name, and password) or can read it programmatically from somewhere at runtime.
I've changed the password for my SQL Server account. How do I tell Stonefield Query Studio about this change so the Refresh button works correctly?
Select the database node in the TreeView and change the connections settings.