Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy to . . . . with memo fields ????
Message
De
10/06/1999 10:21:16
 
 
À
10/06/1999 09:40:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00228357
Message ID:
00228376
Vues:
12
As far as I know, there is no good way to do this without writting a program, but it would be fairly easy to write a generic routine, maybe something like this:
procedure dumptable
* call with do dumptable with "outputfile.txt", "mytablealias"
lparameter outfile, alias
set printer to outfile
set print on
set console off
select (alias)
go top
scan
    for x = 1 to fcount()
         myfield = field(x)
         if x > 1 then
            ?? "|"
         endif
         ?? alltrim(padr(eval(myfield), len(eval(myfield)))
    next
    ?
endscan
set print off
set print to
set console on
return
* note!  This sucker is liable to die if there is a logical field, you might 
* need to test the field type before you do the ?? statement.
>Is there a way to copy a table with memo fields to a text file?
>
>Thanks,
>
>Jamie
--Todd Sherman
-Wake Up! Smell the Coffee!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform