I can access the nested report through getchild ok but would like to 
change the dataobject specifically based on what the user has requested.

Is this possible? Conventional syntax does not apply... ie 
<child>.dataobject = "xxx"

and modify doesn't seem to offer it when perusing the dw syntax tool options

thanks

using 10.5.2

That gets done by modifying the report on the main DW:
<DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' ")

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/4/2011 11:48 AM, 300ZX wrote:
> I can access the nested report through getchild ok but would like to
> change the dataobject specifically based on what the user has requested.
>
> Is this possible? Conventional syntax does not apply... ie
> <child>.dataobject = "xxx"
>
> and modify doesn't seem to offer it when perusing the dw syntax tool
> options
>
> thanks
>
> using 10.5.2

I had tried that on a whim but didn't include the <reportname> so will 
give that a go...thanks


On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
> That gets done by modifying the report on the main DW:
> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' ")
>
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/4/2011 11:48 AM, 300ZX wrote:
>> I can access the nested report through getchild ok but would like to
>> change the dataobject specifically based on what the user has requested.
>>
>> Is this possible? Conventional syntax does not apply... ie
>> <child>.dataobject = "xxx"
>>
>> and modify doesn't seem to offer it when perusing the dw syntax tool
>> options
>>
>> thanks
>>
>> using 10.5.2

that works great but leads to another problem. I am trying to run 
sharedata against that new dwo but it keeps failing even though I am 
using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it 
works fine which leads me to believe the block might be that I need to 
set the trans object after modifying the dwo. I've tried many syntax 
variations to do so thus far but to no avail

this is what I have...

datawindowchild dwc_original
rc = dw_summary_report.getchild("dw_original", dwc_original)
ls_return = 
dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
ls_return = dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
messagebox("ls_return is", ls_return)

rc = dw_original_form.sharedata(dwc_original)
messagebox("rc is", rc)


what would be the correct syntax?

thanks



On 04/01/11 3:55 PM, 300ZX wrote:
> I had tried that on a whim but didn't include the <reportname> so will
> give that a go...thanks
>
>
> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>> That gets done by modifying the report on the main DW:
>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' ")
>>
>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>> I can access the nested report through getchild ok but would like to
>>> change the dataobject specifically based on what the user has requested.
>>>
>>> Is this possible? Conventional syntax does not apply... ie
>>> <child>.dataobject = "xxx"
>>>
>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>> options
>>>
>>> thanks
>>>
>>> using 10.5.2
>

ls_return = dw_summary_report.Modify("dw_original.settransobject='SQLCA'")

Huh? SetTransObject can be used on a DWC but not as an argument to 
Modify. Betcha ls_return contains something ugly.

dwc_original.settransobject(SQLCA) is more like it.

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/4/2011 4:37 PM, 300ZX wrote:
> that works great but leads to another problem. I am trying to run
> sharedata against that new dwo but it keeps failing even though I am
> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
> works fine which leads me to believe the block might be that I need to
> set the trans object after modifying the dwo. I've tried many syntax
> variations to do so thus far but to no avail
>
> this is what I have...
>
> datawindowchild dwc_original
> rc = dw_summary_report.getchild("dw_original", dwc_original)
> ls_return =
> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
> ls_return = dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
> messagebox("ls_return is", ls_return)
>
> rc = dw_original_form.sharedata(dwc_original)
> messagebox("rc is", rc)
>
>
> what would be the correct syntax?
>
> thanks
>
>
>
> On 04/01/11 3:55 PM, 300ZX wrote:
>> I had tried that on a whim but didn't include the <reportname> so will
>> give that a go...thanks
>>
>>
>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>> That gets done by modifying the report on the main DW:
>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' ")
>>>
>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>> I can access the nested report through getchild ok but would like to
>>>> change the dataobject specifically based on what the user has
>>>> requested.
>>>>
>>>> Is this possible? Conventional syntax does not apply... ie
>>>> <child>.dataobject = "xxx"
>>>>
>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>> options
>>>>
>>>> thanks
>>>>
>>>> using 10.5.2
>>
>

Well like I said I was trying many variations on the syntax out of 
desperation because there is no clear example within the help or the 
syntax generator. What adds to the confusion is some of the variations I 
concocted do not throw errors such as these two examples:

ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")

The only indicator I get that they failed is because the subsequent 
sharedata call fails


dwc_original.setransobject(SQLCA) was the first thing I tried and that 
returns -1 so that is why I thought I would have to go the modify route


On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
> ls_return = dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>
> Huh? SetTransObject can be used on a DWC but not as an argument to
> Modify. Betcha ls_return contains something ugly.
>
> dwc_original.settransobject(SQLCA) is more like it.
>
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/4/2011 4:37 PM, 300ZX wrote:
>> that works great but leads to another problem. I am trying to run
>> sharedata against that new dwo but it keeps failing even though I am
>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
>> works fine which leads me to believe the block might be that I need to
>> set the trans object after modifying the dwo. I've tried many syntax
>> variations to do so thus far but to no avail
>>
>> this is what I have...
>>
>> datawindowchild dwc_original
>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>> ls_return =
>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>> ls_return =
>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>> messagebox("ls_return is", ls_return)
>>
>> rc = dw_original_form.sharedata(dwc_original)
>> messagebox("rc is", rc)
>>
>>
>> what would be the correct syntax?
>>
>> thanks
>>
>>
>>
>> On 04/01/11 3:55 PM, 300ZX wrote:
>>> I had tried that on a whim but didn't include the <reportname> so will
>>> give that a go...thanks
>>>
>>>
>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>> That gets done by modifying the report on the main DW:
>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>> name>' ")
>>>>
>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>> Product Enhancement Requests:
>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>
>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>> I can access the nested report through getchild ok but would like to
>>>>> change the dataobject specifically based on what the user has
>>>>> requested.
>>>>>
>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>> <child>.dataobject = "xxx"
>>>>>
>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>> options
>>>>>
>>>>> thanks
>>>>>
>>>>> using 10.5.2
>>>
>>

NPFW Modify can work that way.
Normally when a dataobject is changed SetTransObject will be required as 
well.
What did GetChild return?

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/5/2011 12:44 AM, 300ZX wrote:
> Well like I said I was trying many variations on the syntax out of
> desperation because there is no clear example within the help or the
> syntax generator. What adds to the confusion is some of the variations I
> concocted do not throw errors such as these two examples:
>
> ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
> ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")
>
> The only indicator I get that they failed is because the subsequent
> sharedata call fails
>
>
> dwc_original.setransobject(SQLCA) was the first thing I tried and that
> returns -1 so that is why I thought I would have to go the modify route
>
>
> On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
>> ls_return =
>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>
>> Huh? SetTransObject can be used on a DWC but not as an argument to
>> Modify. Betcha ls_return contains something ugly.
>>
>> dwc_original.settransobject(SQLCA) is more like it.
>>
>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> On 1/4/2011 4:37 PM, 300ZX wrote:
>>> that works great but leads to another problem. I am trying to run
>>> sharedata against that new dwo but it keeps failing even though I am
>>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
>>> works fine which leads me to believe the block might be that I need to
>>> set the trans object after modifying the dwo. I've tried many syntax
>>> variations to do so thus far but to no avail
>>>
>>> this is what I have...
>>>
>>> datawindowchild dwc_original
>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>> ls_return =
>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>> ls_return =
>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>> messagebox("ls_return is", ls_return)
>>>
>>> rc = dw_original_form.sharedata(dwc_original)
>>> messagebox("rc is", rc)
>>>
>>>
>>> what would be the correct syntax?
>>>
>>> thanks
>>>
>>>
>>>
>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>> I had tried that on a whim but didn't include the <reportname> so will
>>>> give that a go...thanks
>>>>
>>>>
>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>> That gets done by modifying the report on the main DW:
>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>> name>' ")
>>>>>
>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>> Product Enhancement Requests:
>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>
>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>> I can access the nested report through getchild ok but would like to
>>>>>> change the dataobject specifically based on what the user has
>>>>>> requested.
>>>>>>
>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>> <child>.dataobject = "xxx"
>>>>>>
>>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>>> options
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>> using 10.5.2
>>>>
>>>
>

Try to call the GetChild AFTER the Modify statement. Also, take a look at 
the "rc" value after that.
Maybe the reference to the report is being invalidated with the Modify().

"300ZX" <xx@xx> wrote in message news:4d23931a$1@forums-1-dub...
> that works great but leads to another problem. I am trying to run 
> sharedata against that new dwo but it keeps failing even though I am using 
> exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it works 
> fine which leads me to believe the block might be that I need to set the 
> trans object after modifying the dwo. I've tried many syntax variations to 
> do so thus far but to no avail
>
> this is what I have...
>
> datawindowchild dwc_original
> rc = dw_summary_report.getchild("dw_original", dwc_original)
> ls_return = 
> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
> ls_return = dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
> messagebox("ls_return is", ls_return)
>
> rc = dw_original_form.sharedata(dwc_original)
> messagebox("rc is", rc)
>
>
> what would be the correct syntax?
>
> thanks
>
>
>
> On 04/01/11 3:55 PM, 300ZX wrote:
>> I had tried that on a whim but didn't include the <reportname> so will
>> give that a go...thanks
>>
>>
>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>> That gets done by modifying the report on the main DW:
>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' ")
>>>
>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>> I can access the nested report through getchild ok but would like to
>>>> change the dataobject specifically based on what the user has 
>>>> requested.
>>>>
>>>> Is this possible? Conventional syntax does not apply... ie
>>>> <child>.dataobject = "xxx"
>>>>
>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>> options
>>>>
>>>> thanks
>>>>
>>>> using 10.5.2
>>
> 

And alternatively to the Modify statement you also have the dot notation:

dw_summary_report.Object.dw_original.DataObject = 'd_hazmat_add_entry'



"Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com> wrote in message 
news:4d243e0c$1@forums-1-dub...
> Try to call the GetChild AFTER the Modify statement. Also, take a look at 
> the "rc" value after that.
> Maybe the reference to the report is being invalidated with the Modify().
>
> "300ZX" <xx@xx> wrote in message news:4d23931a$1@forums-1-dub...
>> that works great but leads to another problem. I am trying to run 
>> sharedata against that new dwo but it keeps failing even though I am 
>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it 
>> works fine which leads me to believe the block might be that I need to 
>> set the trans object after modifying the dwo. I've tried many syntax 
>> variations to do so thus far but to no avail
>>
>> this is what I have...
>>
>> datawindowchild dwc_original
>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>> ls_return = 
>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>> ls_return = 
>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>> messagebox("ls_return is", ls_return)
>>
>> rc = dw_original_form.sharedata(dwc_original)
>> messagebox("rc is", rc)
>>
>>
>> what would be the correct syntax?
>>
>> thanks
>>
>>
>>
>> On 04/01/11 3:55 PM, 300ZX wrote:
>>> I had tried that on a whim but didn't include the <reportname> so will
>>> give that a go...thanks
>>>
>>>
>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>> That gets done by modifying the report on the main DW:
>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' 
>>>> ")
>>>>
>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>> Product Enhancement Requests:
>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>
>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>> I can access the nested report through getchild ok but would like to
>>>>> change the dataobject specifically based on what the user has 
>>>>> requested.
>>>>>
>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>> <child>.dataobject = "xxx"
>>>>>
>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>> options
>>>>>
>>>>> thanks
>>>>>
>>>>> using 10.5.2
>>>
>>
>
> 

just curious what does NPFW stand for? is that a typo because nothing 
found on google

On 05/01/11 1:19 AM, Jerry Siegel [TeamSybase] wrote:
> NPFW Modify can work that way.
> Normally when a dataobject is changed SetTransObject will be required as
> well.
> What did GetChild return?
>
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/5/2011 12:44 AM, 300ZX wrote:
>> Well like I said I was trying many variations on the syntax out of
>> desperation because there is no clear example within the help or the
>> syntax generator. What adds to the confusion is some of the variations I
>> concocted do not throw errors such as these two examples:
>>
>> ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
>> ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")
>>
>> The only indicator I get that they failed is because the subsequent
>> sharedata call fails
>>
>>
>> dwc_original.setransobject(SQLCA) was the first thing I tried and that
>> returns -1 so that is why I thought I would have to go the modify route
>>
>>
>> On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
>>> ls_return =
>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>
>>> Huh? SetTransObject can be used on a DWC but not as an argument to
>>> Modify. Betcha ls_return contains something ugly.
>>>
>>> dwc_original.settransobject(SQLCA) is more like it.
>>>
>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> On 1/4/2011 4:37 PM, 300ZX wrote:
>>>> that works great but leads to another problem. I am trying to run
>>>> sharedata against that new dwo but it keeps failing even though I am
>>>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
>>>> works fine which leads me to believe the block might be that I need to
>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>> variations to do so thus far but to no avail
>>>>
>>>> this is what I have...
>>>>
>>>> datawindowchild dwc_original
>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>> ls_return =
>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>> ls_return =
>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>> messagebox("ls_return is", ls_return)
>>>>
>>>> rc = dw_original_form.sharedata(dwc_original)
>>>> messagebox("rc is", rc)
>>>>
>>>>
>>>> what would be the correct syntax?
>>>>
>>>> thanks
>>>>
>>>>
>>>>
>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>> I had tried that on a whim but didn't include the <reportname> so will
>>>>> give that a go...thanks
>>>>>
>>>>>
>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>> That gets done by modifying the report on the main DW:
>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>>> name>' ")
>>>>>>
>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>> Product Enhancement Requests:
>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>
>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>> I can access the nested report through getchild ok but would like to
>>>>>>> change the dataobject specifically based on what the user has
>>>>>>> requested.
>>>>>>>
>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>> <child>.dataobject = "xxx"
>>>>>>>
>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>>>> options
>>>>>>>
>>>>>>> thanks
>>>>>>>
>>>>>>> using 10.5.2
>>>>>
>>>>
>>

Good point, will let you know what I discover

On 05/01/11 4:46 AM, Ivaylo Ivanov wrote:
> Try to call the GetChild AFTER the Modify statement. Also, take a look at
> the "rc" value after that.
> Maybe the reference to the report is being invalidated with the Modify().
>
> "300ZX"<xx@xx>  wrote in message news:4d23931a$1@forums-1-dub...
>> that works great but leads to another problem. I am trying to run
>> sharedata against that new dwo but it keeps failing even though I am using
>> exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it works
>> fine which leads me to believe the block might be that I need to set the
>> trans object after modifying the dwo. I've tried many syntax variations to
>> do so thus far but to no avail
>>
>> this is what I have...
>>
>> datawindowchild dwc_original
>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>> ls_return =
>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>> ls_return = dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>> messagebox("ls_return is", ls_return)
>>
>> rc = dw_original_form.sharedata(dwc_original)
>> messagebox("rc is", rc)
>>
>>
>> what would be the correct syntax?
>>
>> thanks
>>
>>
>>
>> On 04/01/11 3:55 PM, 300ZX wrote:
>>> I had tried that on a whim but didn't include the<reportname>  so will
>>> give that a go...thanks
>>>
>>>
>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>> That gets done by modifying the report on the main DW:
>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' ")
>>>>
>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>> Product Enhancement Requests:
>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>
>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>> I can access the nested report through getchild ok but would like to
>>>>> change the dataobject specifically based on what the user has
>>>>> requested.
>>>>>
>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>> <child>.dataobject = "xxx"
>>>>>
>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>> options
>>>>>
>>>>> thanks
>>>>>
>>>>> using 10.5.2
>>>
>>
>
>

woot woot, back in business.

getchild must be called after the dataobect is altered.....which makes 
sense now that I think about it. I guess I had my head buried too deep 
in the syntax mud

BTW dot notation and modify work equally well when changing the dataobject

Thanks to you and Jerry for all your help



On 05/01/11 4:46 AM, Ivaylo Ivanov wrote:
> Try to call the GetChild AFTER the Modify statement. Also, take a look at
> the "rc" value after that.
> Maybe the reference to the report is being invalidated with the Modify().
>
> "300ZX"<xx@xx>  wrote in message news:4d23931a$1@forums-1-dub...
>> that works great but leads to another problem. I am trying to run
>> sharedata against that new dwo but it keeps failing even though I am using
>> exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it works
>> fine which leads me to believe the block might be that I need to set the
>> trans object after modifying the dwo. I've tried many syntax variations to
>> do so thus far but to no avail
>>
>> this is what I have...
>>
>> datawindowchild dwc_original
>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>> ls_return =
>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>> ls_return = dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>> messagebox("ls_return is", ls_return)
>>
>> rc = dw_original_form.sharedata(dwc_original)
>> messagebox("rc is", rc)
>>
>>
>> what would be the correct syntax?
>>
>> thanks
>>
>>
>>
>> On 04/01/11 3:55 PM, 300ZX wrote:
>>> I had tried that on a whim but didn't include the<reportname>  so will
>>> give that a go...thanks
>>>
>>>
>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>> That gets done by modifying the report on the main DW:
>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>' ")
>>>>
>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>> Product Enhancement Requests:
>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>
>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>> I can access the nested report through getchild ok but would like to
>>>>> change the dataobject specifically based on what the user has
>>>>> requested.
>>>>>
>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>> <child>.dataobject = "xxx"
>>>>>
>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>> options
>>>>>
>>>>> thanks
>>>>>
>>>>> using 10.5.2
>>>
>>
>
>

;-) No Possible Freaking Way

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/5/2011 9:04 AM, 300ZX wrote:
> just curious what does NPFW stand for? is that a typo because nothing
> found on google
>
> On 05/01/11 1:19 AM, Jerry Siegel [TeamSybase] wrote:
>> NPFW Modify can work that way.
>> Normally when a dataobject is changed SetTransObject will be required as
>> well.
>> What did GetChild return?
>>
>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> On 1/5/2011 12:44 AM, 300ZX wrote:
>>> Well like I said I was trying many variations on the syntax out of
>>> desperation because there is no clear example within the help or the
>>> syntax generator. What adds to the confusion is some of the variations I
>>> concocted do not throw errors such as these two examples:
>>>
>>> ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
>>> ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")
>>>
>>> The only indicator I get that they failed is because the subsequent
>>> sharedata call fails
>>>
>>>
>>> dwc_original.setransobject(SQLCA) was the first thing I tried and that
>>> returns -1 so that is why I thought I would have to go the modify route
>>>
>>>
>>> On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
>>>> ls_return =
>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>
>>>> Huh? SetTransObject can be used on a DWC but not as an argument to
>>>> Modify. Betcha ls_return contains something ugly.
>>>>
>>>> dwc_original.settransobject(SQLCA) is more like it.
>>>>
>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>> Product Enhancement Requests:
>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>
>>>> On 1/4/2011 4:37 PM, 300ZX wrote:
>>>>> that works great but leads to another problem. I am trying to run
>>>>> sharedata against that new dwo but it keeps failing even though I am
>>>>> using exact dwo's. If I manually set the dwo to
>>>>> 'd_hazmat_add_entry' it
>>>>> works fine which leads me to believe the block might be that I need to
>>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>>> variations to do so thus far but to no avail
>>>>>
>>>>> this is what I have...
>>>>>
>>>>> datawindowchild dwc_original
>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>>
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>> messagebox("ls_return is", ls_return)
>>>>>
>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>> messagebox("rc is", rc)
>>>>>
>>>>>
>>>>> what would be the correct syntax?
>>>>>
>>>>> thanks
>>>>>
>>>>>
>>>>>
>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>> I had tried that on a whim but didn't include the <reportname> so
>>>>>> will
>>>>>> give that a go...thanks
>>>>>>
>>>>>>
>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>>>> name>' ")
>>>>>>>
>>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>>> Product Enhancement Requests:
>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>
>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>> I can access the nested report through getchild ok but would
>>>>>>>> like to
>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>> requested.
>>>>>>>>
>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>
>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax
>>>>>>>> tool
>>>>>>>> options
>>>>>>>>
>>>>>>>> thanks
>>>>>>>>
>>>>>>>> using 10.5.2
>>>>>>
>>>>>
>>>
>

I don't recommend dot notation for single values. It generates lots of 
overhead behind the scenes even though it looks like a simple assignment 
statement, and fails hard at run-time.
Use functions whenever possible and always check the return code. 
Finagle http://en.wikipedia.org/wiki/Finagle%27s_law was an optimist!

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/5/2011 4:53 AM, Ivaylo Ivanov wrote:
> And alternatively to the Modify statement you also have the dot notation:
>
> dw_summary_report.Object.dw_original.DataObject = 'd_hazmat_add_entry'
>
>
>
> "Ivaylo Ivanov"<n0_S_p_a_m_i.ivanov@isy-dc.com>  wrote in message
> news:4d243e0c$1@forums-1-dub...
>> Try to call the GetChild AFTER the Modify statement. Also, take a look at
>> the "rc" value after that.
>> Maybe the reference to the report is being invalidated with the Modify().
>>
>> "300ZX"<xx@xx>  wrote in message news:4d23931a$1@forums-1-dub...
>>> that works great but leads to another problem. I am trying to run
>>> sharedata against that new dwo but it keeps failing even though I am
>>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
>>> works fine which leads me to believe the block might be that I need to
>>> set the trans object after modifying the dwo. I've tried many syntax
>>> variations to do so thus far but to no avail
>>>
>>> this is what I have...
>>>
>>> datawindowchild dwc_original
>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>> ls_return =
>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>> ls_return =
>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>> messagebox("ls_return is", ls_return)
>>>
>>> rc = dw_original_form.sharedata(dwc_original)
>>> messagebox("rc is", rc)
>>>
>>>
>>> what would be the correct syntax?
>>>
>>> thanks
>>>
>>>
>>>
>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>> I had tried that on a whim but didn't include the<reportname>  so will
>>>> give that a go...thanks
>>>>
>>>>
>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>> That gets done by modifying the report on the main DW:
>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>'
>>>>> ")
>>>>>
>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>> Product Enhancement Requests:
>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>
>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>> I can access the nested report through getchild ok but would like to
>>>>>> change the dataobject specifically based on what the user has
>>>>>> requested.
>>>>>>
>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>> <child>.dataobject = "xxx"
>>>>>>
>>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>>> options
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>> using 10.5.2
>>>>
>>>
>>
>>
>
>

I agree, sticking with the modify....also FYI setransobject is not 
required to perform the sharedata

On 05/01/11 12:03 PM, Jerry Siegel [TeamSybase] wrote:
> I don't recommend dot notation for single values. It generates lots of
> overhead behind the scenes even though it looks like a simple assignment
> statement, and fails hard at run-time.
> Use functions whenever possible and always check the return code.
> Finagle http://en.wikipedia.org/wiki/Finagle%27s_law was an optimist!
>
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/5/2011 4:53 AM, Ivaylo Ivanov wrote:
>> And alternatively to the Modify statement you also have the dot notation:
>>
>> dw_summary_report.Object.dw_original.DataObject = 'd_hazmat_add_entry'
>>
>>
>>
>> "Ivaylo Ivanov"<n0_S_p_a_m_i.ivanov@isy-dc.com> wrote in message
>> news:4d243e0c$1@forums-1-dub...
>>> Try to call the GetChild AFTER the Modify statement. Also, take a
>>> look at
>>> the "rc" value after that.
>>> Maybe the reference to the report is being invalidated with the
>>> Modify().
>>>
>>> "300ZX"<xx@xx> wrote in message news:4d23931a$1@forums-1-dub...
>>>> that works great but leads to another problem. I am trying to run
>>>> sharedata against that new dwo but it keeps failing even though I am
>>>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
>>>> works fine which leads me to believe the block might be that I need to
>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>> variations to do so thus far but to no avail
>>>>
>>>> this is what I have...
>>>>
>>>> datawindowchild dwc_original
>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>> ls_return =
>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>> ls_return =
>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>> messagebox("ls_return is", ls_return)
>>>>
>>>> rc = dw_original_form.sharedata(dwc_original)
>>>> messagebox("rc is", rc)
>>>>
>>>>
>>>> what would be the correct syntax?
>>>>
>>>> thanks
>>>>
>>>>
>>>>
>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>> I had tried that on a whim but didn't include the<reportname> so will
>>>>> give that a go...thanks
>>>>>
>>>>>
>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>> That gets done by modifying the report on the main DW:
>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>'
>>>>>> ")
>>>>>>
>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>> Product Enhancement Requests:
>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>
>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>> I can access the nested report through getchild ok but would like to
>>>>>>> change the dataobject specifically based on what the user has
>>>>>>> requested.
>>>>>>>
>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>> <child>.dataobject = "xxx"
>>>>>>>
>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>>>> options
>>>>>>>
>>>>>>> thanks
>>>>>>>
>>>>>>> using 10.5.2
>>>>>
>>>>
>>>
>>>
>>
>>

must be your own<g>......thanks again for your help on this


On 05/01/11 11:57 AM, Jerry Siegel [TeamSybase] wrote:
> ;-) No Possible Freaking Way
>
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/5/2011 9:04 AM, 300ZX wrote:
>> just curious what does NPFW stand for? is that a typo because nothing
>> found on google
>>
>> On 05/01/11 1:19 AM, Jerry Siegel [TeamSybase] wrote:
>>> NPFW Modify can work that way.
>>> Normally when a dataobject is changed SetTransObject will be required as
>>> well.
>>> What did GetChild return?
>>>
>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> On 1/5/2011 12:44 AM, 300ZX wrote:
>>>> Well like I said I was trying many variations on the syntax out of
>>>> desperation because there is no clear example within the help or the
>>>> syntax generator. What adds to the confusion is some of the
>>>> variations I
>>>> concocted do not throw errors such as these two examples:
>>>>
>>>> ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
>>>> ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")
>>>>
>>>> The only indicator I get that they failed is because the subsequent
>>>> sharedata call fails
>>>>
>>>>
>>>> dwc_original.setransobject(SQLCA) was the first thing I tried and that
>>>> returns -1 so that is why I thought I would have to go the modify route
>>>>
>>>>
>>>> On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>
>>>>> Huh? SetTransObject can be used on a DWC but not as an argument to
>>>>> Modify. Betcha ls_return contains something ugly.
>>>>>
>>>>> dwc_original.settransobject(SQLCA) is more like it.
>>>>>
>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>> Product Enhancement Requests:
>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>
>>>>> On 1/4/2011 4:37 PM, 300ZX wrote:
>>>>>> that works great but leads to another problem. I am trying to run
>>>>>> sharedata against that new dwo but it keeps failing even though I am
>>>>>> using exact dwo's. If I manually set the dwo to
>>>>>> 'd_hazmat_add_entry' it
>>>>>> works fine which leads me to believe the block might be that I
>>>>>> need to
>>>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>>>> variations to do so thus far but to no avail
>>>>>>
>>>>>> this is what I have...
>>>>>>
>>>>>> datawindowchild dwc_original
>>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>>> ls_return =
>>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>>>
>>>>>>
>>>>>> ls_return =
>>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>> messagebox("ls_return is", ls_return)
>>>>>>
>>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>>> messagebox("rc is", rc)
>>>>>>
>>>>>>
>>>>>> what would be the correct syntax?
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>>> I had tried that on a whim but didn't include the <reportname> so
>>>>>>> will
>>>>>>> give that a go...thanks
>>>>>>>
>>>>>>>
>>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>>>>> name>' ")
>>>>>>>>
>>>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>>>> Product Enhancement Requests:
>>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>>
>>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>>> I can access the nested report through getchild ok but would
>>>>>>>>> like to
>>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>>> requested.
>>>>>>>>>
>>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>>
>>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax
>>>>>>>>> tool
>>>>>>>>> options
>>>>>>>>>
>>>>>>>>> thanks
>>>>>>>>>
>>>>>>>>> using 10.5.2
>>>>>>>
>>>>>>
>>>>
>>

That's correct - Retrieve() [and many other functions] gets passed back 
to the primary DW.

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/5/2011 12:35 PM, 300ZX wrote:
> I agree, sticking with the modify....also FYI setransobject is not
> required to perform the sharedata
>
> On 05/01/11 12:03 PM, Jerry Siegel [TeamSybase] wrote:
>> I don't recommend dot notation for single values. It generates lots of
>> overhead behind the scenes even though it looks like a simple assignment
>> statement, and fails hard at run-time.
>> Use functions whenever possible and always check the return code.
>> Finagle http://en.wikipedia.org/wiki/Finagle%27s_law was an optimist!
>>
>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> On 1/5/2011 4:53 AM, Ivaylo Ivanov wrote:
>>> And alternatively to the Modify statement you also have the dot
>>> notation:
>>>
>>> dw_summary_report.Object.dw_original.DataObject = 'd_hazmat_add_entry'
>>>
>>>
>>>
>>> "Ivaylo Ivanov"<n0_S_p_a_m_i.ivanov@isy-dc.com> wrote in message
>>> news:4d243e0c$1@forums-1-dub...
>>>> Try to call the GetChild AFTER the Modify statement. Also, take a
>>>> look at
>>>> the "rc" value after that.
>>>> Maybe the reference to the report is being invalidated with the
>>>> Modify().
>>>>
>>>> "300ZX"<xx@xx> wrote in message news:4d23931a$1@forums-1-dub...
>>>>> that works great but leads to another problem. I am trying to run
>>>>> sharedata against that new dwo but it keeps failing even though I am
>>>>> using exact dwo's. If I manually set the dwo to
>>>>> 'd_hazmat_add_entry' it
>>>>> works fine which leads me to believe the block might be that I need to
>>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>>> variations to do so thus far but to no avail
>>>>>
>>>>> this is what I have...
>>>>>
>>>>> datawindowchild dwc_original
>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>>
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>> messagebox("ls_return is", ls_return)
>>>>>
>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>> messagebox("rc is", rc)
>>>>>
>>>>>
>>>>> what would be the correct syntax?
>>>>>
>>>>> thanks
>>>>>
>>>>>
>>>>>
>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>> I had tried that on a whim but didn't include the<reportname> so will
>>>>>> give that a go...thanks
>>>>>>
>>>>>>
>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>>>> name>'
>>>>>>> ")
>>>>>>>
>>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>>> Product Enhancement Requests:
>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>
>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>> I can access the nested report through getchild ok but would
>>>>>>>> like to
>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>> requested.
>>>>>>>>
>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>
>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax
>>>>>>>> tool
>>>>>>>> options
>>>>>>>>
>>>>>>>> thanks
>>>>>>>>
>>>>>>>> using 10.5.2
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>

Yeah, I don't like it too, but I'd imagine GetChild failing with nested 
reports containing nested reports (aka second-level GetChild). You can only 
call it to get first-level children of the report.

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo.com> wrote in message 
news:4d24a470@forums-1-dub...
>I don't recommend dot notation for single values. It generates lots of 
>overhead behind the scenes even though it looks like a simple assignment 
>statement, and fails hard at run-time.
> Use functions whenever possible and always check the return code. Finagle 
> http://en.wikipedia.org/wiki/Finagle%27s_law was an optimist!
>
> Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/5/2011 4:53 AM, Ivaylo Ivanov wrote:
>> And alternatively to the Modify statement you also have the dot notation:
>>
>> dw_summary_report.Object.dw_original.DataObject = 'd_hazmat_add_entry'
>>
>>
>>
>> "Ivaylo Ivanov"<n0_S_p_a_m_i.ivanov@isy-dc.com>  wrote in message
>> news:4d243e0c$1@forums-1-dub...
>>> Try to call the GetChild AFTER the Modify statement. Also, take a look 
>>> at
>>> the "rc" value after that.
>>> Maybe the reference to the report is being invalidated with the 
>>> Modify().
>>>
>>> "300ZX"<xx@xx>  wrote in message news:4d23931a$1@forums-1-dub...
>>>> that works great but leads to another problem. I am trying to run
>>>> sharedata against that new dwo but it keeps failing even though I am
>>>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
>>>> works fine which leads me to believe the block might be that I need to
>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>> variations to do so thus far but to no avail
>>>>
>>>> this is what I have...
>>>>
>>>> datawindowchild dwc_original
>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>> ls_return =
>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>> ls_return =
>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>> messagebox("ls_return is", ls_return)
>>>>
>>>> rc = dw_original_form.sharedata(dwc_original)
>>>> messagebox("rc is", rc)
>>>>
>>>>
>>>> what would be the correct syntax?
>>>>
>>>> thanks
>>>>
>>>>
>>>>
>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>> I had tried that on a whim but didn't include the<reportname>  so will
>>>>> give that a go...thanks
>>>>>
>>>>>
>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>> That gets done by modifying the report on the main DW:
>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>'
>>>>>> ")
>>>>>>
>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>> Product Enhancement Requests:
>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>
>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>> I can access the nested report through getchild ok but would like to
>>>>>>> change the dataobject specifically based on what the user has
>>>>>>> requested.
>>>>>>>
>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>> <child>.dataobject = "xxx"
>>>>>>>
>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>>>> options
>>>>>>>
>>>>>>> thanks
>>>>>>>
>>>>>>> using 10.5.2
>>>>>
>>>>
>>>
>>>
>>
>> 

I agree - dot notation is sometimes the only available method. GetChild 
is a method of DataWindowChild, but of course does not work on nested 
reports. Pity, nested reports can be a very useful tool.

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/5/2011 3:48 PM, Ivaylo Ivanov wrote:
> Yeah, I don't like it too, but I'd imagine GetChild failing with nested
> reports containing nested reports (aka second-level GetChild). You can only
> call it to get first-level children of the report.
>
> "Jerry Siegel [TeamSybase]"<jNOsSPAMsiegel@yahoo.com>  wrote in message
> news:4d24a470@forums-1-dub...
>> I don't recommend dot notation for single values. It generates lots of
>> overhead behind the scenes even though it looks like a simple assignment
>> statement, and fails hard at run-time.
>> Use functions whenever possible and always check the return code. Finagle
>> http://en.wikipedia.org/wiki/Finagle%27s_law was an optimist!
>>
>> Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> On 1/5/2011 4:53 AM, Ivaylo Ivanov wrote:
>>> And alternatively to the Modify statement you also have the dot notation:
>>>
>>> dw_summary_report.Object.dw_original.DataObject = 'd_hazmat_add_entry'
>>>
>>>
>>>
>>> "Ivaylo Ivanov"<n0_S_p_a_m_i.ivanov@isy-dc.com>   wrote in message
>>> news:4d243e0c$1@forums-1-dub...
>>>> Try to call the GetChild AFTER the Modify statement. Also, take a look
>>>> at
>>>> the "rc" value after that.
>>>> Maybe the reference to the report is being invalidated with the
>>>> Modify().
>>>>
>>>> "300ZX"<xx@xx>   wrote in message news:4d23931a$1@forums-1-dub...
>>>>> that works great but leads to another problem. I am trying to run
>>>>> sharedata against that new dwo but it keeps failing even though I am
>>>>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' it
>>>>> works fine which leads me to believe the block might be that I need to
>>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>>> variations to do so thus far but to no avail
>>>>>
>>>>> this is what I have...
>>>>>
>>>>> datawindowchild dwc_original
>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>> messagebox("ls_return is", ls_return)
>>>>>
>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>> messagebox("rc is", rc)
>>>>>
>>>>>
>>>>> what would be the correct syntax?
>>>>>
>>>>> thanks
>>>>>
>>>>>
>>>>>
>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>> I had tried that on a whim but didn't include the<reportname>   so will
>>>>>> give that a go...thanks
>>>>>>
>>>>>>
>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject name>'
>>>>>>> ")
>>>>>>>
>>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>>> Product Enhancement Requests:
>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>
>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>> I can access the nested report through getchild ok but would like to
>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>> requested.
>>>>>>>>
>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>
>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax tool
>>>>>>>> options
>>>>>>>>
>>>>>>>> thanks
>>>>>>>>
>>>>>>>> using 10.5.2
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>
>

There are some additional restrictions with DataWindowChilds like 
GetFullState/SetFullState being not available for them as well. ;-)


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo.com> wrote in message 
news:4d24df1d$1@forums-1-dub...
>I agree - dot notation is sometimes the only available method. GetChild is 
>a method of DataWindowChild, but of course does not work on nested reports. 
>Pity, nested reports can be a very useful tool.
>
> Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/5/2011 3:48 PM, Ivaylo Ivanov wrote:
>> Yeah, I don't like it too, but I'd imagine GetChild failing with nested
>> reports containing nested reports (aka second-level GetChild). You can 
>> only
>> call it to get first-level children of the report.
>>
>> "Jerry Siegel [TeamSybase]"<jNOsSPAMsiegel@yahoo.com>  wrote in message
>> news:4d24a470@forums-1-dub...
>>> I don't recommend dot notation for single values. It generates lots of
>>> overhead behind the scenes even though it looks like a simple assignment
>>> statement, and fails hard at run-time.
>>> Use functions whenever possible and always check the return code. 
>>> Finagle
>>> http://en.wikipedia.org/wiki/Finagle%27s_law was an optimist!
>>>
>>> Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> On 1/5/2011 4:53 AM, Ivaylo Ivanov wrote:
>>>> And alternatively to the Modify statement you also have the dot 
>>>> notation:
>>>>
>>>> dw_summary_report.Object.dw_original.DataObject = 'd_hazmat_add_entry'
>>>>
>>>>
>>>>
>>>> "Ivaylo Ivanov"<n0_S_p_a_m_i.ivanov@isy-dc.com>   wrote in message
>>>> news:4d243e0c$1@forums-1-dub...
>>>>> Try to call the GetChild AFTER the Modify statement. Also, take a look
>>>>> at
>>>>> the "rc" value after that.
>>>>> Maybe the reference to the report is being invalidated with the
>>>>> Modify().
>>>>>
>>>>> "300ZX"<xx@xx>   wrote in message news:4d23931a$1@forums-1-dub...
>>>>>> that works great but leads to another problem. I am trying to run
>>>>>> sharedata against that new dwo but it keeps failing even though I am
>>>>>> using exact dwo's. If I manually set the dwo to 'd_hazmat_add_entry' 
>>>>>> it
>>>>>> works fine which leads me to believe the block might be that I need 
>>>>>> to
>>>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>>>> variations to do so thus far but to no avail
>>>>>>
>>>>>> this is what I have...
>>>>>>
>>>>>> datawindowchild dwc_original
>>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>>> ls_return =
>>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>>> ls_return =
>>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>> messagebox("ls_return is", ls_return)
>>>>>>
>>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>>> messagebox("rc is", rc)
>>>>>>
>>>>>>
>>>>>> what would be the correct syntax?
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>>> I had tried that on a whim but didn't include the<reportname>   so 
>>>>>>> will
>>>>>>> give that a go...thanks
>>>>>>>
>>>>>>>
>>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject 
>>>>>>>> name>'
>>>>>>>> ")
>>>>>>>>
>>>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>>>> Product Enhancement Requests:
>>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>>
>>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>>> I can access the nested report through getchild ok but would like 
>>>>>>>>> to
>>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>>> requested.
>>>>>>>>>
>>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>>
>>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax 
>>>>>>>>> tool
>>>>>>>>> options
>>>>>>>>>
>>>>>>>>> thanks
>>>>>>>>>
>>>>>>>>> using 10.5.2
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>
>> 

On 6/01/2011 3:57 AM, Jerry Siegel [TeamSybase] wrote:
> ;-) No Possible Freaking Way

I worked it out but my word for "F" was a little more rude :)

>
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/5/2011 9:04 AM, 300ZX wrote:
>> just curious what does NPFW stand for? is that a typo because nothing
>> found on google
>>
>> On 05/01/11 1:19 AM, Jerry Siegel [TeamSybase] wrote:
>>> NPFW Modify can work that way.
>>> Normally when a dataobject is changed SetTransObject will be required as
>>> well.
>>> What did GetChild return?
>>>
>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> On 1/5/2011 12:44 AM, 300ZX wrote:
>>>> Well like I said I was trying many variations on the syntax out of
>>>> desperation because there is no clear example within the help or the
>>>> syntax generator. What adds to the confusion is some of the
>>>> variations I
>>>> concocted do not throw errors such as these two examples:
>>>>
>>>> ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
>>>> ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")
>>>>
>>>> The only indicator I get that they failed is because the subsequent
>>>> sharedata call fails
>>>>
>>>>
>>>> dwc_original.setransobject(SQLCA) was the first thing I tried and that
>>>> returns -1 so that is why I thought I would have to go the modify route
>>>>
>>>>
>>>> On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
>>>>> ls_return =
>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>
>>>>> Huh? SetTransObject can be used on a DWC but not as an argument to
>>>>> Modify. Betcha ls_return contains something ugly.
>>>>>
>>>>> dwc_original.settransobject(SQLCA) is more like it.
>>>>>
>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>> Product Enhancement Requests:
>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>
>>>>> On 1/4/2011 4:37 PM, 300ZX wrote:
>>>>>> that works great but leads to another problem. I am trying to run
>>>>>> sharedata against that new dwo but it keeps failing even though I am
>>>>>> using exact dwo's. If I manually set the dwo to
>>>>>> 'd_hazmat_add_entry' it
>>>>>> works fine which leads me to believe the block might be that I
>>>>>> need to
>>>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>>>> variations to do so thus far but to no avail
>>>>>>
>>>>>> this is what I have...
>>>>>>
>>>>>> datawindowchild dwc_original
>>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>>> ls_return =
>>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>>>
>>>>>>
>>>>>> ls_return =
>>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>> messagebox("ls_return is", ls_return)
>>>>>>
>>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>>> messagebox("rc is", rc)
>>>>>>
>>>>>>
>>>>>> what would be the correct syntax?
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>>> I had tried that on a whim but didn't include the <reportname> so
>>>>>>> will
>>>>>>> give that a go...thanks
>>>>>>>
>>>>>>>
>>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>>>>> name>' ")
>>>>>>>>
>>>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>>>> Product Enhancement Requests:
>>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>>
>>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>>> I can access the nested report through getchild ok but would
>>>>>>>>> like to
>>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>>> requested.
>>>>>>>>>
>>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>>
>>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax
>>>>>>>>> tool
>>>>>>>>> options
>>>>>>>>>
>>>>>>>>> thanks
>>>>>>>>>
>>>>>>>>> using 10.5.2
>>>>>>>
>>>>>>
>>>>
>>

You were correct  - the newsgroup server has a very puritanical spam 
filter and I was forced to bowdlerize.

Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

On 1/9/2011 8:58 PM, Adam Simmonds wrote:
> On 6/01/2011 3:57 AM, Jerry Siegel [TeamSybase] wrote:
>> ;-) No Possible Freaking Way
>
> I worked it out but my word for "F" was a little more rude :)
>
>>
>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> On 1/5/2011 9:04 AM, 300ZX wrote:
>>> just curious what does NPFW stand for? is that a typo because nothing
>>> found on google
>>>
>>> On 05/01/11 1:19 AM, Jerry Siegel [TeamSybase] wrote:
>>>> NPFW Modify can work that way.
>>>> Normally when a dataobject is changed SetTransObject will be
>>>> required as
>>>> well.
>>>> What did GetChild return?
>>>>
>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>> Product Enhancement Requests:
>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>
>>>> On 1/5/2011 12:44 AM, 300ZX wrote:
>>>>> Well like I said I was trying many variations on the syntax out of
>>>>> desperation because there is no clear example within the help or the
>>>>> syntax generator. What adds to the confusion is some of the
>>>>> variations I
>>>>> concocted do not throw errors such as these two examples:
>>>>>
>>>>> ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
>>>>> ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")
>>>>>
>>>>> The only indicator I get that they failed is because the subsequent
>>>>> sharedata call fails
>>>>>
>>>>>
>>>>> dwc_original.setransobject(SQLCA) was the first thing I tried and that
>>>>> returns -1 so that is why I thought I would have to go the modify
>>>>> route
>>>>>
>>>>>
>>>>> On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>> ls_return =
>>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>>
>>>>>> Huh? SetTransObject can be used on a DWC but not as an argument to
>>>>>> Modify. Betcha ls_return contains something ugly.
>>>>>>
>>>>>> dwc_original.settransobject(SQLCA) is more like it.
>>>>>>
>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>> Product Enhancement Requests:
>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>
>>>>>> On 1/4/2011 4:37 PM, 300ZX wrote:
>>>>>>> that works great but leads to another problem. I am trying to run
>>>>>>> sharedata against that new dwo but it keeps failing even though I am
>>>>>>> using exact dwo's. If I manually set the dwo to
>>>>>>> 'd_hazmat_add_entry' it
>>>>>>> works fine which leads me to believe the block might be that I
>>>>>>> need to
>>>>>>> set the trans object after modifying the dwo. I've tried many syntax
>>>>>>> variations to do so thus far but to no avail
>>>>>>>
>>>>>>> this is what I have...
>>>>>>>
>>>>>>> datawindowchild dwc_original
>>>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>>>> ls_return =
>>>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> ls_return =
>>>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>>> messagebox("ls_return is", ls_return)
>>>>>>>
>>>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>>>> messagebox("rc is", rc)
>>>>>>>
>>>>>>>
>>>>>>> what would be the correct syntax?
>>>>>>>
>>>>>>> thanks
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>>>> I had tried that on a whim but didn't include the <reportname> so
>>>>>>>> will
>>>>>>>> give that a go...thanks
>>>>>>>>
>>>>>>>>
>>>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>>>>>> name>' ")
>>>>>>>>>
>>>>>>>>> Report Bugs to Sybase:
>>>>>>>>> http://case-express.sybase.com/cx/welcome.do
>>>>>>>>> Product Enhancement Requests:
>>>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>>>
>>>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>>>> I can access the nested report through getchild ok but would
>>>>>>>>>> like to
>>>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>>>> requested.
>>>>>>>>>>
>>>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>>>
>>>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax
>>>>>>>>>> tool
>>>>>>>>>> options
>>>>>>>>>>
>>>>>>>>>> thanks
>>>>>>>>>>
>>>>>>>>>> using 10.5.2
>>>>>>>>
>>>>>>>
>>>>>
>>>
>

On 11/01/2011 5:27 AM, Jerry Siegel [TeamSybase] wrote:
> You were correct - the newsgroup server has a very puritanical spam
> filter and I was forced to bowdlerize.

I like to use NFWIH, I am sure you can work it out :)

>
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> On 1/9/2011 8:58 PM, Adam Simmonds wrote:
>> On 6/01/2011 3:57 AM, Jerry Siegel [TeamSybase] wrote:
>>> ;-) No Possible Freaking Way
>>
>> I worked it out but my word for "F" was a little more rude :)
>>
>>>
>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> On 1/5/2011 9:04 AM, 300ZX wrote:
>>>> just curious what does NPFW stand for? is that a typo because nothing
>>>> found on google
>>>>
>>>> On 05/01/11 1:19 AM, Jerry Siegel [TeamSybase] wrote:
>>>>> NPFW Modify can work that way.
>>>>> Normally when a dataobject is changed SetTransObject will be
>>>>> required as
>>>>> well.
>>>>> What did GetChild return?
>>>>>
>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>> Product Enhancement Requests:
>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>
>>>>> On 1/5/2011 12:44 AM, 300ZX wrote:
>>>>>> Well like I said I was trying many variations on the syntax out of
>>>>>> desperation because there is no clear example within the help or the
>>>>>> syntax generator. What adds to the confusion is some of the
>>>>>> variations I
>>>>>> concocted do not throw errors such as these two examples:
>>>>>>
>>>>>> ls_return = dwc_original.Modify("dw_original.transobject='SQLCA'")
>>>>>> ls_return = dwc_original.Modify("dw_original.settransobject(SQLCA)")
>>>>>>
>>>>>> The only indicator I get that they failed is because the subsequent
>>>>>> sharedata call fails
>>>>>>
>>>>>>
>>>>>> dwc_original.setransobject(SQLCA) was the first thing I tried and
>>>>>> that
>>>>>> returns -1 so that is why I thought I would have to go the modify
>>>>>> route
>>>>>>
>>>>>>
>>>>>> On 04/01/11 11:18 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>> ls_return =
>>>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>>>
>>>>>>> Huh? SetTransObject can be used on a DWC but not as an argument to
>>>>>>> Modify. Betcha ls_return contains something ugly.
>>>>>>>
>>>>>>> dwc_original.settransobject(SQLCA) is more like it.
>>>>>>>
>>>>>>> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
>>>>>>> Product Enhancement Requests:
>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>
>>>>>>> On 1/4/2011 4:37 PM, 300ZX wrote:
>>>>>>>> that works great but leads to another problem. I am trying to run
>>>>>>>> sharedata against that new dwo but it keeps failing even though
>>>>>>>> I am
>>>>>>>> using exact dwo's. If I manually set the dwo to
>>>>>>>> 'd_hazmat_add_entry' it
>>>>>>>> works fine which leads me to believe the block might be that I
>>>>>>>> need to
>>>>>>>> set the trans object after modifying the dwo. I've tried many
>>>>>>>> syntax
>>>>>>>> variations to do so thus far but to no avail
>>>>>>>>
>>>>>>>> this is what I have...
>>>>>>>>
>>>>>>>> datawindowchild dwc_original
>>>>>>>> rc = dw_summary_report.getchild("dw_original", dwc_original)
>>>>>>>> ls_return =
>>>>>>>> dw_summary_report.Modify("dw_original.DataObject='d_hazmat_add_entry'")
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> ls_return =
>>>>>>>> dw_summary_report.Modify("dw_original.settransobject='SQLCA'")
>>>>>>>> messagebox("ls_return is", ls_return)
>>>>>>>>
>>>>>>>> rc = dw_original_form.sharedata(dwc_original)
>>>>>>>> messagebox("rc is", rc)
>>>>>>>>
>>>>>>>>
>>>>>>>> what would be the correct syntax?
>>>>>>>>
>>>>>>>> thanks
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 04/01/11 3:55 PM, 300ZX wrote:
>>>>>>>>> I had tried that on a whim but didn't include the <reportname> so
>>>>>>>>> will
>>>>>>>>> give that a go...thanks
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 04/01/11 1:30 PM, Jerry Siegel [TeamSybase] wrote:
>>>>>>>>>> That gets done by modifying the report on the main DW:
>>>>>>>>>> <DW Control Name>.Modify("<Reportname>.DataObject='<dataobject
>>>>>>>>>> name>' ")
>>>>>>>>>>
>>>>>>>>>> Report Bugs to Sybase:
>>>>>>>>>> http://case-express.sybase.com/cx/welcome.do
>>>>>>>>>> Product Enhancement Requests:
>>>>>>>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>>>>>>>
>>>>>>>>>> On 1/4/2011 11:48 AM, 300ZX wrote:
>>>>>>>>>>> I can access the nested report through getchild ok but would
>>>>>>>>>>> like to
>>>>>>>>>>> change the dataobject specifically based on what the user has
>>>>>>>>>>> requested.
>>>>>>>>>>>
>>>>>>>>>>> Is this possible? Conventional syntax does not apply... ie
>>>>>>>>>>> <child>.dataobject = "xxx"
>>>>>>>>>>>
>>>>>>>>>>> and modify doesn't seem to offer it when perusing the dw syntax
>>>>>>>>>>> tool
>>>>>>>>>>> options
>>>>>>>>>>>
>>>>>>>>>>> thanks
>>>>>>>>>>>
>>>>>>>>>>> using 10.5.2
>>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>