Jack Skelley <[email protected]> wrote: >Good Evening Dan: >1 and 2: Yes. I wrote a prg to create a cursor to populate a report and >all worked as expected. >I then took the code and placed it in a method on a form. I click the >print button on the form and the cursor gets generated and populated >and then I issue the standard report form report name to print. When >the report runs I get a variable not found error. That variable was a >field name in a previous cursor with the same name as the current >cursor file name. >3: Different reports. The first report has about 10 fields and the >second that errors out has about 30 fields. They are not executed in >sequence. In fact, I run the second report without running the first >with the same error message. So something must be trapped in the scx. >When I take the method code out out the scx and paste it back in a prg >the report runs as expected with no errors. >As a something to try in the form I added that field name to the cursor >and the report now returns a different variable not found. The variable >was also in the first cursor. >I thought perhaps the foxuser was the culprit so I deleted it and I get >the same results. >Apparently the variable is saved in the scx and and it 'thinks' it >needs to be in the second report. >How do you clear this out??? I the hundreds of reports I have written I >have never seen this. And I am a creature of habit and always use tTemp >for my cursor name for reports. BTW, all the other reports in the >system run as expected using the same tTemp cursor name... >Like I said I created a dummy report with one field from the cursor and >get the same results. >I am sure it is not the report becuase it runs fine from the prg... >Thanks for any insight! >Best regards, >Jack >
It is acting like you are calling the wrong report file. -- Tracy _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
