|
|
 |
| Home » Forums » DBManager General |
|
|
| duplicate entry error (455 previews) | |
| 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 |
|
| duplicate entry error (455 previews) | |
Legends Topic has Replies Topic With no Replies
|
|
| Home » Forums » DBManager General |
|
|
Copyright © 2001-2013 dbTools Software. Best viewed with IE 7.x, Chrome or Firefox 3.x or higher at 1024x768 Register | Contact US | Forums | About US |