I'm writing a small program for a client which mainly updates a SQL Server
database. No problem there. However, there is an additional table that forms
part of a FoxPro system which I also have to update, and this is kind of new
territory here. The original designer of the table used the reserved work
"value" as a field name, and if I try to perform an UPDATE statement against
it then it gets rejected by ODBC. My only alternative is to delete and then
reinsert the record, which does actually work. However, because deleted
records in FoxPro are only marked as deleted I then need to "Pack" the table
to clear out the old record. Anybody know how to do this with the ODBC
driver? My only workaround at the moment has been to write a small FoxPro
utility that separately does the pack, but it would be soooo much tidier to
do it from the main VB.net app.

Hi,

You can pack a VFP table with the code similar to the following:
        Dim cn As OdbcConnection
        cn = New OdbcConnection("Driver={Microsoft Visual FoxPro
Driver};SourceType=DBF;SourceDB=c:\dbfpath;")
        Dim mystring As String = "SET EXCLUSIVE ON;PACK Table1"
        Dim cmd As OdbcCommand = New OdbcCommand(mystring, cn)
        cn.Open()
        cmd.ExecuteNonQuery()
        cn.Close()

Here is a related article that you can check for more information:
HOWTO: Pack a Table Through the Visual FoxPro ODBC Driver (VFPODBC.dll)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q234756

Regards,
Elan Zhou
This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net?  http://www.gotdotnet.com