Information générale
Catégorie:
The Mere Mortals Framework
I'm getting a 1547 "Cannot insert an empty row from a view into its base table(s)" when I try to save a new record.
I'm using a cBizObjMaintenanceForm, but am not using the built in bizObj for the grid on Page 1. In my view for the bizobj that I dropped on page 1 (the grid page), I've got two tables, joined with a left outer join. Only the left table is updatable (if I've got my terminology straight). I'm using a left outer join as I want to see all records from the left table in the grid, and only some of them have entries in the right table.
I can't do a browse on the view to see what's there, as that just triggers the error again. I'm assuming that the empty row and base table mentioned in the error message are referring to the right hand table, as I have entered some data for the left hand table, and if I put someof the fields in the watch window of the debugger, the info appears.
Given the error I'm getting, I assume that having two tables in an update view, even if only 1 of them is updatable, is not the right way to do this? Should I be adding a bizobj for the righthand table, and either set up a child relation or do a manual lookup of the info I need from the righthand table? Or is there another way to show some data from a second table, if it exists? Maybe add a parametereized view of the second table to the dataenvironment of the bizobj for the first table?
Thanks,
June
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement