Table I/Os on Business Views

Hi JDEList,

Does anybody used BSVW with Insert, Update, Delete table operations?

How does it work? What is the difference when you done this with BSVW instead of tables?

How does it work, when you use joined BSVW?

What are pros and cons using tables and BSVW in Update, Insert, delete?

All information or pointing to a documentation will appreciated.

Regards,

Zoltán

The best thing of use BSVW is that you are going to use only the fields that
you need.
For example if you use the table F42119 (this table have about 200 fields)
is better to use a BSVW because, perhaps, you only need 10 fields and your
sql sentece will be more faster.
----------------------------------------------------------------------------
-----
B733 - SP 20_J1 / ES NT - W2K - ORACLE 8i / Clients - W98 , W2K Pro , XP Pro



This email may contain confidential material. If you were not an
intended recipient, please notify the sender and delete all copies.
We may monitor email to and from our network.



--------------------------------------------------------------------
--------------------------------------------------------------------
B733 SP11.2 -->SP 20 ORACLE 8.1.7 W2000

I _used_to_ try using table io against bsvws.

I kept having goofy things happen, such as,
Deletes wouldn't perform when using a partial key (highest key values filled in),
Updates would blank out the values that I didn't pass, and others.

The issue w/UPDATES happened when coding a ube several weeks ago.

I don't know if there are reasons WHY this happens,never having the time, or inclination, to research it.
Sloth IS one of my stronger traits.....

btw - we're on SP 22.
I guess I'd better fix my sig file.
There's that SLOTH THING again.....

Hi Gene and Daniel,

Thanks for your responses.

I am really curious to, that how does it work on join BSVW.

Regards,

Zoltán