Snip..
>Hi Cetin:
>
>THe sample code I gave was just that, a sample. I just wanted to show the general idea of what I was ultimately going to do. I just wanted to show that I was initialized a variable to T, starting a transaction, making several method calls which return either T or F depending on the TABLEUPDATE() result. I only showed method UpdateTableA to show that I am updating a table, view or something. Updating the view is just one method that is called. UpdateTableB and UpdateTableC would do totally diferent things, but they would still return a boolean depending on the outcome. Sorry if I confused you. What I am trying to do right now is get the 2.6 base table to update, then I will actually write the transaction. I am typing the following at the command line:
>
>OPEN DATABASE Data
>SELECT 0
>USE TableA
>SELECT 0
> USE Data!ViewA
> CURSORSETPROP("buffering", 5, "ViewA")
> SELECT ViewA
> INSERT INTO ViewA(Dnis) VALUES("Test")
> TABLEUPDATE(2,.T., "ViewA")
>
>The record is in ViewA, but not in base table. TABLEUPDATE() returns F, AERROR() shows Error 1547, "Cannot insert an empty row from a view
>into its base table".
Hi Ed,
ViewA has just one base table-tableA or base tables-tableA, tableB etc.?
Cetin