Member Avatar for sunil01

Guys plz hlp me out on this '
I created 2 tables and addressid is joining both my tables, only manage to show one table in data grid ' if two tables r showing (its either duplicating sum rows by ( expr1) or i can't add a new record in any of the table.I think my problem sits in query builder after i click finish its givin me error on insert and update' plz gve me right code to put in query builder so dt i can show both tables in datagrid without duplicating rows and i be able to save records in both tables at run time .
Thanks in advance

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

A view or joins is a virtual table meaning it does not exist as a table. Yes a view or joins is an schema object but it is only as such view . It is a view of a table ot joined tables. If you are updating a field from a view you are not updating the view but the table which that view is based upon. No you cannot update a view only the table a view is based upon.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.