Inserting Records into a Foxpro Database

[rpack78]

I am having problems inserting records into a Foxpro database. I was using DBD::XBase which works great, but it does not provide support for indexes. Because of this, each record inserted into the db by my script does not show up in the software that uses the db (SMART - a student software package). If I reindex the tables, the records show up. I cannot just keep reindexing the tables because no one can be logged in to the SMART software when I do it.

Does anyone know of a module that will update my indexes when I add a record? I have tried DBD::ODBC, and Win32::ODBC, but I cannot even connect properly. It says that the Microsoft Visual FoxPro driver does not support the action I am trying to use. Any help will be greatly appreciated.

Ryan

 

[rpack78]

Anyone even use FoxPro these days?

Ryan

 

[PaulTEG]

Ryan,

obscurity as a function of time on market could be the issue here.

Is it possible to write a batch file to execute a query at regular intervals on the *doze machine, and schedule using AT, WinAT, or even the 98 task scheduler.

batch file - open an excel spreadsheet with an Auto_start macro which calls the funtions from the FoxPro DB, or even a FoxPro application whose onload event is to fire the index functions you mention

Could be a goose chase, but it could always be the bronze one....

HTH
--Paul


It's important in life to always strike a happy medium, so if you see someone with a crystal ball, and a smile on their face ... smack the fecker

 

[rpack78]

I wouldn't even know where to start with that option. I know Perl. That's about it. Surely Perl can handle this. It can do anything, right?

Thanks for the suggestion.

Ryan

 

[PaulTEG]

Not if the drivers aren't up to it, have looked fro more up to date drivers?

--Paul

Nancy Griffith - songstress extraordinaire,
and composer of the snipers anthem "From a distance ...

 

[rpack78]

Yes, I intalled the latest from Microsoft. Still get the same error.

Ryan

 

[PaulTEG]

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

from the above?

--Paul

Nancy Griffith - songstress extraordinaire,
and composer of the snipers anthem "From a distance ...

 

[rpack78]

I'm pretty sure that's the one I installed. I'll try it again tonight. Thanks.

Ryan