Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy to . . . . with memo fields ????
Message
De
11/06/1999 09:22:51
 
 
À
10/06/1999 10:21:16
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:
00228720
Vues:
13
>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,

Thanks for the info. I'll see what I can come up with.

Jamie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform