Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scatter and Gather
Message
De
12/11/2015 18:16:28
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Scatter and Gather
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01627387
Message ID:
01627387
Vues:
138
Hello comunity

I have a problem about using Scatter gather vfp command.
on my original cursor teste i have the following information

conta debit credit
318111 1000
318111 1000
321 1000
24321 230
221111 1230

I build this command

Select * From teste Into Cursor myTemp Readwrite
Select myTemp
Scan
Scatter Memvar
Delete For Conta = '318'
Replace Conta With '225111' For Conta = '321'
Insert Into teste From Memvar
Endscan

But if i make a browse to my original cursor teste i have this information

conta debit credit
318111 1000
318111 1000
321 1000
24321 230
221111 1230
318111 1000

but if i make browse on MyTemp the result is correct:

22511 1000
24321 230
221111 1230

How can i do to replace the content of my original cursor teste with the values of cursor MyTemp ??

Many thanks
Best regards
LSantos
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform