|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Update and delete sql not generated by wizardHi
In my vb winform data app with sql server 2005 backend, when in dataset I run the data adapter configuration wizard it generates insert and select sql statements but not delete and update. As a result the data is not updated when changed in form. What is the problem and how can I get the update and delete statements generated? Thanks Regards I could swear I've answered this before. Isn't your data table empty? Did
you try adding data to your tables and regenerating the dataset to see if that was the problem? Robin S. -------------------------------- Show quote "John" <John@nospam.infovis.co.uk> wrote in message news:e90o4RgXHHA.1244@TK2MSFTNGP04.phx.gbl... > Hi > > In my vb winform data app with sql server 2005 backend, when in dataset I > run the data adapter configuration wizard it generates insert and select > sql statements but not delete and update. As a result the data is not > updated when changed in form. What is the problem and how can I get the > update and delete statements generated? > > Thanks > > Regards > > Plenty of data in there. I can insert data just not update. Any ideas?
Thanks Regards Show quote "RobinS" <RobinS@NoSpam.yah.none> wrote in message news:K_ednYxYg8kkpnfYnZ2dnUVZ_r6vnZ2d@comcast.com... >I could swear I've answered this before. Isn't your data table empty? Did >you try adding data to your tables and regenerating the dataset to see if >that was the problem? > > Robin S. > -------------------------------- > "John" <John@nospam.infovis.co.uk> wrote in message > news:e90o4RgXHHA.1244@TK2MSFTNGP04.phx.gbl... >> Hi >> >> In my vb winform data app with sql server 2005 backend, when in dataset I >> run the data adapter configuration wizard it generates insert and select >> sql statements but not delete and update. As a result the data is not >> updated when changed in form. What is the problem and how can I get the >> update and delete statements generated? >> >> Thanks >> >> Regards >> >> > > Does your table have a primary key?
Robin S. ----------------------------- Show quote "John" <John@nospam.infovis.co.uk> wrote in message news:%23xJrXShXHHA.1296@TK2MSFTNGP02.phx.gbl... > Plenty of data in there. I can insert data just not update. Any ideas? > > Thanks > > Regards > > "RobinS" <RobinS@NoSpam.yah.none> wrote in message > news:K_ednYxYg8kkpnfYnZ2dnUVZ_r6vnZ2d@comcast.com... >>I could swear I've answered this before. Isn't your data table empty? Did >>you try adding data to your tables and regenerating the dataset to see if >>that was the problem? >> >> Robin S. >> -------------------------------- >> "John" <John@nospam.infovis.co.uk> wrote in message >> news:e90o4RgXHHA.1244@TK2MSFTNGP04.phx.gbl... >>> Hi >>> >>> In my vb winform data app with sql server 2005 backend, when in dataset >>> I run the data adapter configuration wizard it generates insert and >>> select sql statements but not delete and update. As a result the data >>> is not updated when changed in form. What is the problem and how can I >>> get the update and delete statements generated? >>> >>> Thanks >>> >>> Regards >>> >>> >> >> > > It's funny how the same questions get asked and answered repeatedly on the
forums. While some may say that this is the user's fault, I would say that it is a failure by Microsoft to make the "obvious" truly obvious and to do a better job of explaining the "obvious". Too often, the information being put out is too disjointed. Show quote "RobinS" <RobinS@NoSpam.yah.none> wrote in message news:K_ednYxYg8kkpnfYnZ2dnUVZ_r6vnZ2d@comcast.com... >I could swear I've answered this before. Isn't your data table empty? Did >you try adding data to your tables and regenerating the dataset to see if >that was the problem? > > Robin S. > -------------------------------- > "John" <John@nospam.infovis.co.uk> wrote in message > news:e90o4RgXHHA.1244@TK2MSFTNGP04.phx.gbl... >> Hi >> >> In my vb winform data app with sql server 2005 backend, when in dataset I >> run the data adapter configuration wizard it generates insert and select >> sql statements but not delete and update. As a result the data is not >> updated when changed in form. What is the problem and how can I get the >> update and delete statements generated? >> >> Thanks >> >> Regards >> >> > > And some people, not getting a response, or not getting the response they
want, post their questions more than once. Robin S. ---------------------------------------- Show quote "Earl" <brikshoe@newsgroups.nospam> wrote in message news:uba%23tenXHHA.4396@TK2MSFTNGP06.phx.gbl... > It's funny how the same questions get asked and answered repeatedly on > the forums. While some may say that this is the user's fault, I would say > that it is a failure by Microsoft to make the "obvious" truly obvious and > to do a better job of explaining the "obvious". Too often, the > information being put out is too disjointed. > > "RobinS" <RobinS@NoSpam.yah.none> wrote in message > news:K_ednYxYg8kkpnfYnZ2dnUVZ_r6vnZ2d@comcast.com... >>I could swear I've answered this before. Isn't your data table empty? Did >>you try adding data to your tables and regenerating the dataset to see if >>that was the problem? >> >> Robin S. >> -------------------------------- >> "John" <John@nospam.infovis.co.uk> wrote in message >> news:e90o4RgXHHA.1244@TK2MSFTNGP04.phx.gbl... >>> Hi >>> >>> In my vb winform data app with sql server 2005 backend, when in dataset >>> I run the data adapter configuration wizard it generates insert and >>> select sql statements but not delete and update. As a result the data >>> is not updated when changed in form. What is the problem and how can I >>> get the update and delete statements generated? >>> >>> Thanks >>> >>> Regards >>> >>> >> >> > > John,
I thought that it was when you was using timestamps, because in the other situations I have tried it and it went well, however that was a while ago that I did something with these generated statements. Cor Show quote "John" <John@nospam.infovis.co.uk> schreef in bericht news:e90o4RgXHHA.1244@TK2MSFTNGP04.phx.gbl... > Hi > > In my vb winform data app with sql server 2005 backend, when in dataset I > run the data adapter configuration wizard it generates insert and select > sql statements but not delete and update. As a result the data is not > updated when changed in form. What is the problem and how can I get the > update and delete statements generated? > > Thanks > > Regards > > You need to have a primary key defined.
Show quote "John" <John@nospam.infovis.co.uk> wrote in message news:e90o4RgXHHA.1244@TK2MSFTNGP04.phx.gbl... > Hi > > In my vb winform data app with sql server 2005 backend, when in dataset I > run the data adapter configuration wizard it generates insert and select > sql statements but not delete and update. As a result the data is not > updated when changed in form. What is the problem and how can I get the > update and delete statements generated? > > Thanks > > Regards > >  |
|||||||||||||||||||||||
Other interesting topics