All~

I am writing a VB 5 app which accesses data in a Visual FoxPro 5 database using ODBC Direct. I have one connection object created as follows:

' Create an ODBCDirect workspace.
Set wrkLabor = CreateWorkspace("ODBCWorkspace", "admin", "", dbUseODBC)

' Create ab ODBCDirect connection (analogous to a Jet database object)
Set conLabor = wrkLabor.OpenConnection("isnlabor", dbDriverNoPrompt, False, strConnect)

I have one SQL statement that will not work. It works fine from within FoxPro, and all of my other SQL statements work fine. Here is the statement:

update qseltest set qseltest.used = (qseltest.used + 5)

It is worth noting that qseltest is a local view. I have examined its properties and it appears to be updatable (as I mentioned earlier, I am able to use the above SQL statement to update this view from within FoxPro).

Thanks in advance for your help.

Brian Hartin
MCI Telecommunications
brian.hartin@MCI.Com