Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement not working
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00561704
Message ID:
00561724
Views:
21
Hi Nick,
I don't see any problems in the code below.
Check following in your report:
- you are not using table aliases in the fields
- The report isn't using private datasession
- There are no tables/cursors in the reports DE.

>Hi Sergey, thanks for answering back. I was trying follow you example that you posted lasttime. I am trying to make the a report work based on this cursor I just created. If I do browse I can that the query is working and correct results appear. Next, in the report I name the detail line field that same as the field in the query (example fname). When I preview the report, it doesn't display any information from the cursor. I have been trying to make this work for 3 days now, but it still doesn't work. I am missing a step some where?
>
>is is the code I typed in:
>
>
>cTable = 'sometable'
>
>
>select fname, totpay, fica, retire_amt, health_ins, retiree_med, ;
>unempins, wrkcompins, total_salary ;
>from payroll_tbl into cursor (cTable) where payroll_tbl.bdate = ldBDate
>
>
>select(cTable)
>report form test preview
>use
>
>Thanks
>Nick Patel
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform