How does Stonefield Query access my AccountMate databases?

Stonefield Query for AccountMate accesses the same databases AccountMate uses, so you can report on any of your AccountMate databases. Stonefield Query for AccountMate LAN uses native access to the Visual FoxPro databases for speed and flexibility. Stonefield Query for AccountMate SQL uses ODBC to access databases. It requires a data source called MSSQL_VAM (if you are using a version earlier than 7.0) or AMMS (if you are using version 7.0 - 7.2) on your system that connects to the server where your AccountMate databases are located. This data source normally exists on your system if you are an AccountMate user. If it doesn't exist for some reason, please see the AccountMate documentation for instructions on creating this data source. In the case of AccountMate SQL 7.3 or later, it uses a DSNless connection to the SQL Server listed in the amsetup.am file.

I'm not getting the results I expect in a report. It looks like some records are missing.

The first thing to check is that you have the correct filter for the report. If the filter is too restrictive, you won't see all the records you expect. The second thing to check is that Stonefield Query is accessing the correct database. The name of the database is shown in the status bar at the bottom of the Reports Explorer. Finally, if your database has a "reindex" or "database maintenance" feature, use that feature to ensure the database indexes are accurate.

Filtering a report on a formula doesn't seem to work correctly.

Try turning off the Pad shorter string with spaces when comparing strings (ANSI standard) setting in the Options dialog.


© Stonefield Software Inc., 2018 • Updated: 05/29/18
Comment or report problem with topic