duplicate entry error |
Posted in 02th, 02/2006 09:13 by info |
i am using db tools 3.1 to remotely manage an sql5 db with 3 tables
i have a windows xp home machine.
when adding an entry (a new row 128 ) to one of the tables i get an error message saying
'duplicate entry '127' for key 1
it allows me to type in 128 and then add a few of the values to that row but then kicks up the error
there is only one of each number in this number column.
why is this happening ?
sorry to be somewhat underpowered on the sql front by i am a beginner ... jon / |
Re: duplicate entry error |
Posted in 02th, 02/2006 11:53 by support |
Hi Jon,
In order to help you with that we need a little bit more of information:
- Database Engine and Version
- Table Structure
- Sample data for the new record being inserted
With these information we can reproduce the problem and understand better what you are trying to accomplish.
Thanks,
Support / DBTools Software |
Re: duplicate entry error |
Posted in 02th, 02/2006 12:45 by info |
DAO engine 3.6
version 3.1.1 freeware
is it simpler if i attach the table somehow ? if so how do i do this ?
many thanks
jon / |
Re: duplicate entry error |
Posted in 02th, 02/2006 04:25 by support |
Hi,
I think this information is incorrect. Are you using DBManager to manage MSAccess databases? If yes than this shouldn't be the Freeware Edition 3.1.1, as only the Enterprise Edition is able to do that.
What is your database server? MySQL, SQL Server, PostgreSQL, etc. And which version are you using? If using MySQL select the server in DBManager and you will get both the client and server versions.
Best Regards,
Support / DBTools Software |
Re: duplicate entry error |
Posted in 03th, 02/2006 06:48 by info |
So here is the info
Server
Version 4.1.11
Client
Startup Automatic
Client Version 5.0.6-beta
it is a mysql db that i am connecting to.
still dont know how to attach the table with data etc and screenshot of the error message as you asked for before ??
thanks again !
jon / |
Re: duplicate entry error |
Posted in 03th, 02/2006 09:13 by support |
Hi Jon,
I forgot one information in my last post, sorry. The attachment you can send directly to support@dbtools.com.br.
Thanks,
Support / DBTools Software |
RE: duplicate entry error |
Posted in 25th, 03/2015 04:36 by linmikey |
You get the sense that Pele knows iphone 6 plus protective film what you are going to ask him even before you start to formulate the words. Double Sided Adhesive Perhaps it is just natural intuition, the same instinctive understanding for human behaviour—and how he can use that to his own advantage—that die cut helped make him the greatest footballer, and the most prolific goalscorer, Stand Up Pouches the sport has ever seen. zenok5528 / |