Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting from CA cursor
Message
From
09/06/2015 15:30:08
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
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:
01620810
Views:
44
>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?

BUFFERING is what you are missing, probably

try
select;
 cur1.*;
 from ca_cursor AS Cur 1 WITH (BUFFERING=.T.);
into cursor tempcurs;
where Cuzr1.SEL_WO_REC
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform