IonicWind Software

IWBasic => Database => Topic started by: billhsln on October 26, 2010, 02:30:41 AM

Title: DBF Creation
Post by: billhsln on October 26, 2010, 02:30:41 AM
We have a command to create MDB (Microsoft Access) files [dbCreateMDB(GETSTARTPATH+"BookShop.mdb")], but how would we create a dBase (DBF) file?

Thanks,
Bill
Title: Re: DBF Creation
Post by: LarryMc on October 26, 2010, 07:48:35 AM
I would think you'd have to use the appropriate dbf driver and then use the appropriate SQL create command string.

But I've never done that( used to create a dbf file)
I have used IWB to read Foxpro dbf files.

LarryMc
Title: Re: DBF Creation
Post by: billhsln on October 26, 2010, 09:21:23 AM
I was just thinking that since it requires a special command to create a MDB file, it would also require one for a DBF file.

Bill
Title: Re: DBF Creation
Post by: Brian on October 26, 2010, 11:43:03 AM
Billhsln,

Assuming that you have checked Control Panel > Administrative Tools > Data Sources (ODBC)
and verified that the dBase driver is loaded (usually is by default; if not, you would have to
use the Add button to include the driver in the list)

Then it would be something like:

pDB=dbConnect("Microsoft dBase Driver (*.dbf)",dbf_filename,"")

Brian