You are here: Re: Strange issue with SQL Table read only in Access « MsSQL Server « IT news, forums, messages
Re: Strange issue with SQL Table read only in Access

Posted by Greg D. Moore \(Strider\) on 04/22/06 18:46

"Rico" <me@you.com> wrote in message news:f2s2g.5832$Fd6.4310@edtnps82...
> Just because I don't know the address, doesn't mean the people that own it
> can sell it (UPDATE People Set Owner=NewOwner).

Congratulations, you've just updated every record in your table to the new
owner.

In other words, you've just sold every house on the block to the same
person.

You need a where clause and in order to pick a SPECIFIC house, you need
something that ID's it uniquely.


>
> "Lyle Fairfield" <lylefairfield@aim.com> wrote in message
> news:1145701034.778574.144660@e56g2000cwe.googlegroups.com...
> > How would you find the house if you didn't know the address?
> >
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация