how to insert data into view table

[stamilo]

hi,
  i create a view entity, and i can read the view data in form ,
  but i can't insert data to the view,

   how ?

   thx!

[Bilgin Ibryam]

hi,

view entities are joined entities, so you have to insert the data in
member entities of the view entity.

Bilgin

[Ashish Vijaywargiya]

Physical existence of those entities(View entities) doesn't exists in the
database.
On fly it generates the details of records.

--
Ashish

On Mon, Jun 16, 2008 at 4:55 AM, Bilgin Ibryam <[hidden email]> wrote:

>
> hi,
>
> view entities are joined entities, so you have to insert the data in
> member entities of the view entity.
>
> Bilgin
>
>

[stamilo]

 thx,
 but  it's can insert data to view in SQL database,
  so i want to do that .

  :(

  thx !

On Mon, Jun 16, 2008 at 5:09 PM, Ashish Vijaywargiya <
[hidden email]> wrote:

> Physical existence of those entities(View entities) doesn't exists in the
> database.
> On fly it generates the details of records.
>
> --
> Ashish
>
> On Mon, Jun 16, 2008 at 4:55 AM, Bilgin Ibryam <[hidden email]>
> wrote:
>
> >
> > hi,
> >
> > view entities are joined entities, so you have to insert the data in
> > member entities of the view entity.
> >
> > Bilgin
> >
> >
>

[Bilgin Ibryam]

This was a tip from Adrian in another thread, but may help here too

"OFBiz View Entities don't actually create database views - they
simulate a database view by doing JOINs. So, you can build views in
OFBiz that won't affect the structure of your database."

[David E Jones]

Depending on how the view is defined the entity engine may actually do  
a create or update on the member entities of the view entity just  
fine. The is that the the full primary key of each member entity must  
be represented in the view entity, otherwise it is impossible to do  
the individual inserts or updates.

So, just try it as with any other entity and if it works then great,  
and if not then you know why. If you run into one that doesn't work  
and you think it should, please send the details to the list here.

-David


On Jun 16, 2008, at 3:23 AM, stamilo wrote:

> thx,
> but  it's can insert data to view in SQL database,
>  so i want to do that .
>
>  :(
>
>  thx !
>
> On Mon, Jun 16, 2008 at 5:09 PM, Ashish Vijaywargiya <
> [hidden email]> wrote:
>
>> Physical existence of those entities(View entities) doesn't exists  
>> in the
>> database.
>> On fly it generates the details of records.
>>
>> --
>> Ashish
>>
>> On Mon, Jun 16, 2008 at 4:55 AM, Bilgin Ibryam <[hidden email]>
>> wrote:
>>
>>>
>>> hi,
>>>
>>> view entities are joined entities, so you have to insert the data in
>>> member entities of the view entity.
>>>
>>> Bilgin
>>>
>>>
>>

[Jacques Le Roux]

You can't views are build dynamically by the Entiy Engine... But you may insert data in the related entities...

Jacques

From: "stamilo" <[hidden email]>
> hi,
>  i create a view entity, and i can read the view data in form ,
>  but i can't insert data to the view,
>
>   how ?
>
>   thx!
>