Unanswered: Update query (one for the VB programmers)
I am having trouble with an update query in oracle 9i. I am connecting to oracle via the oracle provider, from a vb6 program.
I have created an update query, which seems to work in Access 2000 (by 'linking' to the oracle database) but, strangely, does not work in VB (using ADO2.5 and the oracle provider).
Can anyone suggest what might be wrong with this query/Code snippet. I'm tearing my hair out here!
For purposes of clarity, the database in Oracle is called SCXDOWNLOAD and the table is called WESNET_SOURCES.
Any help you can give would be much appreciated. The error message I get (it's an error coming from the Oracle provider/driver is): ORA-00942: table or view does not exist.... Hmmm.... It's as if it thinks i'm passing a SELECT query rather than an UPDATE query.
Since there is a space restriction, I will post the code in the in the next message... Sorry.