Database query fields
Bill
bill at bluewatermaritime.com
Tue Mar 6 11:43:10 EST 2007
Thanks -- I got it:
set the cREVDatabase["Linkcolumn"] of fld theFldName to theFldName
You know it is fun when this stuff works.
On 3/6/07 12:36 PM, "Jerry Daniels" <jerry at daniels-mara.com> wrote:
> You don't need the "do" stuff if your property name is a literal.
>
> On Mar 6, 2007, at 10:32 AM, Bill wrote:
>
>> 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
>>
>>
>>
>> _______________________________________________
>> 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
More information about the use-livecode
mailing list