Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting from CA cursor
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01620804
Message ID:
01620809
Views:
48
>Hi,
>
>I am having a very strange (at least to me) problem. I have a cursor of CursorAdapter displayed in a grid. The cursor has a column SEL_WO_REC L bound to a check box. I click on the check box on a couple of records. Then in a command button click method I check the value of this column in the cursor (by using BROWSE command). The value is .T. for those records that I checked.
>Then I select records from this cursor as follows:
>
>
>select * from ca_cursor into cursor tempcurs
>
>
>But the value of this column in tempcurs is .F. for all records. And when I try to select records that have the column SEL_WO_REC true, nothing is selected. The code:
>
>select * from ca_cursor where SEL_WO_REC into tempcurs
>
>
>I tried to include NOFILTER into the SQL Select but it didn't make a difference.
>
>What am I missing?

Try adding

with (buffering = .t.) in your select statement.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform