Displaying Reports on a screen, Scheduling - in AXIANT 4GL

[Joe Boyle]

and I am certain that the quiz report viewer worked perfectly well as long
as the netd was running on a NT/Windows server. Of course, if you need a
txt/disk file anyway, you might as well use the Winexec approach.

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
Glenn Baxter
Sent: 26 July 2005 00:45
To: 'Syed Shahul Hameed Mustaffa'
Cc: powerh-l at lists.sowder.com
Subject: RE: Displaying Reports on a screen, Scheduling - in AXIANT 4GL

Hi Syed, 
We have completed the migration of an MPEIX code base to Axiant thin client
which now runs under NT Server 2000 using SQL Server 2000. 

My experience with Quiz reporting, under thin client, is that Set Report
Device Terminal is not supported/not practical, as the code does execute "at
the server" under its own NETD session, essentially; although aware of the
remote clients IP address, QUIZ/NETD will not route output back to the user.

The same occurs for any "parm prompt" items you may use throughout reports
or runs i.e. the input request occurs within the server NETD session.

Task Execution
We have developed an SQL Server/Powerhouse/Visual Basic application which
manages all of 
a) parms and prompts
b) printer choice and copies, where all quiz reports run compiled, with "set
report device disc" as the output option.
c) execution of the "freshly built" command files is either "on-line" via
the "command /c {\\path\commandfilename.bat} resulting in an hourglass to
the user OR for long or scheduled tasks we have an integration with a
product called WINCRON - essentially similar to the AT command set.
The application provides a common interface to all executed tasks and
prompts though a variable form, generated at execution at the thin client
end.
It creates server executable "bat" files, containing all "executable" or OS
commands.

Reporting
We direct all reports to a "user" folder, named REPORT1_DATA_TIME.TXT and
provide a Winexec "hook" to Explorer "passing" within the available command
line argument feature the constructed path to the users reports folder. This
allows each user to see all of her/his reports. A double click then uses any
existing registry associations to the ".TXT" extension. No pathing is
required under Win98/2000/Xp to run Explorer.
It is one extra step though, which users have become used to. They also
enjoy the ability to view their "library" of personal reports.

Environment
This is all controlled through the use of environment variables, which
declare all of:
a) the PHServer
b) the Environment {Dev or Production}
c) the Application {We have 2, this is set within Powerhouse/Quick enabling
the user to run many applications at 1 time}
d) the user then for each user
e) a reports folder
f} a submit or command file folder
g) a parms folder within submit
h) a logs folder, for all run/report/bat file statistics - creating an NT
Version of $STDLISTS which are fantastic for production analysis
These are set via the SETX program on each client, and from control panel at
the server.

We opted to approach this method in order to standardise development,
deployment and finally production, to great success to this point.

I would be happy to provide more information as required
Sincerely
Glenn Baxter
=======================
Baxter IT Solutions Pty Ltd
456 Victoria Parade, East Melbourne
Victoria, Australia 3002
p: 03-9415-8733
m: 0412-826-503
f: 03-9415-8911
e: glenn at baxterit.com.au
=======================
-----Original Message-----
From: shulbert at clblf.com [mailto:shulbert at clblf.com] 
Sent: Monday, 25 July 2005 10:14 PM
To: sshahulgm at gmail.com
Cc: powerh-l at lists.sowder.com
Subject: RE: Displaying Reports on a screen, Scheduling - in AXIANT 4GL

syed,
1. remember that any processing in thin client is done on the server side.
using "run command notepad.exe" will open a notepad session on the server
and wait for it to return, giving the "hang" behaviour you describe. there
is a winexec command object you should use instead to open notepad. this
must use the full path to notepad.exe, check to see if it's different on the
client machines (ie 2000 (c:\winnt) vs XP (c:\windows)). notepad should open
the text file locally, so if it's stored on a network drive open a shared
drive to it.
2. command line scheduling in windows is done via the AT command. use "at
/?" to get help for this. be aware that users running this command must be
members of the administrator group of the machine that it is run on. you may
or may not consider this wise.
regards,
stephen.


 -----Original Message-----
From: 	sshahulgm at gmail.com [mailto:sshahulgm at gmail.com] Sent:	Monday, July
25, 2005 1:02 PM
To:	powerh-l at lists.sowder.com
Subject:	Displaying Reports on a screen, Scheduling - in AXIANT 4GL

Hi Gurus,

Simple Introduction: I'm migrating an PH/MPEIX application to AXIANT
4GL (Thin Client)/WINDOWS.

I have 2 functionalities in PH / MPEIX that doesn't seem to have an
equivalent in AXIANT 4GL. (Thin Client).

1. Displaying the reports on the screen. I sent the output to a text
file and tried to open it using notepad.exe through 'run command'. The
system appears to be hanging.

2. In MPE/IX the reports and qtps are streamed as scheduled jobs. How
can we achieve this streaming in a windows environment.

I'd appreciate any attempt to help solve these issues.

Best Regards,
SYED

-- = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" 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.



CLB Littlejohn Frazer
Chartered Accountants
1 Park Place
Canary Wharf
London
E14 4HJ

Tel 020 7987 5030
Fax 020 7987 9707
www.clblf.com

The information contained in this communication is confidential and may be
legally privileged.  It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it.  If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking of any action in reliance on the contents of
this information is strictly prohibited and may be unlawful.

CLB Littlejohn Frazer reserves the right to monitor the content of any
message sent to or from clblf.com.

A list of partners may be inspected at the above address which is also the
address for serving documents.

CLB Littlejohn Frazer is registered to carry on audit work by the Institute
of Chartered Accountants in England & Wales, and authorised and regulated by
the Financial Services Authority for investment business.

CLB Corporate Finance LLP is authorised and regulated by the Financial
Services Authority.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" 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 <password>" 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.