Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

TAS BOOKS 3 - Btrieve Error: 5

Posted on 2011-02-24
3
Medium Priority
?
1,622 Views
Last Modified: 2012-05-11
I have an error when trying to save an entry in TAS BOOKS 3...

Btrieve Error: 5

Btr Error (X:\ITS\MTATRN.B): 5 Duplicate Key Value

Click OK and it comes up again!

Help, please
0
Comment
Question by:Andy-UK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 34979047
Put simply, a Duplicate key error. Is a programming bug. The developer created a unique key, and the database is preventing a duplicate from being created.

You may need to contact the original developer for help on something like this.

Alternatively, yoy can enable MKDE Tracing on the database engine and find out whoch call is resulting in the 5, and figure out how to avoid it yourself, but other than deleting the already-existing record that is causing the dupe, this might be difficult, too.  
0
 

Accepted Solution

by:
Andy-UK earned 0 total points
ID: 35047324
The software was trying to use the same posting number twice...

The previous posting number was the same as the next posting number

Changed the "next posting number" add 1 - and it worked fine
0
 

Author Closing Comment

by:Andy-UK
ID: 35106988
Only correct answer
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question