Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace
Message
From
19/05/2011 05:38:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Replace
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01511100
Message ID:
01511100
Views:
94
hi all,

i need help to replace value as ....
flg1  empno value   a1   b1  c1 d1
a      1    10      
b      1    15 
c      1    20 
d      1    30

*************************************
flg1  empno value   a1   b1  c1 d1
a      2    10      
b      2    15 
d      2    30

*************************************

flg1  empno value   a1   b1  c1 d1
     
b      3    12

*************************************result

flg1  empno value   a1   b1  c1 d1
a      1    10      10   15  20 30
*************************
a      2    10      10   15   0  30
***********************************
b      3     12     0    12   0  0
thanks
Next
Reply
Map
View

Click here to load this message in the networking platform