I have a select command that work fine.
No duplicate values.
If i want to create a view i receive Btrieve error 5. Duplicate Key
Error, SQL State 1000.

Pervasive 200i sql, serivce pack 4 , version 7.9.0.0 build 230 running
on Windows 2003 server, service pack 2.  MS updates as of 8/30/2007.
Once in a while we will recieve this pop-up on the server, which we
stop and start the Pervasive services to get the web application up

I wrote a utility to fix some fields in a Pervasive SQL 2000i SP4
database used by software our company purchased (Maximizer Enterprise)
writing in Visual FoxPro. ( Note:  Maximizer needs the db as is, so i
cant fool around with the Pervasive DB structure).  Anyways, when I did

Can anybody point me in the direction to get the DDF files for TAS Books.

We have a client using several citrix servers with Windows Server 2003 SP1
and Pervasive SQL 9.1 installed. They are all connecting to a database
located on another Windows Server 2003 with SP2. Just one of the citrix
servers is getting btrieve error 171 while connecting to the ...