Jack, Just as a matter of interest see what alias you are pointing at in the report in the BeforeOpentables() or init() event in the report. Suspend the program here and look. Sometimes for unknown reasons I have had to force the Alias() to be hard coded here as opposed to just assuming that the alias I want to take the report data from is actually selected.
Another thing is just to look at the indexes on the tables, make sure you haven't any UDF's in there selecting the wrong alias or not returning with the alias set as per when they were called. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Jack Skelley Sent: 04 October 2013 02:07 To: [email protected] Subject: VFP9: Very Weird Report Behavior Good Evening: At wits end on this one... I have a prg where I create a cursor to populate a report. Works fine from the prg. I then take that same code and copy it to a method in a form and the when the report runs from the form I get a variable not found error. That variable that is not found was used in the same cursor name for a previous report. After the report runs in the first report the cursor is closed. The report that errors has never had that variable in it. The other report that has the variable not found in the second report runs fine. I have looked for the variable in the frx and it does not exist. Even when I create the variable on the second report it still reports variable not found. What am I missing? Even when I create a new report with 1 field from the cursor on it the error is the same. Is there some clandestine dataenvironment on the form? Thanks for any help. Best regards, Jack Jack Skelley Senior Director, Programming/Computer Operations New Jersey Devils (973)757-6164 [email protected] [excessive quoting removed by server] _______________________________________________ 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.
