problem updating an Oracle table using VFP remote views

Hello,
I have created a remote view of an Oracle table in a VFP database.

I then take this view offline , update it and want to update it back...I created the remote view using the View designer.

Then I essentially ran the following code:

    ( i found most of it in the Visual Foxpro developers guide)

createoffline ('rovview')

SET MULTILOCKS ON
If used ('rovview') Then
 use in rovview
endif

use rovview in 0

update rovview set Row12 = 'Hello' where Row1 like '2%'

use in rovview

Use rovview Online Exclusive &&This is supposed to reconnect to the database and open the view again...

hConn1 = CURSORGETPROP ( 'ConnectHandle' , 'Rovview')

SQLSETPROP ( hConn1 , 'TRANSACTIONS' , 2) &&Set transactions to manual.

IF NOT TABLEUPDATE ( 1 , .F. , 'rovview') Then  =SQLROLLBACK ( hConn1)
 MessageBox ( 'Cannot update)
else

 If SQLCOMMIT ( hConn1) = -1 Then
=Aerror ( errorArray)

  set step on
=SQLROLLBACK ( hConn1)

 endif
endif

I dont get any errors but the Oracle tables does not get updated too...

Am I doing anything wrong?

Thanks

Rajesh

rajesh_at_simulate.com Received on Thu Apr 02 1998 - 00:00:00 CST