Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select and append
Message
 
 
To
02/09/2008 02:56:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01343606
Message ID:
01344035
Views:
15
I forgot quotes
... EVALUATE(FIELD(i,"qasem"))
>i try as below , 2errors message 1.alias not found, i choise my table 2.file is in use
>
>SELECT qasem
>SCAN
>	FOR i=3 TO FCOUNT()
>		INSERT INTO newtable (no,name, fvalue) VALUES (qasem.no,qasem.name, EVALUATE(FIELD(i,qasem)))		
>	ENDFOR
>	APPEND BLANK IN newtable 
>ENDSCAN
>
>
>>
>>SELECT mytable
>>SCAN
>>	FOR i=3 TO FCOUNT()
>>		INSERT INTO newtable (no,name, fvalue) VALUES (mytable.no,mytable.name, EVALUATE(FIELD(i,mytable)))		
>>	ENDFOR
>>	APPEND BLANK IN newtable 
>>ENDSCAN
>>
>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform