Here is what I done.
1. SET VAR in report to DATE ... had to preset .VSHIP to date before it would let me. 2. Saw in the SYNTAX where it was doing this PRINT shiplog WHERE shipdate = .whval0 Changed to PRINT shiplog WHERE shipdate = .vship
Don't know which of these fixed it, but it now works.
What is weird is that this has been running for years. I did have to do a reload on the database the other day when it got corrupted by ??? We suspect a users Netware Client for...
Here is the running code now.
CLS SET VAR whval0 TEXT DIALOG 'Enter the Ship Date (MM/DD/YYYY):' whval0 whtemp 1 SET LINES=60 SET VAR vship DATE = .whval0 OUTPUT PRINTER PRINT shiplog WHERE shipdate = .vship + ORDER BY refnum ASC IF errvar <> 0 THEN OUTPUT SCREEN PAUSE 1 USING 'No shipments found. Press any key to continue.' ENDIF
Thanks Larry, Bill, Ben, Javier, Doug and all
Jim
Lawrence Lustig wrote:
variable is defined as text.
Will try the & syntax
The report variable should be defined as DATE. -- Larry
__________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com
