[ic] aborting a form insert if record already exists

Brent Kelly interchange-users@icdevgroup.org
Wed Jul 17 21:13:01 2002


Hi all,

I'm a little stumped at present on trying to abort a 'form-based' insert =
if=20
certain conditions exist?

i.e. if i use a form to insert a new record to a table using mv_data_tabl=
e,=20
mv_data_key etc with mv_data_function set to insert, it appears to be=20
performing an update if the record already exists, and overwriting the=20
existing data.=20

Obviously this is not good & so I want to check that the record doesn't=20
already exist, and if it does, abort the insert & display an error messag=
e??

Is it possible to do this thru a mv_click or any other way?

Thanks for any help,

Brent Kelly,
Zeald Ltd.