Advice Required

[Robert Mills]

Just after sending my original post I realised that my request was too
vague. Here is another go.

Having never used Quiz in a Client/Server environment I'm in need of
advice on which direction to go.

A) We could have Quiz on the Unix/Oracle box using cron (or something
similar) to run the production reports. Question is how would the users
interact with it from their Windows/Desktop (ad-hoc reports)?

B) We could have Quiz on the Windows/Desktop accessing Oracle via ODBC
(or something similar) to run the ad-hoc reports. Question is how and
where do we run the production reports? Shouldn't they be run on the
Unix/Oracle box?

C) Should we go Axiant? That would work OK for the ad-hoc reports but
what about the production reports?

D) Is there a different way to do it or do we require a combination of
the above three options?

E) Can database views be used by Quiz (in a Cursor?)?

F) Anything else you might think of that can trip us up <G>.

As you can see, lots of question and no answers (yet).


regards, 
  
Robert W.Mills 
MIS Systems Development Manager 
Windsong Services 
+44 (0)20 8309 3604 


-----Original Message-----
From:
powerh-l-bounces+robert.mills=windsong-services.co.uk at lists.sowder.com
[mailto:powerh-l-bounces+robert.mills=windsong-services.co.uk at lists.sowd
er.com] On Behalf Of Peter Bateman
Sent: 20 April 2006 16:27
To: powerh-l at lists.sowder.com
Subject: RE: Advice Required

Hi Robert:


  1) QUIZ can retrieve a result set from a stored procedure ( actually
from a package )

   or 2) QUIZ can retrieve data through a cursor

   or 3) QUIZ can use tables in a manner similiar to indexed file.

I would choose option 2 .
if your thinking of using some other reporting tool you could save
yourself sometime by using 1 if the new tool allows stored procedure
calls .


You can link to a cursor by having host variables define in structures 
higher up in the access statement.
SQL IN <DB> DECLARE XCURSOR CURSOR FOR SELECT A, B, C FROM X WHERE X.Y =

:SUBY
; SUBY is an item in SUBFILE
e.g. ACCESS *SUBFILE LINK TO XCURSOR

Regards,
PETER

_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet
has 
to offer.  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU
=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN(r) Premium right now and get
the 
first two months FREE*.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.