Re: FN-FORUM: What's the best development platform for creating Web 2.0 business applications?

date posted 21st November 2007 19:16

Hello Graham,

Graham Stark wrote:
> I suppose it's a question of where you do things. If you have an
> auto-increment id field as the main (primary) key, you effectively have
> a logger: all incoming updates are accepted, and you sort out whether
> they're meaningful somewhere else,

I'm sorry, I've read that several times and I can't make head nor tail
of it.

> The idea is, sort out what really makes a record unique (a username,
> perhaps, or a username and an order number) and use that. Let the
> database do the work for you.

UPDATE
Customer
SET
Email = @Email
WHERE
Username = @Username


UPDATE
Customer
SET
Email = @Email
WHERE
Id = @Id


Why do you think these two things are different?

--
Gary
http://www.garyshort.org