I Hate this kind of problem. Please Help

Tech-Archive recommends: Speed Up your PC by fixing your registry



Hello and thanks in advance for the help.


I have an program which builds a file for the report generator, calls the
report, and returns.

It is being called from a right click menu of a form.


The code for printing (2 lines)
SELECT Inv_Print
REPORT FORM pickticket to PRINTER NOCONSOLE


The problem is that the first time this PRG is called from the compiled
version I get a variable not found message. The problem does not occcur on
calls to the PRG after the first one.

Here is what I know about this problem:

1. If I change the REPORT line to include PREVIEW the code works fine

2. If I insert a BROWSE command in front of the REPORT command, it browses
the INV_PRINT table and then prints fine.

3. If I put the BROWSE after the REPORT command, the error occurs and I
discover that I wasn't actually pointing to the INV_PRINT table.

As I said in the subject, I hate this kind of problem. Does anybody have any
potential solutions or debugging suggestions. BTW, if you run the code in
the debugger, the problem doesn't happen. It was only by sticking the BROWSE
after the REPORT command that I discovered that it was pointing at the wrong
table.

The ultimate question is why would it be pointing at the wrong table when
the SELECT statement is right before the REPORT command.


.



Relevant Pages

  • Re: I Hate this kind of problem. Please Help
    ... Another solution would be to create a private DS before launching a report ... The name of the grid is orderlist. ... REPORT FORM pickticket to PRINTER NOCONSOLE ... If I put the BROWSE after the REPORT command, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: I Hate this kind of problem. Please Help
    ... The name of the grid is orderlist. ... REPORT FORM pickticket to PRINTER NOCONSOLE ... If I put the BROWSE after the REPORT command, ...
    (microsoft.public.fox.programmer.exchange)
  • RE: Creating a VFP report on the fly from a web page.
    ... Report Command Used In Visual FoxPro COM DLL Causes Error ...
    (microsoft.public.fox.programmer.exchange)
  • Re: I Hate this kind of problem. Please Help
    ... I bet you're launching the report from a form which has a grid on it and the ... REPORT FORM pickticket to PRINTER NOCONSOLE ... If I put the BROWSE after the REPORT command, ... BROWSE after the REPORT command that I discovered that it was pointing at ...
    (microsoft.public.fox.programmer.exchange)
  • Re: I Hate this kind of problem. Please Help
    ... I bet you're launching the report from a form which has a grid on it and the ... REPORT FORM pickticket to PRINTER NOCONSOLE ... If I put the BROWSE after the REPORT command, ... BROWSE after the REPORT command that I discovered that it was pointing at ...
    (microsoft.public.fox.programmer.exchange)