Transfer data from FM to Foxpro

[milan]

Hi, I am a new member with only small experience about FM.

I need to transfer a field content to my Foxpro program.

Please imagine that I have a FM browser with an icon on that, when I click the icon, the FM should transfer a field content of a certain record to my Foxpro executable program.

Help me please how to do it.

Thank you very much.

[Vaughan]

You'll need to export the data from FMP, then import it into FoxPro.

[milan]

Thanx for advice, but I need to make it automatically, it does mean that the Foxpro should start by 1 click on a button from FM.

Milan Tran

Fairfax VA, USA

[douglasgifford]

I used to use FoxPro on the Mac (this would be fifteen or twenty years ago). I imagine you could script the export/import using the Windows scripting language (forgive my ingnorance, is it Visual Basic?) and trigger it from FileMaker.

Something you may have trouble with is that FoxPro, being a dBase descendant, has mostly fixed-length fields but supports variable-length fields in separate linked files. I would export the FM files as tab-delineated--I recall that FoxPro has no great trouble with them--but I'm unsure whether you'll be able to import any long strings into the variable-length fields in FoxPro. My recollection is that support for these fields was pretty poor. If your data is all short, this shouldn't be a problem but if you've got any long text fields, it may be.

Good luck.