Hi gang,
SET DEVELOPER FRUSTRATION TO HIGH
I'm pulling what few hairs I have left out on this one. I have an UPDATE-SQL command, executed from a command button on a page of a pageframe, that alters a record in an updateable local view, with multiple items to SET, as follows:
loParent = THIS.Parent
UPDATE ;
vwSubscriberOne ;
SET ;
cLastName = loParent.txtLastName.Value, ;
cFirstName = loParent.txtFirstName.Value, ;
etc. etc. ;
WHERE somecondition
The command refuses to execute, telling me that "Alias txtLastName is not found". A similar INSERT-SQL command, in the same method of the same command button, uses the *identical* loParent.txtLastName.Value reference without a complaint.
What the @#$%^&* am I missing here?
TIA,
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?