How can I use "e" parameter to get relevant parent row so that I can get values from parent row.
Private Sub myAdapter_RowUpdated(ByVal sender As Object, ByVal e As OracleRowUpdatedEventArgs)
......
End If
I've changed the InsertCommand of the product category table adapter as follows and created a trigger at database level to assign next value of sequence to PK column. But still getting error if I leave category_id blank. I also want to retrieve the value of the category_id back from database...
I'm trying to build a master-detail form using two DataGridView's based on Oracle 11g Database in VB.net (Enterprise 2015). It is a setup form to define categories (category_id, title, status) and sub categories (sub_cat_id, category_id, title, status). I've followed this example to build the...
I've two related DataGridViews for prod_category & prod_sub_category tables. I've used a text box to run FillBy method on prod_category table adapter to search records. But when I press any key in the search text box I get "Cannot clear table prod_category because ForeignKeyConstraint...
I've tried to develop the form according you the example given by you but got same error message.
You cannot add or change a record because a related record is required in table.
Can you pl identify my mistake.
Thanks for your reply. Your assumption is correct that I get this error upon saving. I'm actually Oracle programmer and never had to worry about such things while developing forms in Oracle. In Oracle forms, a pre-insert trigger on relevant block resolves such problems.
I will try to do some...
I've a setup form where master as well as detail block are displayed as datagridviews. I'm getting following error message when I enter a record in master block and corresponding records in detail block and then press save button. I think this message is displayed due to negative values in...
I've created custom table adapter based on following parameterized query. It should get a product_id as parameter to get all of its packaging details. The PROD_PACKING table has a self-join on PARENT_PACK_ID to PACK_ID. The problem is how may I provide the parameter.
SELECT a.pack_id...
I've a DataGridView based on PROD_PACKING table. The type of PARENT_PACK_ID column is changed to Combo Box. To populate its values I defined a custom query getPackings(product_id) inside the prod_packingTableAdapter that returns PACK_ID, PACK_TYPE based on PRODUCT_ID parameter.
PACK_ID...
I am developing a Sales application with MS Access Database. I've added Data Source through wizard and created forms with Data Set.
It is sometimes required to do some other query/dml inside the form code. Is it possible to use the same Connection as my application is using or I've to open a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.