473,848 Members | 1,788 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Generated UPDATE statement. could not determine which columns uniquely identify the rows for "Customers"

i am having trouble updating a datset because i get the follwing error
in the Data Adapter configuration Wizard:

Generated UPDATE statement. could not determine which columns uniquely
identify the rows for "Customers"

'Customers' is the only table from the database that im using for this
query, so it cant be anything to do with a problem of having multiple
tables. and the primary key is set. so i dont understand what the
problem is.

im using asp.net 2003, a microsoft access database, and an
OdbcDataAdapter .

can anyone help?

Apr 11 '06 #1
7 3743
It sounds like the primary key is NOT set, or has duplicate values

Jeff
"bazzer" <so*******@yaho o.com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. .
i am having trouble updating a datset because i get the follwing error
in the Data Adapter configuration Wizard:

Generated UPDATE statement. could not determine which columns uniquely
identify the rows for "Customers"

'Customers' is the only table from the database that im using for this
query, so it cant be anything to do with a problem of having multiple
tables. and the primary key is set. so i dont understand what the
problem is.

im using asp.net 2003, a microsoft access database, and an
OdbcDataAdapter .

can anyone help?

Apr 11 '06 #2
ive tried linking to a database with only one table, that has 2 fields,
'numbers', and 'names', set the primary key to numbers, and still it
wont work. ive even tried using windows forms and still i get the same
errors.

Apr 12 '06 #3
Did you check my suggestion?

"bazzer" <so*******@yaho o.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .
ive tried linking to a database with only one table, that has 2 fields,
'numbers', and 'names', set the primary key to numbers, and still it
wont work. ive even tried using windows forms and still i get the same
errors.

Apr 12 '06 #4
your suggestion? checking if the primary key is set, and checking for
duplicate values?

primary key is definetly set. and its set to Autonumber. By duplicate
values do you mean duplicate fields or primary keys. but as i said, ive
tried linking to a database with only one table, that has only 2
fields, 'numbers', and 'names', set the primary key to numbers, and
still it
wont work even with the most basic table. ive even tried using windows
forms and still i get the same errors. im about ready to give up really
cause no one seems to have a clue whats wrong. myself included. i can
only assume its something to do with the connection to the database
maybe. thanks for the help though. if u think of anything else let me
know.

Apr 12 '06 #5
Weird. Perhaps create a brand new database and try there? Perhaps it's
corrupted?

Jeff

"bazzer" <so*******@yaho o.com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. .
your suggestion? checking if the primary key is set, and checking for
duplicate values?

primary key is definetly set. and its set to Autonumber. By duplicate
values do you mean duplicate fields or primary keys. but as i said, ive
tried linking to a database with only one table, that has only 2
fields, 'numbers', and 'names', set the primary key to numbers, and
still it
wont work even with the most basic table. ive even tried using windows
forms and still i get the same errors. im about ready to give up really
cause no one seems to have a clue whats wrong. myself included. i can
only assume its something to do with the connection to the database
maybe. thanks for the help though. if u think of anything else let me
know.

Apr 12 '06 #6
tried that too a few times im afraid.

Apr 12 '06 #7
I did see this from a Google search

If I switch to OleDbConnection instead of OdbcConnection, everything's ok.

"Jeff Dillon" <je********@hot mail.com> wrote in message
news:OP******** ******@TK2MSFTN GP04.phx.gbl...
Weird. Perhaps create a brand new database and try there? Perhaps it's
corrupted?

Jeff

"bazzer" <so*******@yaho o.com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. .
your suggestion? checking if the primary key is set, and checking for
duplicate values?

primary key is definetly set. and its set to Autonumber. By duplicate
values do you mean duplicate fields or primary keys. but as i said, ive
tried linking to a database with only one table, that has only 2
fields, 'numbers', and 'names', set the primary key to numbers, and
still it
wont work even with the most basic table. ive even tried using windows
forms and still i get the same errors. im about ready to give up really
cause no one seems to have a clue whats wrong. myself included. i can
only assume its something to do with the connection to the database
maybe. thanks for the help though. if u think of anything else let me
know.


Apr 12 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
14958
by: arvee | last post by:
Hi - I'm updating an Oracle table with an empty string and getting the error: An unhandled exception of type 'System.Exception' occurred in system.data.dll Additional information: Parameter 'p1': No size set for variable length data type: String. The column is nullable and of type varchar2(50). I'm aware that I can store DBNull.Value instead and Oracle won't complain, but, I was hoping to avoid
5
1372
by: Nick Stansbury | last post by:
Hi, Sorry for the obscure title but I'm afraid I can't think of a better way to describe what happened to one of my clerks last night. The guy was working late, made a series of changes (accross a number of tables with a dependant relationship structure - i.e. a customer linked to an order linked to an invoice linked to a payments etc.) Now when he came back this morning none of the work he did last night was still there. I'm by no means...
6
9361
by: GSteven | last post by:
(as formerly posted to microsoft.public.access.forms with no result) I've created a continuous form which is based on a straightforward table (ex - customers - 100 records). On the form there is a checkbox with a control source named "MARK" (boolean) from customer table. I can check and uncheck individual records fine. Then I created 2 command buttons named "Select All" and "Deselect All". The Onclick property of these buttons runs code...
0
7857
by: web1110 | last post by:
Hi y'all, I was playing with the NorthWind database, displaying subtables in a DataGrid. It worked fine for 3 levels, but when I added a fourth, I got the following error: These columns don't currently have unique values The initialization code below generates the error on the last statement (dataSet1.Relations.Add(clDataRelation34)). The odd thing is, if I CONTINUE
6
2572
by: Robert Schuldenfrei | last post by:
Dear NG, I have done all I can do with Crystal Reports (CR) using the "pull" mode. I now need to generate data in my application, load a DataSet with that data, and "push" this on to a CR report. In the code listed below, you find a demo DataSet, called MyDataSet, taken from the Bischof book. It runs from a button created in Visual Studio (VS) in a project called Test3. So far it works. The next step is to create a .rpt file in...
9
6265
by: Hasan O. Zavalsiz | last post by:
Hi , i am trying to figure out which approach is better to use . let me explain the scenario. i am using the "Nortwind" database . in this database i have "Customers " table .The following is the two different ways to handle this table. CASE 1 : create a struct that encaplusates table "Customers" columns public struct structCustomers { public string CustomerID;
9
2690
by: HAN(removethis)twister | last post by:
I've tried to create 11 textboxes as variables (not actually visible in the program, not in Windows Form Designer) and have set DataBindings to the text properties of the TextBoxes BUT according to tests I've run, it says that the DataBindings exist, but the IsBinding is set to False, and is ReadOnly (the bindings exist, they just aren't active AND I can't/don't know how to make them active). Is there any way to allow these 11 textboxes'...
0
5014
by: saraDotNet | last post by:
hi everybody , I'm a beginner student in vb.net,and I'm working on a very small project as a homework,and I've some questions which I ought to search for their solutions via any source . My question, I need to make an (Update )button in most of my VB forms,which enable me to update any row elements in the datasource in Access through each form , for example: I've a form about CustomersData as...
17
4587
by: pbd22 | last post by:
Hi. How does one return a range of rows. I know that "Top 5" will return rows 0 - 5 but, how do I get 6 - 10? thanks
0
9738
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11001
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10664
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7894
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7069
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5735
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5919
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4137
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3175
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.