Detail Table Problem in Report

[asm338s]

I have a pretty typical report that uses 2 tables. The top and bottom info comes from a table1 and the detail infor comes from table2 that has multiple entries for every key value in table1. I have both the tables in the database. When I run the report the first time with a selected date range it works fine, but when I try to run it for the second time with a different date range without closing the entire program the detail information in the middle that comes from table2 doesn't show up. When I close the program and open it and run the report then it works.
Any Suggestions?

 

[jimstarr]

Sounds like table2 may be at eof after the 1st pass.

Jim

 

[asm338s]

Could you clear that a little bit. Following is the code that I use for this:

Select abc from table xyz into table3
If not used('table2')
Select 777
Use table2 excl
Pack
Zap
Append from table3
Goto top
Endif

Select table1

If (reccount()=0)
Messagebox("No charges located&quot
Else
Report form 123.frx preview
Endif

Use in table1

 

[jimstarr]

Unless table2 gets closed somewhere else in your code it will remain "used", and so the code following

If not used('table2')

will only be executed the 1st time through.

Jim

 

[asm338s]

Ok I figured out thats not the problem. The problem is somewhere before this code. Its a problem with append.
I use this:

Select * from x into table serv1
select * from y into table serv2

if used('allserv')
select allserv
use in allserv
endif

use allserv excl
zap
append from serv1
append from serv2
goto top

This code works for the first time but for the second time through I still have the data from the first time. The append and zap stuff doesn't work.

 

[jimstarr]

Unless tables x and y have changed in the interim, I would expect the same result each time.

Jim

 

[asm338s]

The values in tables serv1 and serv2 change based on user selection. Its just the zap and append for allserv is not working correctly.

 

[jimstarr]

I personally have never had or heard of a problem with ZAP. My guess is that the command is only being executed on the first pass.

Jim