Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Whats wrong with this Update statement?
Message
From
04/01/2003 18:04:32
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Whats wrong with this Update statement?
Miscellaneous
Thread ID:
00738082
Message ID:
00738082
Views:
76
Hi all:

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
Where am I going wrong? TIA.
- 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