Database query fields

Jerry Daniels jerry at daniels-mara.com
Tue Mar 6 11:28:52 EST 2007


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
>




More information about the use-livecode mailing list