Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you ROLLBACK a view
Message
From
06/03/1998 12:10:16
Edward Crawford
City Facilities Management
Glasgow, United Kingdom
 
 
To
06/03/1998 11:33:11
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00082524
Message ID:
00083043
Views:
37
>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

Just one base table. I have to do it through a view because it is a 2.6 table, and I can't include it in a database. So if I want to roll it back, I need to do it with an updataable view.

Ed
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform