Write a query for creating an Updateable view.
#1

PROGRAM CODE:
create view vw_client as
select client_no, name, address1, bal_due
from client_master;

insert into vw_client values('C00110','Robert','40/2, Vinayak Nagar', 1000);

update vw_client set bal_due=12000 where client_no='C00110';

delete vw_client where client_no='C00110';

OUTPUT:
[attachment=14367]
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: how to write cv for english, how to write student resume, project on creating website, how to write project requirements, how to write a course book, creating webseminars, austin inurl write for us,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  What are steps involved in creating a form in Access? smart paper boy 0 1,279 29-07-2011, 12:15 PM
Last Post: smart paper boy
  How to create a query in Microsoft Access? smart paper boy 0 1,156 29-07-2011, 12:14 PM
Last Post: smart paper boy
  To write a program to print “Hello World” in CORBA. smart paper boy 0 2,008 21-07-2011, 09:52 AM
Last Post: smart paper boy
  To write a C# program to perform encryption and decryption of the given data. smart paper boy 0 1,807 21-07-2011, 09:50 AM
Last Post: smart paper boy
  To write a program in C# to perform conversion of dollars to rupees smart paper boy 0 1,810 21-07-2011, 09:48 AM
Last Post: smart paper boy
  Write a query that will accept an account no smart paper boy 0 1,130 09-07-2011, 10:50 AM
Last Post: smart paper boy
  Create a view on the Client_master table for administration department. smart paper boy 0 1,217 09-07-2011, 10:43 AM
Last Post: smart paper boy
  Write a C Program to declare an array for 2 0 floats. Accept the values from the user smart paper boy 0 1,428 20-06-2011, 11:41 AM
Last Post: smart paper boy

Forum Jump: