Re: Database query fields

2007-03-06 Thread Bill 
I spoke to soon. This does set the correct field property but it seems that
in order for the fld to work with the database query it can only be set
manually using the GUI. I can see the property set correctly when calling it
but the GUI doesn't and it doesn't work with the query manager.

I ended up setting each field manually as I ran out of time trying to do it
the fast way. 


On 3/6/07 12:43 PM, "Bill" <[EMAIL PROTECTED]> wrote:

> Thanks -- I got it:
> 
> set the cREVDatabase["Linkcolumn"] of fld theFldName to theFldName
> 


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database query fields

2007-03-06 Thread Bill 
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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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@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@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@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

Re: Database query fields

2007-03-06 Thread Jerry Daniels 

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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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@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@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@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@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@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@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-revo

Re: Database query fields

2007-03-06 Thread Bill 
tried:

 do "set the cRevGeneral["Linkcolumn"] of fld theFldName to theFldName"

Still trying...


On 3/6/07 12:28 PM, "Jerry Daniels" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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@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@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@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@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@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
 ^^

Re: Database query fields

2007-03-06 Thread Jerry Daniels 

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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database query fields

2007-03-06 Thread Bill 
Thanks for the correction. I should check my email more often.
Because I am setting the custom property value of many fields would the line

be

do "set the cRevGeneral[" & quote & theCustomPropName & quote & "] to
> theCustomPropValue" for fld theFldName




On 3/6/07 12:12 PM, "Jerry Daniels" <[EMAIL PROTECTED]> wrote:

> Correction:
> 
> do "set the cRevGeneral[" & quote & theCustomPropName & quote & "] to
> theCustomPropValue"
> 
> -JD
> 
> 
> On Mar 6, 2007, at 9:54 AM, Jerry Daniels 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" <[EMAIL PROTECTED]> 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@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database query fields

2007-03-06 Thread 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database query fields

2007-03-06 Thread Jerry Daniels 

Correction:

do "set the cRevGeneral[" & quote & theCustomPropName & quote & "] to  
theCustomPropValue"


-JD


On Mar 6, 2007, at 9:54 AM, Jerry Daniels 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" <[EMAIL PROTECTED]> 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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database query fields

2007-03-06 Thread 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" <[EMAIL PROTECTED]> 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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database query fields

2007-03-06 Thread Bill 
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" <[EMAIL PROTECTED]> 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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Database query fields

2007-03-05 Thread Bill 
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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution