Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy to . . . . with memo fields ????
Message
From
10/06/1999 10:21:16
 
 
To
10/06/1999 09:40:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00228357
Message ID:
00228376
Views:
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 Sherman
-Wake Up! Smell the Coffee!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform