Hello all!

I have a Clarion 5.5 application using Pervasive 8.5. I have a file defined
with an auto increment key. When I use the Clarion application to create the
file, the auto increment feature works as designed when inserting multiple
records. When I create the same file using Pervasive's SQL, I see an auto
increment error 40 (duplicate key) messages when I try to add additional
records while one is being inserted (when running the same Clarion
application).

I need to use the SQL generated file so that I can access the file via
Clarion and Pervasive ODBC and the file has to pass the PCC consistency test
to allow for proper use of the indexes. I have tried an integer, uinteger
and identity fields as the auto increment field in the SQL but nothing seems
to work.

Can anyone help create the correct SQL or help create a file from Clarion
that could pass the PPC consistency test?

Thanks,

Al

--
------------------------------------------------------------
Free Web Email & Filter Enhancements.
http://www.freewebemail.com/filtertools/
------------------------------------------------------------

The SQL data type for an auto inc is "Identity" for a 4 byte or
"smallidentity" for a 2 byte.

From:
http://www.pervasive.com/library/doc...pe2.html#63712

Of course if you actually are getting a status 40 then it is not a
"duplicate key" but "40: The file access request exceeds the maximum
number of files allowed" This is an "obsolete" status code for the
current product but I have seen it in a couple of extreme cases.

Leonard

On Wed, 06 Apr 2005 19:22:33 GMT, "Al Henry" <alhenry (AT) telus (DOT) net>
wrote:

Sorry, I should have stipulated the error 40 was posted by the application
(Clarion) and not the database.
After further investigation, I have determined that there is a null flag
setting issue. I am continuing my search for an answer on this.
Thanks,
Al.

--
------------------------------------------------------------
Free Web Email & Filter Enhancements.
http://www.freewebemail.com/filtertools/
------------------------------------------------------------
"Leonard" <lharvey (AT) austin (DOT) rr.com> wrote