[SOLVED] how subtract 2 from all the grades?

[taazz]

which database backend you are using? and is the quote char in the of true a type error?

[Delphilearner]

which database backend you are using? and is the quote char in the of true a type error?

my database is Access

this code working

UPDATE t2 SET math =(math-2)

but when i add the condition i have an error

UPDATE t2 SET math =(math-2) WHERE T1.K=True // the error in T1.k=true

[taazz]

which database backend you are using? and is the quote char in the of true a type error?

my database is Access

this code working

UPDATE t2 SET math =(math-2)

but when i add the condition i have an error

UPDATE t2 SET math =(math-2) WHERE T1.K=True // the error in T1.k=true

You can't use T1 in your where clause unless it is part of the main command you have to make it a subquery something along the lines of

Code: SQL  [Select][+][-]

1.   UPDATE t2 SET math =(math-2) WHERE EXISTS(SELECT 1 FROM T1 WHERE T1.ID = T2.ID AND T1.K =TRUE)
2.  

[Delphilearner]

thank you very much taazz

but you select 1 in ypor code what does it mean?

EXISTS(SELECT 1 FROM T1 WHERE T1.ID = T2.ID AND T1.K =TRUE

solved

[taazz]

thank you very much taazz

but you select 1 in ypor code what does it mean?

EXISTS(SELECT 1 FROM T1 WHERE T1.ID = T2.ID AND T1.K =TRUE

solved

I do not need anything specific returned from the table in question, I simply select to return the number 1 once for every record found, it can be any dummy value.

[Delphilearner]

thank you very much

solved

[howardpc]

Could you edit the title of your thread to include SOLVED? Other users cannot do this for a thread you started.