Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Distill and SaveAs PDF error

5 posts in Objects Last posting was on 2009-03-09 22:39:23.0Z
mmalubay Posted on 2009-03-05 00:06:02.0Z
Sender: 4873.49af12a2.1804289383@sybase.com
From: mmalubay@aw.ca
Newsgroups: sybase.public.powerbuilder.objects
Subject: Distill and SaveAs PDF error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49af176a.48ce.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Mar 2009 16:06:02 -0800
X-Trace: forums-1-dub 1236211562 10.22.241.41 (4 Mar 2009 16:06:02 -0800)
X-Original-Trace: 4 Mar 2009 16:06:02 -0800, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9813
Article PK: 736947

"Getting Incorrect Syntax on Line 1 column 18" when calling
Modify for distill and Getting return of -1 after calling
SaveAs in my client machine. Im using PB 11.5 Build 3050.

Code:
ls_return = dw_report.Modify("Export.PDF.Method = DISTILL!
")
l_return = dw_report.SaveAs("C:\BackOrder.pdf", PDF!, FALSE)

Same code is working in my development machine. Not sure
what other configuration I'm missing. I have already
installed GhostScript 8.54 and added it to the PATH on the
client machine.

I also tried suggestion to place GS and drivers in the
application folder but didnt work either.

Appreciate any help.


Bruce Armstrong [TeamSybase] Posted on 2009-03-05 14:40:30.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Distill and SaveAs PDF error
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <8kovq4dbbiqafb1ms07m6v5m5fk2c6pvnf@4ax.com>
References: <49af176a.48ce.1681692777@sybase.com>
X-Newsreader: Forte Agent 5.00/32.1171
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 5 Mar 2009 06:40:30 -0800
X-Trace: forums-1-dub 1236264030 10.22.241.152 (5 Mar 2009 06:40:30 -0800)
X-Original-Trace: 5 Mar 2009 06:40:30 -0800, vip152.sybase.com
Lines: 43
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9814
Article PK: 736945

You can't set a datawindow object property to an enumerated value. You
have to provide the numeric value:

Enumerated value Numeric value Meaning
Distill! 0 Data is printed to a
PostScript file and distilled to PDF (default).
XSLFOP! 1 Data is saved as XSL-FO and processed
to PDF.

Specifically, set it to 0. However, that is the default, so you can
skip setting it at all.

On 4 Mar 2009 16:06:02 -0800, mmalubay@aw.ca wrote:

>"Getting Incorrect Syntax on Line 1 column 18" when calling
>Modify for distill and Getting return of -1 after calling
>SaveAs in my client machine. Im using PB 11.5 Build 3050.
>
>Code:
>ls_return = dw_report.Modify("Export.PDF.Method = DISTILL!
>")
>l_return = dw_report.SaveAs("C:\BackOrder.pdf", PDF!, FALSE)
>
>Same code is working in my development machine. Not sure
>what other configuration I'm missing. I have already
>installed GhostScript 8.54 and added it to the PATH on the
>client machine.
>
>I also tried suggestion to place GS and drivers in the
>application folder but didnt work either.
>
>Appreciate any help.

-----------------------------------

My Web 2.0 Stuff

Blog: http://bruce.pbdjmagazine.com/
Facebook: http://www.facebook.com/people/Bruce-Armstrong/1600223798
Fotki: http://public.fotki.com/brucearmstrong/
LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
Twitter: http://twitter.com/bruce_armstrong
YouTube: http://www.youtube.com/user/brucearmstrong


mmalubay Posted on 2009-03-05 18:04:42.0Z
Sender: 5fc8.49b00b75.1804289383@sybase.com
From: mmalubay@aw.ca
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Distill and SaveAs PDF error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49b0143a.6088.1681692777@sybase.com>
References: <8kovq4dbbiqafb1ms07m6v5m5fk2c6pvnf@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Mar 2009 10:04:42 -0800
X-Trace: forums-1-dub 1236276282 10.22.241.41 (5 Mar 2009 10:04:42 -0800)
X-Original-Trace: 5 Mar 2009 10:04:42 -0800, 10.22.241.41
Lines: 55
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9815
Article PK: 736946

Hi ,

Thanks for the response.

I removed this line from the code
ls_return = dw_report.Modify("Export.PDF.Method = DISTILL!")
but my SaveAs was still returning -1.

As I've mentioned previously, the same code is working my
development machine ( didnt return an error in Modify and
SaveAs).

> You can't set a datawindow object property to an
> enumerated value. You have to provide the numeric value:
>
> Enumerated value Numeric value Meaning
> Distill! 0 Data is printed to a
> PostScript file and distilled to PDF (default).
> XSLFOP! 1 Data is saved as XSL-FO and
> processed to PDF.
>
> Specifically, set it to 0. However, that is the default,
> so you can skip setting it at all.
>
> On 4 Mar 2009 16:06:02 -0800, mmalubay@aw.ca wrote:
>
> >"Getting Incorrect Syntax on Line 1 column 18" when
> calling >Modify for distill and Getting return of -1 after
> calling >SaveAs in my client machine. Im using PB 11.5
> Build 3050. >
> >Code:
> >ls_return = dw_report.Modify("Export.PDF.Method =
> DISTILL! >")
> >l_return = dw_report.SaveAs("C:\BackOrder.pdf", PDF!,
> FALSE) >
> >Same code is working in my development machine. Not sure
> >what other configuration I'm missing. I have already
> >installed GhostScript 8.54 and added it to the PATH on
> the >client machine.
> >
> >I also tried suggestion to place GS and drivers in the
> >application folder but didnt work either.
> >
> >Appreciate any help.
> -----------------------------------
>
> My Web 2.0 Stuff
>
> Blog: http://bruce.pbdjmagazine.com/
> Facebook:
> http://www.facebook.com/people/Bruce-Armstrong/1600223798
> Fotki: http://public.fotki.com/brucearmstrong/
> LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
> Twitter: http://twitter.com/bruce_armstrong YouTube:
> http://www.youtube.com/user/brucearmstrong


Bruce Armstrong [TeamSybase] Posted on 2009-03-05 21:45:19.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Distill and SaveAs PDF error
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <ptg0r498v49vaot0pjvfachea90hn3p13u@4ax.com>
References: <8kovq4dbbiqafb1ms07m6v5m5fk2c6pvnf@4ax.com> <49b0143a.6088.1681692777@sybase.com>
X-Newsreader: Forte Agent 5.00/32.1171
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 5 Mar 2009 13:45:19 -0800
X-Trace: forums-1-dub 1236289519 10.22.241.152 (5 Mar 2009 13:45:19 -0800)
X-Original-Trace: 5 Mar 2009 13:45:19 -0800, vip152.sybase.com
Lines: 79
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9816
Article PK: 736949

Is there a printer provide on the deployment machine called "Sybase
DataWindow PS"? You either need to do that or have another one
configured correctly and then define that as the printer to use for
the SaveAs.

You might want to look at the deployment information for SaveAs
support using the distiller:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc37774_1150/html/apptech/BAJIEEAF.htm

On 5 Mar 2009 10:04:42 -0800, mmalubay@aw.ca wrote:

>Hi ,
>
>Thanks for the response.
>
>I removed this line from the code
>ls_return = dw_report.Modify("Export.PDF.Method = DISTILL!")
>but my SaveAs was still returning -1.
>
>As I've mentioned previously, the same code is working my
>development machine ( didnt return an error in Modify and
>SaveAs).
>
>> You can't set a datawindow object property to an
>> enumerated value. You have to provide the numeric value:
>>
>> Enumerated value Numeric value Meaning
>> Distill! 0 Data is printed to a
>> PostScript file and distilled to PDF (default).
>> XSLFOP! 1 Data is saved as XSL-FO and
>> processed to PDF.
>>
>> Specifically, set it to 0. However, that is the default,
>> so you can skip setting it at all.
>>
>> On 4 Mar 2009 16:06:02 -0800, mmalubay@aw.ca wrote:
>>
>> >"Getting Incorrect Syntax on Line 1 column 18" when
>> calling >Modify for distill and Getting return of -1 after
>> calling >SaveAs in my client machine. Im using PB 11.5
>> Build 3050. >
>> >Code:
>> >ls_return = dw_report.Modify("Export.PDF.Method =
>> DISTILL! >")
>> >l_return = dw_report.SaveAs("C:\BackOrder.pdf", PDF!,
>> FALSE) >
>> >Same code is working in my development machine. Not sure
>> >what other configuration I'm missing. I have already
>> >installed GhostScript 8.54 and added it to the PATH on
>> the >client machine.
>> >
>> >I also tried suggestion to place GS and drivers in the
>> >application folder but didnt work either.
>> >
>> >Appreciate any help.
>> -----------------------------------
>>
>> My Web 2.0 Stuff
>>
>> Blog: http://bruce.pbdjmagazine.com/
>> Facebook:
>> http://www.facebook.com/people/Bruce-Armstrong/1600223798
>> Fotki: http://public.fotki.com/brucearmstrong/
>> LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
>> Twitter: http://twitter.com/bruce_armstrong YouTube:
>> http://www.youtube.com/user/brucearmstrong

-----------------------------------

My Web 2.0 Stuff

Blog: http://bruce.pbdjmagazine.com/
Facebook: http://www.facebook.com/people/Bruce-Armstrong/1600223798
Fotki: http://public.fotki.com/brucearmstrong/
LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
Twitter: http://twitter.com/bruce_armstrong
YouTube: http://www.youtube.com/user/brucearmstrong


mmalubay Posted on 2009-03-09 22:39:23.0Z
Sender: 7482.49b598d9.1804289383@sybase.com
From: mmalubay
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Distill and SaveAs PDF error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49b59a9b.74a3.1681692777@sybase.com>
References: <ptg0r498v49vaot0pjvfachea90hn3p13u@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Mar 2009 14:39:23 -0800
X-Trace: forums-1-dub 1236638363 10.22.241.41 (9 Mar 2009 14:39:23 -0800)
X-Original-Trace: 9 Mar 2009 14:39:23 -0800, 10.22.241.41
Lines: 86
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9822
Article PK: 736954

Hi Bruce,

Adding the drivers folder in the application directory made
it work! Thanks for your help...

> Is there a printer provide on the deployment machine
> called "Sybase DataWindow PS"? You either need to do that
> or have another one configured correctly and then define
> that as the printer to use for the SaveAs.
>
> You might want to look at the deployment information for
> SaveAs support using the distiller:
>
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc37774_1150/html/apptech/BAJIEEAF.htm
>
>
> On 5 Mar 2009 10:04:42 -0800, mmalubay@aw.ca wrote:
>
> >Hi ,
> >
> >Thanks for the response.
> >
> >I removed this line from the code
> >ls_return = dw_report.Modify("Export.PDF.Method =
> DISTILL!") >but my SaveAs was still returning -1.
> >
> >As I've mentioned previously, the same code is working my
> >development machine ( didnt return an error in Modify and
> >SaveAs).
> >
> >> You can't set a datawindow object property to an
> >> enumerated value. You have to provide the numeric
> value: >>
> >> Enumerated value Numeric value Meaning
> >> Distill! 0 Data is printed to a
> >> PostScript file and distilled to PDF (default).
> >> XSLFOP! 1 Data is saved as XSL-FO and
> >> processed to PDF.
> >>
> >> Specifically, set it to 0. However, that is the
> default, >> so you can skip setting it at all.
> >>
> >> On 4 Mar 2009 16:06:02 -0800, mmalubay@aw.ca wrote:
> >>
> >> >"Getting Incorrect Syntax on Line 1 column 18" when
> >> calling >Modify for distill and Getting return of -1
> after >> calling >SaveAs in my client machine. Im using
> PB 11.5 >> Build 3050. >
> >> >Code:
> >> >ls_return = dw_report.Modify("Export.PDF.Method =
> >> DISTILL! >")
> >> >l_return = dw_report.SaveAs("C:\BackOrder.pdf", PDF!,
> >> FALSE) >
> >> >Same code is working in my development machine. Not
> sure >> >what other configuration I'm missing. I have
> already >> >installed GhostScript 8.54 and added it to the
> PATH on >> the >client machine.
> >> >
> >> >I also tried suggestion to place GS and drivers in the
> >> >application folder but didnt work either.
> >> >
> >> >Appreciate any help.
> >> -----------------------------------
> >>
> >> My Web 2.0 Stuff
> >>
> >> Blog: http://bruce.pbdjmagazine.com/
> >> Facebook:
> >>
> http://www.facebook.com/people/Bruce-Armstrong/1600223798
> >> Fotki: http://public.fotki.com/brucearmstrong/ >>
> LinkedIn: http://www.linkedin.com/in/bruceaarmstrong >>
> Twitter: http://twitter.com/bruce_armstrong YouTube: >>
> http://www.youtube.com/user/brucearmstrong
> -----------------------------------
>
> My Web 2.0 Stuff
>
> Blog: http://bruce.pbdjmagazine.com/
> Facebook:
> http://www.facebook.com/people/Bruce-Armstrong/1600223798
> Fotki: http://public.fotki.com/brucearmstrong/
> LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
> Twitter: http://twitter.com/bruce_armstrong YouTube:
> http://www.youtube.com/user/brucearmstrong