<i><font color="#663300">But, when I use the remote view in the form, the data is not sent back to the Oracle table. I click on the new button (call thisform.new()), which sets up the new record in the view, with the default value in the nid field, newid() from the view properties. All is working fine up til now. When I click save (call the thisform.save()) everything seems to work fine in the code, but the record is never sent to the Oracle table. The TableUpdate returns .T., which gives me the "information saved" wait window. My assumption is that the 'TABLEUPDATE()' would just simply do the job, without any other coding involved, other than setting up the ODBC and the remote views to be updateable.</font></i>
If you open the view from the Command Window and modify it, do the changes get sent to the Oracle table when you issue TABLEUPDATE()? Are you sure you have the "Send SQL Updates" checkbox checked?
<font color="#cc0000"> ___/
/
__/
/
____/</font>
Ed Leafe
©2002 Ed Leafe |
