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.

SaveAs function

3 posts in DataWindow .NET Last posting was on 2004-09-01 13:53:44.0Z
Jenovin Jacob Posted on 2004-09-01 10:06:07.0Z
Sender: 2de5.41359df5.1804289383@sybase.com
From: Jenovin Jacob
Newsgroups: sybase.public.datawindow.net
Subject: SaveAs function
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41359f0f.2df4.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Sep 2004 03:06:07 -0700
X-Trace: forums-1-dub 1094033167 10.22.241.41 (1 Sep 2004 03:06:07 -0700)
X-Original-Trace: 1 Sep 2004 03:06:07 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:265
Article PK: 124696

Hi,

Is there any limitations for SaveAs function. I am unable
to save the data window using SaveAs function if the data
window is large. The data in the data window is large and
thus I couldnt save it as an excel file.
Also kindly let me know if any dlls play any role in SaveAs
function.

Kindly help me


Doug Porter Posted on 2004-09-01 13:53:44.0Z
From: "Doug Porter" <doug_porter@dailyaccess.nospam.com>
Newsgroups: sybase.public.datawindow.net
References: <41359f0f.2df4.1681692777@sybase.com>
Subject: Re: SaveAs function
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: 12.6.74.46
X-Original-NNTP-Posting-Host: 12.6.74.46
Message-ID: <4135d468$1@forums-1-dub>
Date: 1 Sep 2004 06:53:44 -0700
X-Trace: forums-1-dub 1094046824 12.6.74.46 (1 Sep 2004 06:53:44 -0700)
X-Original-Trace: 1 Sep 2004 06:53:44 -0700, 12.6.74.46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:267
Article PK: 124697

Excel has a limit of 256 columns and around 65,536 rows

I tested trying to save a 70,000 row dataset and it failed rather quickly.
So I gather that PB didn't even try and start saving that massive set of
data after finding the number of rows to be that large.

Doug

<Jenovin Jacob> wrote in message news:41359f0f.2df4.1681692777@sybase.com...
> Hi,
>
> Is there any limitations for SaveAs function. I am unable
> to save the data window using SaveAs function if the data
> window is large. The data in the data window is large and
> thus I couldnt save it as an excel file.
> Also kindly let me know if any dlls play any role in SaveAs
> function.
>
> Kindly help me


Bruce Armstrong [TeamSybase] Posted on 2004-09-01 13:06:38.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.datawindow.net
Subject: Re: SaveAs function
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <ufhbj0hf8pbp9447322db3s3ub81uu0ks0@4ax.com>
References: <41359f0f.2df4.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.646
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 68-190-226-38.la-cbi.charterpipeline.net
X-Original-NNTP-Posting-Host: 68-190-226-38.la-cbi.charterpipeline.net
Date: 1 Sep 2004 06:06:38 -0700
X-Trace: forums-1-dub 1094043998 68.190.226.38 (1 Sep 2004 06:06:38 -0700)
X-Original-Trace: 1 Sep 2004 06:06:38 -0700, 68-190-226-38.la-cbi.charterpipeline.net
Lines: 52
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:266
Article PK: 124698

Define "large". The Excel format itself has some limitations on the
number of columns and the amount of text in a single column.

The only format that requires additional components is the SaveAs PDF.

On 1 Sep 2004 03:06:07 -0700, Jenovin Jacob wrote:

>Hi,
>
> Is there any limitations for SaveAs function. I am unable
>to save the data window using SaveAs function if the data
>window is large. The data in the data window is large and
>thus I couldnt save it as an excel file.
>Also kindly let me know if any dlls play any role in SaveAs
>function.
>
>Kindly help me

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

TeamSybase blogs:
http://www.teamsybase.net/blogs

Vote for PocketBuilder in the Mobile Village awards
http://www.mobilevillage.com/awards.htm

Two 3rd party books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups

Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org

---------------------------------------------------------------------
DISCLAIMER:

This newsgroup message is only intended for the recipient. Given that it
is a posting to a public newsgroup, that means if you can read this
message then you are the recipient. This message may contain information
that is confidential and protected from disclosure. And then again,
it may not.

Given that TeamSybase members are not employees of Sybase, the contents
of this message do not necessarily represent the views or policies of
Sybase. Given that TeamSybase is a diverse group of users of Sybase
products, the contents of this message do not necessarily represent the
views of a significant number of the members of TeamSybase. Given that the
author has multiple personalities and hears voices in his head, the contents
of this message do not necessarily represent his own views.