Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update a field in a record
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00393695
Message ID:
00393933
Views:
18
Hi John,

>How would I go about that ?
>
Something like this:
local llFirstRec
llFirstRec = .T.
SCAN FOR ins_co_nam = "A U L" AND group_code = 'A01'

	if llFirstRec
		llFirstRec = .F.
		REPLACE chkamt with THISFORM.TEXT4.VALUE, ;
			misc_amt WITH THISFORM.TEXT6.VALUE, ;
			gen_misc WITH THISFORM.TEXT7.VALUE
	endif
	REPLACE paiddate WITH THISFORM.TEXT1.VALUE,;
		fromdate WITH THISFORM.TEXT2.VALUE,;
		todate WITH THISFORM.TEXT3.VALUE,;
		chknumb with THISFORM.TEXT5.VALUE,;
		servfee WITH .69

	REPLACE balance WITH amt_pre - servfee,;
		duecompany WITH balance posted with "P"

ENDSCAN
HTH,
Bill Armbrecht
VFP MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform