Advice Required

[Joe Boyle]

type this at google 'site:lists.sowder.com powerh-l' with any combination
like 'bat, ms, quiz, dos, print' and you should see a number of items worth
looking at.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Joe Boyle
Sent: 20 April 2006 19:51
To: 'Robert Mills'; powerh-l at lists.sowder.com
Subject: RE: Advice Required

Hi Robert,

are you saying that you are using PH 8.41 running on MS servers in order to
develop and maintain Quiz reports running against an Oracle database on a
UNIX box ?  If so, and as long as you can tnsping the database from the
windows side, you simply code your quiz as you would normally ( but in a DOS
shell), but I think the printing and quiz scheduling has to be done using
the MS 'AT' command or scheduler variant on the MS side; there is nothing to
execute on the UNIX end.

Regards, Joe.

-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Robert Mills
Sent: 20 April 2006 16:54
To: powerh-l at lists.sowder.com
Subject: RE: Advice Required

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.


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.