Proper way of refreshing forms?

[august]

What is the proper way of refreshing forms?

Prog. sample:

if not empty(IDno)
append blank
replace name with this.txtname.value,;
addr with this.txtaddr.value
endif
thisform.REFRESH

is'nt the right way? but the record i already input is still there? Any suggestion? what is the simple workaround?

thanks,
august

 

[ChrisRChamberlain]

august

if not empty(IDno)
[tab]append blank
[tab]replace name with this.txtname.value,;
[tab][tab]addr with this.txtaddr.value
[tab]this.txtaddr.value = []
endif
thisform.REFRESH

You may want to look at INSERT - SQL as an alternative to to appe blan.

Chris

 

[TomasDill]

If you need to buffer chanes, better bind your controls to table fields (this.txtname.ControlSource = 'name' and this.txtaddr.ControlSource = 'addr'). Set buffering mode for your table to 3 at form Init (function CursorSetProp('Buffering',3) ). Than: When you need to add record, always use 'append blank' BEFORE any data editing. To save data - use tableupdate() function. By such way you may have 100 controls on form, but still do not need to write special code just to clear all fields. They will be cleared automatically after 'append blank', because controls are bound. Note that you will need also to use tablerevert() at the end of working to clear out extra empty record, otherwise cursor will not be closed with 'uncommitted changes' error.

 

[august]

thanks to guys! i have now my first "mini" program.
thank you very very much!!!

a many thanks,
August [sig][/sig]