Error: The key number parameter is invalid(Btrieve Error 6)

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Symptoms

The following are examples of error messages that may occur:

  • The key number parameter is invalid

Cause

The order of the tables in a SQL join can cause this error to happen in Pervasive. Usually the problem is related to DDF files that are not up to date with the data files.

Resolution

Sometimes the problem can be worked around by changing the order of the tables in the SQL join

applies To

  • Alchemex Administrator