[RESOLVED] Is it possible to use 2 clause in one Update sql query using MySQL on VB6?

[cataztrophe]

hello there..
based from the title, is it even posible?
here is some code :

SQL = "UPDATE table_a SET field_a='Completed'" _
                & " WHERE field_b='Succesfull'"
            KonekDb.Execute SQL, , adCmdText

so is that posible to add another clause after

field_b='Succesfull'

?

thnx for beforehand

[jmcilhinney]

If you mean add another WHERE clause then no, it's not possible. You don't need to though because, just like in VB, a Boolean expression in SQL can contain as many conditions as you like, separated by AND and OR operators as appropriate, e.g.

WHERE (Column1 = @ValueA OR Column1 = @ValueB) AND Column2 = @ValueC

[cataztrophe]

If you mean add another WHERE clause then no, it's not possible. You don't need to though because, just like in VB, a Boolean expression in SQL can contain as many conditions as you like, separated by AND and OR operators as appropriate, e.g.

WHERE (Column1 = @ValueA OR Column1 = @ValueB) AND Column2 = @ValueC

i see...
thnx for your explanation, really apreciated.