LiveCode Forums.

Could anyone give a basic rundown of what needs to happen to be able to read and update data from a foxpro dbf file? I know this is a pretty non-specific question, but I'm just looking for a place to start. I'm not having any luck as of yet.

Thanks!

Hello guitarpeggio,

First, use FoxPro to export your data to a tab-delimited text file. Now write a RunRev script to read the file or use the SQlite command line utility to import your data into an SQLite database. What exactly do you want to do with the data and where do you get stuck?

Best,

Mark

Thanks Mark,
I was hoping to create an app that will allow me to read and modify data from a table in the dbf without converting it. It's looking like I'll have to convert the files first, much like you suggested or get my hands on a copy of Visual Fox Pro to create the app. I'm completely new to all of this.

You could write a parser for it:
http://www.dbf2002.com/dbf-file-format.html

But that seems like a lot of work. Unless it's something you'd need to do frequently you may be better off with a simple export.