Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter failure
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01056849
Message ID:
01057203
Views:
16
Here are the properties. The two columns that did not update are "mile_post" and "usermp". The column "location" is in the same tabel and took the update.

Thanks for looking.

This is inside a WITH-ENDWITH.
	.Tables = "tstfac, tstpoint"
	.KeyFieldList = "tsfid, tstid"

	.UpdatableFieldList = "usermp, mile_post, location, effdate, active, strcps_rdg, " + ;
							"caseps_rdg, tststrcpsn, maxps, insp_freq, tsfid, tstid"
	.UpdateNameList = "mile_post tsf.mile_post, usermp tsf.usermp, location tstfac.location , effdate tstpoint.effdate, " + ;
					"active tstpoint.active, strcps_rdg tstpoint.strcps_rdg, caseps_rdg tstpoint.caseps_rdg, " + ;
					"tststrcpsn tstpoint.tststrcpsn, maxps tstpoint.maxps, insp_freq tstpoint.insp_freq, " + ;
					"tsfid tstfac.recordid, tstid tstpoint.recordid"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform