Re: Using sqldataAdapter wizard has two warnings after running it
From: Brendan Reynolds (brenreyn)
Date: 02/11/05
- Next message: Crisp: "Re: SQL server data into Word?"
- Previous message: Spencer H. Prue: "Re: Using sqldataAdapter wizard has two warnings after running it"
- In reply to: Spencer H. Prue: "Re: Using sqldataAdapter wizard has two warnings after running it"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Feb 2005 15:04:00 -0000
http://www.miswebdesign.com/resources/articles/wrox-beginning-php-4-chapter-3-1.html
http://www.kcl.ac.uk/kis/support/cit/fortran/database/relation.pdf
http://cobweb.businesscollaborator.com/help/sec-8-0.html
-- Brendan Reynolds (MVP) "Spencer H. Prue" <SpencerHPrue@discussions.microsoft.com> wrote in message news:E3EBFB27-FADD-410A-9284-E57ADB00E958@microsoft.com... > By PK you mean the first column of the first table, correct? There is an > option to designate a primary key. I used to have nvarchar as the "PK", > but > the text was getting truncated, so I switched to ntext. By relational > design > you mean the design of my database, am I right? Thanks. > > Spencer > > "William (Bill) Vaughn" wrote: > >> You have something fundamentally wrong with your design if you need to >> use a >> TEXT or NTEXT variable as your primary key. VarChar can be up to 8000 >> bytes >> long, but a PK should be far shorter than that. A PK can also span >> several >> columns, but again, I think you have something else wrong in the >> relational >> design. >> >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> >> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >> news:%23cJHT1lDFHA.4020@TK2MSFTNGP14.phx.gbl... >> > Do you have a primary key designated for these tables? >> > >> > -- >> > ____________________________________ >> > William (Bill) Vaughn >> > Author, Mentor, Consultant >> > Microsoft MVP >> > www.betav.com >> > Please reply only to the newsgroup so that others can benefit. >> > This posting is provided "AS IS" with no warranties, and confers no >> > rights. >> > __________________________________ >> > >> > "Spencer H. Prue" <SpencerHPrue@discussions.microsoft.com> wrote in >> > message news:F664E8EF-56ED-4A2E-A320-6724176EA11D@microsoft.com... >> >>I used the sqldataAdapter wizard and I got the following results. >> >> >> >> generated select statement >> >> generated table mappings >> >> generated insert statement >> >> >> >> generated update statement-could not determine which columns uniquely >> >> identify the rows for "table1" >> >> >> >> generated delete statement-could not determine which columns uniquely >> >> identify the rows for "table1" >> >> >> >> I set Missingmappingaction to Passhrough >> >> Missingschemaaction to Add >> >> >> >> What am I doing wrong? I am using MSDE 2000 for a database. Thanks. >> >> -- >> >> Spencer >> > >> > >> >> >>
- Next message: Crisp: "Re: SQL server data into Word?"
- Previous message: Spencer H. Prue: "Re: Using sqldataAdapter wizard has two warnings after running it"
- In reply to: Spencer H. Prue: "Re: Using sqldataAdapter wizard has two warnings after running it"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
