Field data Assignment
David Thompson
dthmpsn1 at uiuc.edu
Wed Feb 6 06:24:44 PST 2008
>Question: is there a way to store a data item in a field *without*
>using the actual field name?
The Cell command can be used to assign a value to
the active cell. The Set command can be used to
assign a value to a field whose name is specified
by a formula. The formula could simply be a
variable that contains that name.
>
>The simple assignment changes the character of the variable name. And
>the assign( function does the same.
>
>This came up because I had 11 fields from which data was fetched and
>stored and rather than write explicit code for each field, it was
>simple to write a ShortCall section of code and thus eliminate a lot
>of duplicate code. The Field name can easily be put into a variable
>and data fetched in the ShortCall. But the storage of results cannot
>be done by that variable, it turns into a local variable.
Nothing will turn a variable that isn't already
local, into a local. What lead you to the
conclusion that this was happening?
Dave
More information about the Qna
mailing list