Database query fields

[Bill]

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