Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update doesn't work without thisform
Message
From
29/09/2011 15:28:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Update doesn't work without thisform
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01525200
Message ID:
01525200
Views:
121
I do an update with set
UPDATE MyView ;
	SET ;
		Field1 = nValue1, ;
		Field2 = .nSomeValueIHave ;
	WHERE code = nValue3

this gives an error even if there is a WITH in the beginning of that procedure


UPDATE MyView ;
	SET ;
		Field1 = nValue1, ;
		Field2 = thisform.nSomeValueIHave ;
	WHERE code = nValue3

doesn't give an error
What's wrong here?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Next
Reply
Map
View

Click here to load this message in the networking platform