>>>I tried the DBF() function and the function wouldn't work either.
>
>=> Memory-resident cursor so no file. So how about
>
>
Select *,12.45 as rte_base from a_slips into cursor rptfile readwrite where .f.
>
>I'm betting that you then load data from a_slips into this cursor- so maybe you can make the SELECT a lot smarter to get the data straight in there.
John
That's a good solution. Hmm why didn't I think of that?
I redimension'ed the array with the added column and that did the trick so this one is in the books
I came across another usage of ALTER TABLE in the same app, but it drops 2 columns in this case.
There are too many columns for me to go picking the ones I want in the SELECT, so I'll have to figure a clever workaround.
I'm thinking about using ADEL() to remove the unwanted columns from the array before creating the cursor.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.