>I'm trying to grab some data from a number of FoxPlus tables using either FP 2.6 or VFP 5.0.
>
>The source tables are generated by a commercial application (so I can't change it or the original tables) which runs 24/7. Trying to programmatically copy and use the tables gets me a dialog box asking if I want to convert memo fields (which I don't need). The problem is that I want my app to ping these tables every 15 minutes or so, so I can't have a warm body standing by just to acknowledge the dialog box.
>
>Is there a way to:
> 1) grab just the fields that I want; or,
> 2) convert the FoxPlus tables on the fly without the dialog box?
>
>I'm using FPD 2.6 and VFP 5.0 Enterprise and don't care which platform I might get a solution for.
>
>Thanks for taking the time to read this.
>Paul M.
>abbtnd@erols.com
Paul,
Have you tried using an SQL SELECT on these tables? I don't know whether or not you'd be able to. Optionally, you could create an array (using AFIELDS), then a cursor from that and append the data in.
hth,
George
Ubi caritas et amor, deus ibi est