if you have foxpro -- why not just use foxpro to manipulate it?
since they're doing it manually anyway; they can use sql to manipulate it
in
foxpro as well....
On Tue, 14 Aug 2007 04:46:18 -0700, Erasmus <JEErasmus@[EMAIL PROTECTED]
>
wrote:
>My company uses an industry-specific application based on an xBase
>structure with a "Microsoft .NET user interface". I'm not sure of the
>exact structure of the db files, although they won't im****t into MS
>Access as DBase III, IV or 5.
>
>My problem is that the user interface on this application makes
>changing certain features that are regularly changed quite time
>consuming and prone to errors (e.g. opening a seperate box for each
>change in input which doesn't even display the full filenames without
>scrolling across incredibly slowly blah blah blah). Foxpro doesn't
>really allow for particularly easy manipulation and changing of this
>information either.
>
>I set up an Excel spreadsheet which can read in one of my dbf files,
>allow the user to manipulate multiple inputs at once and then ex****ts
>it back to the dbf file - using SQL in VBA. This saves a lot of time.
>Great!
>
>I tried to do this for another aspect of the application, but the dbf
>I need to use has associated memo fields (and hence an fpt file). VBA
>is not really equipped to output back to the dbf file so I've been
>searching around for days to find another way. Unfortunately the
>company doesn't have much flexibility in the apps I can use but I am
>planning to install some applications on my home pc so that I can use
>C#, etc.
>We currently have foxpro and microsoft office apps at work. And
>obviously I can't download anyone's free solutions/frontends that are
>all over the web - I need to do it myself.
>
>I'm looking for a way to set up some kind of front end that will read
>the dbf files (I don't need to see the memo fields) and delete or add
>records as appropriate to the dbf file, without corrupting the links
>to the fpt file. Although the info in the fpt file is not entirely
>essential to keep. Can anyone please give me a hint of a direction to
>turn? Any language or setup to use?
|
