Henry,

_tally will tell you how many records updated. What leads you to the conclusion that the update is not succeeding? What is clinic, a table? a local view? a remote view?

I'd guess that the first record in the table is deleted, with SET DELETED ON.

If clinic is a view the change won't make it to the real table until you issue a TableUpdate().

>The following is an update statement in the save button. It gives no error messages, but the table is not updated.
>
>

update clinic set clinic.grop_num = int(mgrop_num)), ;
>	clinic.clnc_name = mclnc_name, ;
>	clinic.address2 = maddress2, ;
>	clinic.address22 = maddrss_22 ,;
>	clinic.city = mcity, ;
>	clinic.province = mprovince, ;
>	clinic.postalcode = mpostalcode, ;
>	clinic.area_phone = marea_phone,;
>	clinic.phone = mphone, ;
>	clinic.area_fax = marea_fax ,;
>	clinic.facsimile = mfacsimile, ;
>	clinic.Gender = mDefaultGender;
>	where recno() = 1