Database query fields

[Jerry Daniels]

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
>