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?
