Database query fields

[Jerry Daniels]

You don't need the "do" stuff if your property name is a literal.

On Mar 6, 2007, at 10:32 AM, Bill wrote:

> tried:
>
>      do "set the cRevGeneral["Linkcolumn"] of fld theFldName to  
> theFldName"
>
> Still trying...
>
>
> On 3/6/07 12:28 PM, "Jerry Daniels" <jerry at daniels-mara.com> wrote:
>
>> of fld theFldName
>>
>> On Mar 6, 2007, at 10:23 AM, Bill wrote:
>>
>>> Thanks
>>>
>>> Could the set fld property line look more like this?
>>>
>>> do "set the cRevGeneral[" & quote & theCustomPropName & quote &&
>>> "to theCustomPropValue"] in fld theFieldName
>>>
>>>
>>> On 3/6/07 11:54 AM, "Jerry Daniels" <jerry at daniels-mara.com> wrote:
>>>
>>>> Bill,
>>>>
>>>> I'm not sure you need Galaxy to do the scripting you mention. But,
>>>> could it hurt? I don't think so.
>>>>
>>>> repeat for each line thePropDatum in thePropData
>>>>      put item 1 of thePropDatum into theCustomPropName
>>>>      put item 2 of thePropDatum into theCustomPropValue
>>>>      do "set the cRevGeneral[" & quote & theCustomPropName &  
>>>> quote &&
>>>> "to theCustomPropValue"
>>>> end repeat
>>>>
>>>> See if that helps.
>>>>
>>>> Best,
>>>>
>>>> Jerry Daniels
>>>>
>>>> Makers of Galaxy 1.5
>>>> http://www.daniels-mara.com/new_in_galaxy_1_5.htm
>>>>
>>>>
>>>>
>>>> On Mar 6, 2007, at 9:33 AM, Bill wrote:
>>>>
>>>>> Still trying to figure out how to set the properties of fields  
>>>>> with
>>>>> a "for
>>>>> each" script.
>>>>>
>>>>> I just found out that Galaxy has a property editor which I've  
>>>>> never
>>>>> tried
>>>>> because my version of Galaxy is "Lite". I emailed them about an
>>>>> upgrade as
>>>>> maybe their property editor will solve my problem.
>>>>>
>>>>> I found in the docs how to copy the properties of one field to  
>>>>> many
>>>>> others
>>>>> so that is close to what I am trying to do except that the name
>>>>> of the
>>>>> column in each field will be the same as the name of the field.
>>>>>
>>>>> Bill
>>>>>
>>>>>
>>>>> On 3/5/07 6:12 PM, "Bill" <bill at bluewatermaritime.com> wrote:
>>>>>
>>>>>> Hi
>>>>>>
>>>>>> I know how to manually set database properties (
>>>>>> cRevGeneral["databaseQueryObject"] ) using the property inspector
>>>>>> But I would like to go through about thirty fields with a script
>>>>>> and set the
>>>>>> name of the
>>>>>> Linkcolumn to the same as the fld name
>>>>>> Set the queryobject to "bgnd "Connect"
>>>>>> And set the update after editing to true.
>>>>>>
>>>>>>> From the name of the property it looks like I am changing values
>>>>>>> in an
>>>>>> array.
>>>>>>
>>>>>> Can someone send me some simple script suggestions for this?
>>>>>>
>>>>>> Bill
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> use-revolution mailing list
>>>>>> use-revolution at lists.runrev.com
>>>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>>>> subscription
>>>>>> preferences:
>>>>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>>>
>>>>>             |    |    |
>>>>>            )_)  )_)  )_)
>>>>>           )___))___))___)\
>>>>>          )____)____)_____)\\
>>>>>        _____|____|____|____\\\__
>>>>> -------\                   /--------- http://
>>>>> www.bluewatermaritime.com
>>>>>  ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
>>>>>   ^^^^      ^^^^     ^^^    ^^
>>>>>        ^^^^      ^^^
>>>>>
>>>>> 24 hour cell: (787) 378-6190
>>>>> fax: (787) 809-8426
>>>>>
>>>>> Blue Water Maritime
>>>>> P.O. Box 2087
>>>>> Rio Grande, PR 00745
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> use-revolution mailing list
>>>>> use-revolution at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>>> subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>>>
>>>>
>>>> _______________________________________________
>>>> use-revolution mailing list
>>>> use-revolution at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>> subscription
>>>> preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>>             |    |    |
>>>            )_)  )_)  )_)
>>>           )___))___))___)\
>>>          )____)____)_____)\\
>>>        _____|____|____|____\\\__
>>> -------\                   /--------- http:// 
>>> www.bluewatermaritime.com
>>>  ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
>>>   ^^^^      ^^^^     ^^^    ^^
>>>        ^^^^      ^^^
>>>
>>> 24 hour cell: (787) 378-6190
>>> fax: (787) 809-8426
>>>
>>> Blue Water Maritime
>>> P.O. Box 2087
>>> Rio Grande, PR 00745
>>>
>>>
>>>
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your  
>> subscription
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>             |    |    |
>            )_)  )_)  )_)
>           )___))___))___)\
>          )____)____)_____)\\
>        _____|____|____|____\\\__
> -------\                   /--------- http://www.bluewatermaritime.com
>  ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
>   ^^^^      ^^^^     ^^^    ^^
>        ^^^^      ^^^
>
> 24 hour cell: (787) 378-6190
> fax: (787) 809-8426
>
> Blue Water Maritime
> P.O. Box 2087
> Rio Grande, PR 00745
>
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>