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.

InfoMaker 5.0 Reports

3 posts in PB Infomaker Report Writer Last posting was on 1998-06-25 00:08:55.0Z
Lindsay Robinson Posted on 1998-06-24 13:17:14.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 24 Jun 1998 09:17:14 -0400
From: Lindsay Robinson <lrobins@caseload.com>
Reply-To: lrobins@caseload.com
Organization: Evans CaseLoad Inc.
X-Mailer: Mozilla 3.0Gold (Win95; U)
MIME-Version: 1.0
Subject: InfoMaker 5.0 Reports
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 10
Message-ID: <348_3590FC5A.435E@caseload.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7035
Article PK: 243064

I am creating a report with five columns (no tab order). One of the
columns uses a dropdown datawindow (edit style) which contains more than
50,000 rows. Does anybody know if all 50,000 rows are returned to the
client and then the correct row is displayed? Or is the correct row
returned to the client without returning all 50,000 rows?

Thanx,
Lindsay


Terry Dykstra [TeamPS] Posted on 1998-06-24 19:07:04.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: InfoMaker 5.0 Reports
Date: Wed, 24 Jun 1998 13:07:04 -0600
Lines: 20
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_k1MMkSIo9GA.120@forums.powersoft.com>
References: <348_3590FC5A.435E@caseload.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7031
Article PK: 243062

I believe all 50000 rows are returned. You can check that easily by tracing
the report: in the database connection add the word trace to the DBMS
parameter, e.g. trace O73, or trace ODBC.
This will create a trace file showing the sql sent to the server and the
data returned.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Lindsay Robinson wrote in message <3590FC5A.435E@caseload.com>...
>I am creating a report with five columns (no tab order). One of the
>columns uses a dropdown datawindow (edit style) which contains more than
>50,000 rows. Does anybody know if all 50,000 rows are returned to the
>client and then the correct row is displayed? Or is the correct row
>returned to the client without returning all 50,000 rows?
>
>Thanx,
>Lindsay


Lynne Strojny Posted on 1998-06-25 00:08:55.0Z
Newsgroups: sybase.public.infomaker.general
From: "Lynne Strojny" <lstrojny@mail.pcao.pima.gov>
Subject: Re: InfoMaker 5.0 Reports
Date: Wed, 24 Jun 1998 17:08:55 -0700
Lines: 12
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_AsQAmQ8n9GA.120@forums.powersoft.com>
References: <348_3590FC5A.435E@caseload.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7033
Article PK: 243063

xx

Lindsay Robinson wrote in message <3590FC5A.435E@caseload.com>...
>I am creating a report with five columns (no tab order). One of the
>columns uses a dropdown datawindow (edit style) which contains more than
>50,000 rows. Does anybody know if all 50,000 rows are returned to the
>client and then the correct row is displayed? Or is the correct row
>returned to the client without returning all 50,000 rows?
>
>Thanx,
>Lindsay