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.

DW2XLS - crash with PB10.5

2 posts in General Discussion Last posting was on 2013-02-27 08:26:24.0Z
André Rust Posted on 2013-02-26 16:02:51.0Z
From: André Rust <rust@pdg.de>
Reply-To: rust@pdg.de
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.general
Subject: DW2XLS - crash with PB10.5
Content-Type: multipart/mixed; boundary="------------000600040308070508090701"
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <512cdcab@forums-1-dub>
Date: 26 Feb 2013 08:02:51 -0800
X-Trace: forums-1-dub 1361894571 172.20.134.152 (26 Feb 2013 08:02:51 -0800)
X-Original-Trace: 26 Feb 2013 08:02:51 -0800, vip152.sybase.com
Lines: 3745
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249726
Article PK: 1307945

Hi all,

we use dw2xls with PB10.5 version. On a PC, there are problems when a
DW's export to xls.

We use the following code:

-----------------------
long l_result
string s_dateiname
string s_path
string s_file
string s_docname
n_dwr_service_parm lnvo_parm
w_basis w_parent

s_docname = parent.dw_1.Describe( "DataWindow.Print.DocumentName" )
if isnull( s_docname ) or len( trim( s_docname ) ) = 0 then s_docname =
'Export'

s_path = 'c:\'
s_dateiname = 'c:\' + trim( s_docname ) + '.xls'

lnvo_parm = create n_dwr_service_parm

if isvalid(lnvo_parm) then lnvo_parm.is_version = 'OOXML'
if isvalid(lnvo_parm) then lnvo_parm.is_sheet_name = s_docname

// Dateiname ermitteln
l_result = GetFileSaveName( "Dateinamen exportieren", s_dateiname,
s_file, "XLS", "Alle Dateien (*.xls),*.xls", s_path, 32770 )

if l_result <= 0 then return

// Save DW as Excel
if isvalid(lnvo_parm) then
l_result = uf_save_dw_as_excel_parm( parent.dw_1, s_dateiname, lnvo_parm )
else
l_result = uf_save_dw_as_excel( parent.dw_1, s_dateiname )
end if

if isvalid( lnvo_parm ) then destroy lnvo_parm

return
-----------------------


DataWindow for output see error1.jpg
Datawindows for export see error2.jpg
Crash see error3.jpg


PC with Windows XP SP3 and Office 2007 Service Pack


Does anyone have a solution to this? Thank you.

Andr? Rust

Error1.jpg
Error2.jpg
Error3.jpg

André Rust Posted on 2013-02-27 08:26:24.0Z
From: André Rust <rust@pdg.de>
Reply-To: rust@pdg.de
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: DW2XLS - crash with PB10.5
References: <512cdcab@forums-1-dub>
In-Reply-To: <512cdcab@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <512dc330$1@forums-1-dub>
Date: 27 Feb 2013 00:26:24 -0800
X-Trace: forums-1-dub 1361953584 172.20.134.152 (27 Feb 2013 00:26:24 -0800)
X-Original-Trace: 27 Feb 2013 00:26:24 -0800, vip152.sybase.com
Lines: 64
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249738
Article PK: 1307966

I've found the problem. The missing DLL's fault.

Andr? Rust

Am 26.02.2013 17:02, schrieb Andr? Rust:

> Hi all,
>
> we use dw2xls with PB10.5 version. On a PC, there are problems when a
> DW's export to xls.
>
> We use the following code:
>
> -----------------------
> long l_result
> string s_dateiname
> string s_path
> string s_file
> string s_docname
> n_dwr_service_parm lnvo_parm
> w_basis w_parent
>
> s_docname = parent.dw_1.Describe( "DataWindow.Print.DocumentName" )
> if isnull( s_docname ) or len( trim( s_docname ) ) = 0 then s_docname =
> 'Export'
>
> s_path = 'c:\'
> s_dateiname = 'c:\' + trim( s_docname ) + '.xls'
>
> lnvo_parm = create n_dwr_service_parm
>
> if isvalid(lnvo_parm) then lnvo_parm.is_version = 'OOXML'
> if isvalid(lnvo_parm) then lnvo_parm.is_sheet_name = s_docname
>
> // Dateiname ermitteln
> l_result = GetFileSaveName( "Dateinamen exportieren", s_dateiname,
> s_file, "XLS", "Alle Dateien (*.xls),*.xls", s_path, 32770 )
>
> if l_result <= 0 then return
>
> // Save DW as Excel
> if isvalid(lnvo_parm) then
> l_result = uf_save_dw_as_excel_parm( parent.dw_1, s_dateiname,
> lnvo_parm )
> else
> l_result = uf_save_dw_as_excel( parent.dw_1, s_dateiname )
> end if
>
> if isvalid( lnvo_parm ) then destroy lnvo_parm
>
> return
> -----------------------
>
>
> DataWindow for output see error1.jpg
> Datawindows for export see error2.jpg
> Crash see error3.jpg
>
>
> PC with Windows XP SP3 and Office 2007 Service Pack
>
>
> Does anyone have a solution to this? Thank you.
>
> Andr? Rust