Database query fields

[Bill]

Thanks for the correction. I should check my email more often.
Because I am setting the custom property value of many fields would the line

be

do "set the cRevGeneral[" & quote & theCustomPropName & quote & "] to
> theCustomPropValue" for fld theFldName

????


On 3/6/07 12:12 PM, "Jerry Daniels" <jerry at daniels-mara.com> wrote:

> Correction:
> 
> do "set the cRevGeneral[" & quote & theCustomPropName & quote & "] to
> theCustomPropValue"
> 
> -JD
> 
> 
> On Mar 6, 2007, at 9:54 AM, Jerry Daniels 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
>> 
> 
> _______________________________________________
> 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