Just spent hours chasing down a bug

[sasguru]

Symptoms were that all the data in one table was being updated with the same values.

Been going round in circles.

Then saw the following SQL lurking amongst a ton of other SQL:

UPDATE tableName
SET col1 = @col1,
col2 = @col2,
col3 = @col3
etc
WHERE primaryKey = primaryKey;


The missing @ on primaryKey parameter!



In the old days before senility and long term alcohol abuse I would have spotted that in seconds.

Trying to learn Access while on the dole, eh?
Admirable.

[NoddY]

I demand a rate cut for such incompetence!

[original PM]

The best sql update issue is where you update a (few) record(s) based on records from another table. If you're not careful you can update all the records.

hmmm bit newbie error that

would not the use of a WHERE statement solve those problems?

[EternalOptimist]

whats the difference between a noobie and a noob ?

[singhr]

why didnt you cut and paste the code into here rather than type it out? Is it to protect your client. eg.

UPDATE mafia_hitlist_2009 etc.

[thunderlizard]

I did something similar in my Access 97 days. Set performance tests running all night with ...where POST_CODE = 'postcode'
instead of ...where POST_CODE = [postcode]

but I was only on about a tenner an hour.

[DimPrawn]

why didnt you cut and paste the code into here rather than type it out? Is it to protect your client. eg.

UPDATE mafia_hitlist_2009 etc.

I'm working on the IR35 database for HMR&C


UPDATE IT_contractors_to_investigate

[sasguru]

I'm working on the IR35 database for HMR&C


UPDATE IT_contractors_to_investigate

A huge collective sigh of relief just went up from CUK as they realised you're doing the coding on this project

[Weltchy]

It's a surprisingly good name for a function call!

If I ever see in a SQL Statement, code to the effect of

UPDATE tableName
SET col1 = etc(@col1),
col2 = @col2,
col3 = @col3
WHERE primaryKey = primaryKey;

Both You and DP are gonna get the blame

[DimPrawn]

A huge collective sigh of relief just went up from CUK as they realised you're doing the coding on this project

I'll have it completed before the next millenium.