Re: [DataVision-users] few questions

[<Mar...@dp...>]

Jim, Julien, et al

you can certainly create a view that utilises a stored procedure (at least 
in oracle).

something along the lines of 

create or replace view viewname ( Col1, Col2, Col3, Col4, Col5, Col6)
as select Col1, Col2, Col3, schema.procedure.function1(Col1, Col2, Col3), 
schema.procedure.function2(Col1, Col2, Col3), 
schema.procedure.function3(Col1, Col2, Col3))
from table(s)
etc..

where you have written a procedure package with functions to return 
whatever output is required for Columns 4, 5, 6 etc

I have found it more efficient to write the view without the function 
calls, but use them instead as user columns in datavision.

Then the view doesn't have to do any of the computational stuff on all 
rows and it's only done on the selected records, although that may be 
wrong depending on whether datavision does the select or the user columns 
first. As I write this I'm thinking it might have to evaluate the user 
columns first in case they are used in the select.





Julien,

On Aug 22, 2004, at 11:52 AM, Julien TOUCHE wrote:

> On Thu, Aug 19, 2004 at 08:52:48AM -0400, Jim Menard wrote:
>> >one note, this proc has 3 columns-output
>> DataVision is stupid, and can only handle a single column of output 
>> for each user column.
>> Can you create a view that gives DataVision the columns as three 
>> separate columns and the use the view in the report?
> could you explain it more ? the view is in datavision or in the 
> database
> ? if it's datavision, how could i describe each column ?

In the database. I'm no database expert, so I don't even know if this 
is possible. Could you create a view that is created/populated by 
calling the stored procedure and that obtains three columns' values 
from the call?

Does anybody else on the list have any ideas?

Jim
-- 
Jim Menard, ji...@io..., http://www.io.com/~jimm/
"The American legal system is, of course, just the British kernel with a
shorter uptime and a few clumsy security patches slapped in."
     -- www.ntk.net



-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
DataVision-users mailing list
Dat...@li...
https://lists.sourceforge.net/lists/listinfo/datavision-users