This happens with a normal query like :

SELECT * FROM "Pedimentos" where numero = '2004131'

When I open the table with control center it executes de default query
and lists all the rows, but as soon as I add "where numero = '2004131'
" and execute the query I get the error above. This is with Pervasive
v8.

Any Ideas what is worng?

TIA
Carlos San Miguel

This Status code loosely translates to the Btrieve Status Code 6 --
Invalid Key Number. It means that the SQL engine attempted to use a
Btrieve Key Number that was not defined. This should not happen in a
clean database, but your database is having some problems.

If you run the Check Database Wizard against this data file, you'll see
that the Data Dictionaries (DDFs) probably define a SQL-level index on the
field "numero" which defines a certain index number, pero the Btrieve file
does not have that index number defined.

There are various ways of fixing these discrepancies, and the correct way
depends on many factors outside the realm of what we can examine in this
forum. Most commonly, if an index is missing, you can add it at the
Btrieve level. You can also remove the definition at the DDF level. Of
course, with NO index, the look-up will become a table-scan, and the
system will need to examine every record in the database to find its
corresponding records -- not pretty.

I'd go back & pressure the developer for dictionaries that match the
Btrieve files...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 18-20: See our web site for details!


carlossm wrote:

Thanks Bill, I think my DDF is wrong. I created the DDF's manually
based on the btrieve file definition. I'm using transactional access
to the tables, but now my customers need access to the tables so I
created the ddf's with SQL scripts and I think I must have missed and
Index definition.

Carlos San Miguel


carlos (AT) vanguardiatec (DOT) com (carlossm) wrote in message news:<61105627.0311181848.21ffe4e5 (AT) posting (DOT) google.com>...

Bill:

How do you translate the -4993 into Btrieve error 6?

TIA,
C.G.

"Bill Bach" <bbach (AT) cncdsl (DOT) com> escribió en el mensaje
news:3FBC1198.EABE0779 (AT) cncdsl (DOT) com...

New math. ;-)

StatusCodeReturned + 4999 = Btrieve Status Code

Or, you can check the "Status Codes & Messages" on-line manual and see:

-4993: The key number parameter is invalid
See "6: The key number parameter is invalid" on page 1-54



Curious George wrote:

Thanks:

I'm not sure I would have sorted that one :-)

C.G.

"Bill Bach" <bbach (AT) cncdsl (DOT) com> escribió en el mensaje
news:3FBD59D6.1300422A (AT) cncdsl (DOT) com...