Fichero plano
Me urge sacar informacion de una base de datos en fox pro y quiero saber como generar un fichero plano
1 Respuesta
Respuesta de padevoto
1
Una vez abierta la tabla tenes que ejecutar el comando.
COPY TO nombre_archivo TYPE SDF
Te adjunto el modleo de sentencia del COPY TO
COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]]
[FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
[Scope] [FOR lExpression1] [WHILE lExpression2] [[WITH] CDX]
| [[WITH] PRODUCTION] [NOOPTIMIZE]
[[TYPE] [FOXPLUS | FOX2X | DIF | MOD
| SDF | SYLK | WK1 | WKS | WR1 | WRK | CSV | | XLS | XL5
| DELIMITED [WITH Delimiter | WITH BLANK | WITH TAB
| WITH CHARACTER Delimiter]]] [AS nCodePage]
COPY TO nombre_archivo TYPE SDF
Te adjunto el modleo de sentencia del COPY TO
COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]]
[FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
[Scope] [FOR lExpression1] [WHILE lExpression2] [[WITH] CDX]
| [[WITH] PRODUCTION] [NOOPTIMIZE]
[[TYPE] [FOXPLUS | FOX2X | DIF | MOD
| SDF | SYLK | WK1 | WKS | WR1 | WRK | CSV | | XLS | XL5
| DELIMITED [WITH Delimiter | WITH BLANK | WITH TAB
| WITH CHARACTER Delimiter]]] [AS nCodePage]
