Very Computer

by **Peter Robinso** » Tue, 12 Sep 1995 04:00:00

Hi there ,

I have a delphi form for maintaining a header & item type database set
up. Header database with many items in an item database. The tables
are Paradox. My initial screen in the delphi form is a grid with Order
Number , Description , Date and Print Flag. My form has a button which
allows the user to toggle the Print Flag to Y or N. When he has
finished editing the grid ( setting required orders to print Y) there
is a print button which calls a Crystal Report which selects the orders
with the print flag set to Y. When the toggle button is used , i set
the value in the field to Y or N and then do a Table1.Post; ( where
table1 is the header). When the Print button is pressed , i do a
database refresh ( i have also tried closing & reopening it ) then
execute the report. The problem is that the report doesn't seem to pick
up the current batch of flagged orders. ie. if when the user enters the
form , orders 1,2 & 3 are tagged for printing , he changes it to be
4,5 and 6 for printing , then presses the print button ...it still
prints 1 , 2 & 3. However , if he tagges 4,5 & 6 then exits the form &
reselects it , it will print correctly. This is driving me totally INSANE!!!!

Thanks in advance for any help ..

PS Crystal Reports was Version 3.0.1 , but I have just upgraded to 4.0
and it still does the same thing !!!!

Peter Robinson

by **Kyle Co** » Tue, 12 Sep 1995 04:00:00

: Hi there ,

: the value in the field to Y or N and then do a Table1.Post; ( where
: table1 is the header). When the Print button is pressed , i do a
: database refresh ( i have also tried closing & reopening it ) then
: execute the report. The problem is that the report doesn't seem to pick
: up the current batch of flagged orders. ie. if when the user enters the

: PS Crystal Reports was Version 3.0.1 , but I have just upgraded to 4.0
: and it still does the same thing !!!!

You need Crystal Reports 4.0.1.5 and the latest pdox dll from compuserve
in order to use Paradox databases in your applications. I had your exact
problem, as well as a few more. The solution recommended above should
solve your problem. 4.0.1.5 is a free upgrade to 4.0 owners.

Kyle

by **Sundial Servic** » Tue, 12 Sep 1995 04:00:00

>Subject: Re: Urgent Help Needed : Delphi / Crystal Reports
>Date: 11 Sep 1995 15:34:29 GMT

>: Hi there ,
>: the value in the field to Y or N and then do a Table1.Post; ( where
>: table1 is the header). When the Print button is pressed , i do a
>: database refresh ( i have also tried closing & reopening it ) then
>: execute the report. The problem is that the report doesn't seem to pick
>: up the current batch of flagged orders. ie. if when the user enters the
>: PS Crystal Reports was Version 3.0.1 , but I have just upgraded to 4.0
>: and it still does the same thing !!!!
>You need Crystal Reports 4.0.1.5 and the latest pdox dll from compuserve
>in order to use Paradox databases in your applications. I had your exact
>problem, as well as a few more. The solution recommended above should
>solve your problem. 4.0.1.5 is a free upgrade to 4.0 owners.

Another consideration... it might be that your Delphi app is making a bunch
of updates that are sitting around in memory and haven't been written to disk.
In that case Crystal won't see them. See if the records suddenly appear on
the report after you close the table in Delphi; if so that's your problem.
This is currently being discussed in another thread about "dbiUseIdleTime."