Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a record
Message
From
14/08/2002 19:35:25
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Updating a record
Miscellaneous
Thread ID:
00689781
Message ID:
00689781
Views:
67
Hi All:

I have the following code in the click event of the Save Button.

IF mcheck = 0
thisform.command2.Enabled = .t.
mlcl_doc_nm = FoundNumber.doc_number
if this.caption = "Save"
update memos set Memos.FromDoc = mRefDocDispName,;
Memos.FromDocNum = mLCL_DOC_NM,;
Memos.ToWhom = mToAddress,;
Memos.NameOfPat = mRefPatDispName,;
Memos.HealthNum = mHealthCard,;
Memos.Contents = mNOTES;
WHERE Memos.MemoRefNum = EditThisReferralLetter.MemoRefNum
MESSAGEBOX('Changes have been saved.', 0+64+256,'Information')
ELSE
messagebox ('Some of the fields on this form are empty. Please complete the form.',0+64+256,'Information')
ENDIF
ENDIF
- Ravi

True greatness consists in being great in little things.
- Charles Simmons
Next
Reply
Map
View

Click here to load this message in the networking platform