>Hello all and a happy new year,
>
>I'm trying to copy the data from a file structure into an Excel spreadsheet. I'm particularly interested in the "Fields Comments" field, and others, which do not copy with the "Copy Stru Extended" command. I can copy fields from a data table into Excel but how do I access the "data" from a table structure? TIA.
>
>Regards,
>
>Paige
You could do something like this - I used a long character field instead of a memo field since memo fields do not copy into Excel.
use mytable
set database to (cursorget("database"))
copy structure extended to mytablestru
alter table mytablestru add column field_cmt c(254)
sele mytablestru
repl field_cmt with dbgetprop("mytable."+allt(field_name), "field","comment") all
Insanity: Doing the same thing over and over and expecting different results.