>I am trying to access Visual FoxPro 5.0 tables from a VB 5.0 application and I have three questions:
>
>1. Can I reindex the database from VB?
>2. Can I pack and remove records marked for deletion from VB?
>3. I have written a stored procedure to generate an incremental index for new records in my tables. This procedure
>works well in VFP, but when I add records from VB it doesn't work at all. Why is this? I thought stored procedures were supported for external access as long as they didn't contain unsupported XBase commands, as specified in the VFP ODBC driver help file?
>
>Thanks,
>
>Brian Hartin
>MCI Telecommunications
>Brian.Hartin@MCI.Com
Brian,
Looks like there needs to be better peer support in this forum! Anyway, here is my, somewhat small, experience working with Foxpro tables with VB. I've tried to access Foxpro tables using VB4 before without success. I couldn't do those things you are inquiring (reindex, pack, etc) and in addition, could'nt find a way to not show deleted records. VB, it seems, gives you access to add, edit, view but nothing more. I haven't worked with VB5 or VFP ODBC drivers yet but I don't believe too much have changed.
My suggestion is to use Visual Foxpro 5.0 for front end or use third-party database manager (like CodeBase from Sequiter Software Inc.) to access the tables.
John
It's "my" world. You're just living in it.