Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting from CA cursor
Message
De
09/06/2015 15:30:08
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01620804
Message ID:
01620810
Vues:
43
>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]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform