I have 3 consecutive update statements that have the following in each respective WHERE section:
(MkFrmFunc_Table.Function1 <> "")And(MkFrmFunc_Table.Function2 <> "")
(MkFrmFunc_Table.Function1 = "")And(MkFrmFunc_Table.Function2 <> "")
(MkFrmFunc_Table.Function1 <> "")And(MkFrmFunc_Table.Function2 = "")
Function1 and Function2 are strings that should only be update based on one of the three update statements with the WHERE clauses written above.
But for some reason the only update occurs is based on which ever is listed last. So for the example above, all Function1, whether there is a string there or not, is updated. If I put the first update statement (the one with (MkFrmFunc_Table.Function1 <> "")And(MkFrmFunc_Table.Function2 <> "") in its update section) last, then all Function1 and Function2 are updated. Its like the program is ignoring the where portion of the updates except for which ever is the last one written. Any suggestions?
(MkFrmFunc_Table.Function1 <> "")And(MkFrmFunc_Table.Function2 <> "")
(MkFrmFunc_Table.Function1 = "")And(MkFrmFunc_Table.Function2 <> "")
(MkFrmFunc_Table.Function1 <> "")And(MkFrmFunc_Table.Function2 = "")
Function1 and Function2 are strings that should only be update based on one of the three update statements with the WHERE clauses written above.
But for some reason the only update occurs is based on which ever is listed last. So for the example above, all Function1, whether there is a string there or not, is updated. If I put the first update statement (the one with (MkFrmFunc_Table.Function1 <> "")And(MkFrmFunc_Table.Function2 <> "") in its update section) last, then all Function1 and Function2 are updated. Its like the program is ignoring the where portion of the updates except for which ever is the last one written. Any suggestions?