Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scatter and Gather
Message
From
12/11/2015 18:16:28
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Scatter and Gather
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01627387
Message ID:
01627387
Views:
140
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
Next
Reply
Map
View

Click here to load this message in the networking platform