Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy to . . . . with memo fields ????
Message
From
11/06/1999 09:22:51
 
 
To
10/06/1999 10:21:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00228357
Message ID:
00228720
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform