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
![]() |
0 |
![]() |
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
![]() |
0 |
![]() |
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
![]() |
0 |
![]() |
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 >
![]() |
0 |
![]() |
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 >> >
![]() |
0 |
![]() |
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 >>> >>
![]() |
0 |
![]() |
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 >>>> >>> >
![]() |
0 |
![]() |
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 >> >
![]() |
0 |
![]() |
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 >>> >> > >
![]() |
0 |
![]() |
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 >>>>> >>>> >>
![]() |
0 |
![]() |
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 >>> >> > >
![]() |
0 |
![]() |
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 >>> >> > >
![]() |
0 |
![]() |
;-) 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 >>>>>> >>>>> >>> >
![]() |
0 |
![]() |
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 >>>> >>> >> >> > >
![]() |
0 |
![]() |
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 >>>>> >>>> >>> >>> >> >>
![]() |
0 |
![]() |
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 >>>>>>> >>>>>> >>>> >>
![]() |
0 |
![]() |
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 >>>>>> >>>>> >>>> >>>> >>> >>> >
![]() |
0 |
![]() |
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 >>>>> >>>> >>> >>> >> >>
![]() |
0 |
![]() |
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 >>>>>> >>>>> >>>> >>>> >>> >>> > >
![]() |
0 |
![]() |
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 >>>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >> >>
![]() |
0 |
![]() |
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 >>>>>>> >>>>>> >>>> >>
![]() |
0 |
![]() |
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 >>>>>>>> >>>>>>> >>>>> >>> >
![]() |
0 |
![]() |
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 >>>>>>>>> >>>>>>>> >>>>>> >>>> >>
![]() |
0 |
![]() |