how do you set-up a cursor for reporting?

[cremang]

Hi! I created a cursor out of a select-sql process. Basically it's just two tables having a one-to-one relationship. The user selects certain fields to filter which will then be included in the report.
The problem is, the open table dialog box appears. The cursor is nowhere to be found. How can I present data from the cursor to the report? Any help is appreciated(TIA)...

 

[FoxDevil]

cremang,
try this.

<here the cursor is created> is must have some name.
select cursor_name_here
report form report_name_here preview

 

[Mike Gagnon]

Hi! I created a cursor out of a select-sql process. Basically it's just two tables having a one-to-one relationship. The user selects certain fields to filter which will then be included in the report.
The problem is, the open table dialog box appears. The cursor is nowhere to be found. How can I present data from the cursor to the report? Any help is appreciated(TIA)...

As Foxdevil suggests the last thing before your report should be a call to your cursor.. And also make sure the fields in your report only have the field names, not the tablename+fieldname..

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[jimstarr]

Do you, perhaps, have a table in the data environment of the report? If you do, the report will try to locate this table even though you explicitly select the cursor.

Jim

 

[foxbldr]

Cremang,


Just check whether you have added in the following order:

Select <fields> from <tables>... into... cursor <cursor_name>

if _tally>0
select <cursor_name>
index....(if necessary)
report form ...
else
messagebox()
endif


Foxbldr