Jim,, IFWIW...
If your compiled application includes all reports or forms, you may need to update all resources, including updated reports, etc. Very Best R:egards, Razzak ---- Jim Belisle wrote ---- > > >Frank, > > > >I completely recreated the report but got the same result after >compiling it. > >The code is so simple and the same as I have for other reports on the >same form. > >Assemblycost is the report name. > >The report works when in the explorer mode when using the WHERE builder. > >In the application it does not work. > >Below is the simple code I use. The same code is used on another report >that works. > > > >SELECT (COUNT(*)) INTO vac2 INDICATOR ivac2 FROM assy_part + > >WHERE assembly# = .vpartnumid > >IF vac2 = 0 THEN > > PAUSE 1 USING 'Information not available. Use Assy_Part Entry Button!' >+ > > CAPTION 'Assembly Part Information' BUTTON 'Finish' > > GOTO done > >ELSE > > PRINT assemblycost WHERE assembly# = .vpartnumid + > > OPTION SCREEN|WINDOW_STATE MAXIMIZED + > > |ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 100 > >ENDIF > >RECALC VAR > >LABEL done > >CLEAR VAR vac2, ivac2 > >SKIP TO partnum > >RETURN > > > >James Belisle > > > >Making Information Systems People Friendly Since 1990 > > > > >
