Query erros with Update increment (1 Viewer)

kirkm

Registered User.
Local time
Tomorrow, 04:17
Joined
Oct 30, 2008
Messages
1,257
Just a bit puzzled about query behaviour.
I have a table with field "test". In design mode it is indexed Yes (No Duplicates) and Required Yes.

I can successfully run this update query

UPDATE CDDisks SET MyTable.Test = [Test]-1;

But I cannot do this

UPDATE CDDisks SET MyTable.Test = [Test]+1;


Test Field is Datatype Number


Why is that ?
 
Last edited:

Eugene-LS

Registered User.
Local time
Today, 18:17
Joined
Dec 7, 2018
Messages
481
But I cannot do this
UPDATE CDDisks SET MyTable.Test = [Test]+1;
Test Field is Datatype Number
Why is that ?
Try that please:
UPDATE (SELECT Test FROM CDDisks ORDER BY Test DESC) AS UPD SET Test = [Test]+1;
... Just begin from MAX value of [Test] field :)
 
Last edited:

kirkm

Registered User.
Local time
Tomorrow, 04:17
Joined
Oct 30, 2008
Messages
1,257
Thank you -all okay now.
 

Users who are viewing this thread

Top Bottom