You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by stamilo <st...@gmail.com> on 2008/06/16 10:09:38 UTC
how to insert data into view table
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!
Re: how to insert data into view table
Posted by David E Jones <jo...@hotwaxmedia.com>.
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 <
> vijaywargiya.ashish@gmail.com> 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 <bi...@iguanait.com>
>> wrote:
>>
>>>
>>> hi,
>>>
>>> view entities are joined entities, so you have to insert the data in
>>> member entities of the view entity.
>>>
>>> Bilgin
>>>
>>>
>>
Re: how to insert data into view table
Posted by Bilgin Ibryam <bi...@iguanait.com>.
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."
Re: how to insert data into view table
Posted by stamilo <st...@gmail.com>.
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 <
vijaywargiya.ashish@gmail.com> 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 <bi...@iguanait.com>
> wrote:
>
> >
> > hi,
> >
> > view entities are joined entities, so you have to insert the data in
> > member entities of the view entity.
> >
> > Bilgin
> >
> >
>
Re: how to insert data into view table
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
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 <bi...@iguanait.com> wrote:
>
> hi,
>
> view entities are joined entities, so you have to insert the data in
> member entities of the view entity.
>
> Bilgin
>
>
Re: how to insert data into view table
Posted by Bilgin Ibryam <bi...@iguanait.com>.
hi,
view entities are joined entities, so you have to insert the data in
member entities of the view entity.
Bilgin
Re: how to insert data into view table
Posted by Jacques Le Roux <ja...@les7arts.com>.
You can't views are build dynamically by the Entiy Engine... But you may insert data in the related entities...
Jacques
From: "stamilo" <st...@gmail.com>
> 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!
>