<i><font color="#663300"><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></i>
Hey Ed,
This was a frustrating exercise, but I found the answer this morning. It is pathetic.
When I was testing I noticed that I would get a 'Driver not capable' error. After I clicked OK to that error message, I received the MESSAGEBOX that asked if I wanted to save my changes first, which was being fired by the QueryUnload event of the form. The data in the child views was then saved to the Oracle tables. I did not notice until this morning that the QueryUnload event calls the SAVE() method using the .T. parameter. I changed the call to the save method in my form command group to send the .T. parameter and now ALL the rows are saved to the Oracle tables. UGH!
Lesson learned, now all I have to do is figure out how to have the CodeBook login double as the Oracle login and use the name and password from the login as the basis for the remote view connections, so I can use Oracle roles to administer rights to data manipulation and the CodeBook security to enable/disable controls in the Framework (whew!). Any ideas you have on this subject would be greatly appreciated. Considering it took me three days to figure out that I needed to pass a parameter to the save method, this next topic could take months of work, which I really do not have.
Devman
mdevlin (at) ajdebruin .DOT com
©2002 Mike Devlin |
