Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy File Type SDF and Change Field Lengths?
Message
From
05/12/2005 17:34:00
 
 
To
05/12/2005 17:06:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01075080
Message ID:
01075137
Views:
16
This message has been marked as a message which has helped to the initial question of the thread.
>I tried that myself Fabio to no avail. It drops the two fields that use CAST() completely. No error, but the resultant file is missing those two fields.
>
>
This works for me
CREATE CURSOR REINREQ (AGENT_CODE N(6),ACCOUNT N(20),POLICY C(25))
APPEND BLANK 
REPLACE ACCOUNT  WITH 999999999999999
REPLACE POLICY WITH REPLICATE('D',25)
LOCATE
IF FOUND()
	SET FIELDS GLOBAL
	SET FIELDS TO AGENT_CODE, ACCOUNT=CAST(ACCOUNT AS C(9));
,		POLICY=CAST(POLICY AS C(14))
	BROWSE
	COPY TO SDFFILE TYPE SDF
	SET FIELDS TO
	MODIFY FILE SDFFILE.TXT
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform