Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement not working
Message
From
27/09/2001 18:02:30
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00561704
Message ID:
00561721
Views:
31
>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

Nick,
Since when a 'select ... into cursor ... ' by default sets current work area to that of cursors you don't need 'select (cName)' there. However that's not the point.
Would you check if your report dataenvironment has some table in it ?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform