select statement

[Soundarya]

hi, can u tell me how to write select statement with the condition. if the condition satisfies, insert values given in the front panel. if it doews not,it should modify the old values to new values given.

its very urgent.

Thanks in Advance

Regards

Soundarya

[MikeS81]

Hi Soundarya,

see the attached example. Depending on the result you have to desice the action (insert or updata or ...).

Mike