>>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,

Have you tried opening the files with NOUPDATE. I'm using this to stop VFP 5 from prompting for a Code Page until we (Management) decides how we are going to handle table upgrades.

Fred L
flauckner@paraengr.com