Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy File Type SDF and Change Field Lengths?
Message
De
05/12/2005 17:34:00
 
 
À
05/12/2005 17:06:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01075080
Message ID:
01075137
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform