Database query fields

[Bill]

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