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