Update and delete sql not generated by wizard

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

RobinS
Sat Mar 03 21:23:37 CST 2007

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
Sat Mar 03 22:21:24 CST 2007

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
>>
>>
>
>

Cor
Sat Mar 03 22:42:39 CST 2007

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

"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
>
>

Earl
Sun Mar 04 10:08:04 CST 2007

You need to have a primary key defined.

"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
>
>

Earl
Sun Mar 04 10:11:03 CST 2007

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
>>
>>
>
>

RobinS
Sun Mar 04 11:57:48 CST 2007

And some people, not getting a response, or not getting the response they
want, post their questions more than once.

Robin S.
----------------------------------------
"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
>>>
>>>
>>
>>
>
>

RobinS
Sun Mar 04 11:58:35 CST 2007

Does your table have a primary key?

Robin S.
-----------------------------
"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
>>>
>>>
>>
>>
>
>