Blue is curious
Jody Burgess ISP
jody.burgess@sewardconsulting.com
Thu, 17 Mar 2005 08:48:13 -0700
I've been using PH in an HPUX / Interbase DB and CISM Flat file environments
for a number of years and it seems to be very stable and easy to work with.
Jody Burgess ISP
780.702.5103
jody.burgess@sewardconsulting.com
www.sewardconsulting.com
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of
powerh-l-request@lists.sowder.com
Sent: Wednesday, March 16, 2005 3:52 PM
To: powerh-l@lists.sowder.com
Subject: powerh-l digest, Vol 1 #1281 - 12 msgs
Send powerh-l mailing list submissions to
powerh-l@lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request@lists.sowder.com
You can reach the person managing the list at
powerh-l-admin@lists.sowder.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."
Today's Topics:
1. RE:Blue is curious (Brett Greiner (Kinetix))
2. RE:Blue is curious (Johnson, Tracy)
3. RE:Blue is curious (Martijn Nabben (Fairfax))
4. RE:Blue is curious - hijack PH on OS/400 (Latimer, Richard)
5. RDB Blob issue (Johnson, Harold A EDUC:EX)
6. Question (Connie S. Loveland)
7. Removing Spaces (Ted Johnson)
8. Re: Question (Philip Jackson)
9. RE:Removing Spaces (Knox, Dave (Dallas, CSC))
10. Re: Question (Connie S. Loveland)
11. RE:Removing Spaces (brian_matthewsbrian matthews)
12. Re:Blue is curious (Murray Scholz)
--__--__--
Message: 1
Subject: RE: Blue is curious
Date: Thu, 17 Mar 2005 08:39:45 +1300
From: "Brett Greiner \(Kinetix\)" <Brett@Kinetix.co.nz>
To: "Robert Edis" <robeconsult@sbcglobal.net>,
"PowerHouse List" <powerh-l@lists.sowder.com>
Hi Blue,
1. AIX and CISAM files
2. DG and ISAM files
3. a DB
Cheers,
Brett.
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Robert Edis
Sent: Thursday, 17 March 2005 4:58 a.m.
To: PowerHouse List
Subject: Blue is curious
Dear listers.
May I impose on you to satiate my curiousity?
Would you mind telling me:
1. what environment (OS and DB) that you use PH in?
2. have you recently moved to this environment from another and if so
what was that?
3. are you thinking of or planning to move from your current environment
to another and if so what?
This is NOT for any commercial purpose: I'm just curious of what
platforms people are using PH on and the fluidity of those enviornments.
I'm particularly interested in where OpenVMS is with PH these days. I
have an emotional attachment to that platform though I've been working
in UNIX and NT since 1999.
Regards,
Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
--__--__--
Message: 2
Subject: RE: Blue is curious
Date: Wed, 16 Mar 2005 15:03:39 -0500
From: "Johnson, Tracy" <Tracy.Johnson@msiusa.com>
To: "PowerHouse List" <powerh-l@lists.sowder.com>
And I thought this subject was pr0n spam until I saw the replies coming
through.
BT
Tracy Johnson
MSI Schaevitz Sensors
--__--__--
Message: 3
From: "Martijn Nabben (Fairfax)" <Martijn.Nabben@fairfaxnz.co.nz>
To: PowerHouse List <powerh-l@lists.sowder.com>
Subject: RE: Blue is curious
Date: Thu, 17 Mar 2005 09:27:42 +1300
1. OpenVMS v7.3/RMS on MicroVAX 3100-95 with PH v7.10.G
2. a) MicroVAX 3100-95 and RMS since the late 80s (initiation)
b) OpenVMS v7.3 since early last year (2004) (v7.1 before)
c) PH v7.10.G since 1999 (v6 before)
3. Planning to move to Alpha with PH v8.40D
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Robert Edis
Sent: Thursday, 17 March 2005 4:58
To: PowerHouse List
Subject: Blue is curious
Dear listers.
May I impose on you to satiate my curiousity?
Would you mind telling me:
1. what environment (OS and DB) that you use PH in?
2. have you recently moved to this environment from
another and if so what was that?
3. are you thinking of or planning to move from your
current environment to another and if so what?
This is NOT for any commercial purpose: I'm just
curious of what platforms people are using PH on and
the fluidity of those enviornments.
I'm particularly interested in where OpenVMS is with
PH these days. I have an emotional attachment to that
platform though I've been working in UNIX and NT since
1999.
Regards,
Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
--__--__--
Message: 4
Subject: RE: Blue is curious - hijack PH on OS/400
Date: Thu, 17 Mar 2005 09:39:20 +1300
From: "Latimer, Richard" <richard.latimer@airways.co.nz>
To: "Deskin, Bob" <Bob.Deskin@Cognos.COM>, "Al Karman" <Alk@liasophia.com>
Cc: <powerh-l@lists.sowder.com>
MATURED - now there's an interesting simile for abandoned ...
Richard
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Deskin, Bob
Sent: Thursday, 17 March 2005 7:43 a.m.
To: Al Karman
Cc: powerh-l@lists.sowder.com
Subject: RE: Blue is curious
Since we've matured PowerHouse on AS/400, that wouldn't be an option.
Bob
-----Original Message-----
From: Al Karman [mailto:Alk@liasophia.com]
Sent: March 16, 2005 1:40 PM
To: Deskin, Bob
Cc: powerh-l@lists.sowder.com
Subject: RE: Blue is curious
Bob,
We're going OS/400.
Al Karman
Director of Information Technology
lia sophia
818 Thorndale Avenue
Bensenville, IL 60106-1138
Phone 630.860.3323
FAX 630.860.5634
alk@liasophia.com
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Deskin, Bob
Sent: Wednesday, March 16, 2005 12:13 PM
To: Al Karman
Cc: powerh-l@lists.sowder.com
Subject: RE: Blue is curious
Are you using OS/400 or AIX? If it's AIX, you can continue to use
PowerHouse.
Bob
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Al Karman
Sent: March 16, 2005 1:00 PM
To: powerh-l@lists.sowder.com
Subject: RE: Blue is curious
1. MPE/iX 6.0.0 / IMAGE
2. No
3. Yes...converting to iSeries platform, so...RPGIV/SQL for reporting
Al
Al Karman
Director of Information Technology
lia sophia
818 Thorndale Avenue
Bensenville, IL 60106-1138
alk@liasophia.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
This message may contain privileged and/or confidential
information. If you have received this e-mail in error or are not the
intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and
notify the sender promptly by e-mail that you have done so. Thank you.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
--
**********************************************************************
This electronic message together with any attachments is confidential. If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************
--__--__--
Message: 5
From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson@gems1.gov.bc.ca>
To: powerh-l@lists.sowder.com
Subject: RDB Blob issue
Date: Wed, 16 Mar 2005 13:17:23 -0800
Hi all. we recently upgraded our RDB DB to 7.1 and now get the following
error when touching a table containing a blob field when using 840d.
(viewable_letter_blob is the blob field) This works under 710g1. If you
don't reference the blob field, the access is ok.
any ideas?
cheers
> access letter_issued in sfas_database
> select if not viewable_letter_blob is null
> rep letter_idx
> go
*W* Data access error. (LETTER_ISSUED)
*W* DMS-E-GENERAL, A general exception has occurred during operation 'open
blob'. (LETTER_ISSUED)
*W* %SQL-F-CURALROPE, Cursor CR8 was already open (LETTER_ISSUED)
*W* End of segmented string. (LETTER_ISSUED)
2005-MAR-16 SFAS_WWW_DIC PAGE
1
Letter
Idx
900,121,251
--__--__--
Message: 6
Date: Wed, 16 Mar 2005 16:31:27 -0500
To: powerh-l@lists.sowder.com
From: "Connie S. Loveland" <csloveland@washtrust.com>
Subject: Question
We are new users to Powerhouse. We have a page which uses dynamic lists to
populate a master table. We are trying to create the same page with modify
capabilities where we would use a dynamic list that would first show the
value that's populated in the master table then allow the user to pick a
new value from the dynamic list. Has anyone written any language that
utilizes dynamic lists in this mannor?
Thanks in advance for any assistance
Connie Loveland
--__--__--
Message: 7
Date: Wed, 16 Mar 2005 16:42:52 -0500
From: Ted Johnson <johnsont@wfu.edu>
To: powerh-l@lists.sowder.com
Subject: Removing Spaces
I am trying to remove all the spaces from a field. I found the following
code
from some previous postings.
DEFINE T-AA CHAR*20 = "12 456 789 A B C"
DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,' ','')]")
DEFINE T-BB CHAR*20 = GETSYSTEMVAL("VAR_BB")
REPORT T-AA T-BB
go
Which I changed to:
ACCESS PRIMARY-MST
SELECT IF BOX-CREATE-WHO = 'SCTSYNCH'
DEFINE T-AA CHAR*30 = BOX-SORT-NAME
DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,' ','')]")
DEFINE T-BB CHAR*30 = GETSYSTEMVAL("VAR_BB")
REPORT T-AA T-BB
GO
EXIT
However the output field T-BB is always blank.
When I do
ACCESS PRIMARY-MST
DEFINE T-AA CHAR*30 = "Johnson, Theodore H."
DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,' ','')]")
DEFINE T-BB CHAR*30 = GETSYSTEMVAL("VAR_BB")
REPORT T-AA T-BB
GO
EXIT
I get the following output
T-AA T-BB
Johnson, Theodore Harold Johnson,TheodoreHarold
Why can't I get the output to work correctly when reading from a field?
Thanks,
Ted Johnson
--
****************************************************
Ted Johnson johnsont@wfu.edu
Information Systems
Wake Forest University 336-758-4374
Winston-Salem, NC 27109 336-758-7127 FAX
"Good judgment comes from experience and a lot of
that comes from bad judgment".
-- Richard Karn
--__--__--
Message: 8
From: "Philip Jackson" <pj@icing-it.org>
To: <powerh-l@lists.sowder.com>,
"Connie S. Loveland" <csloveland@washtrust.com>
Subject: Re: Question
Date: Wed, 16 Mar 2005 21:50:29 -0000
Can you please specify what breed of machine and version of PowerHouse you
are using? And what is your underlying database?
When you say dynamic lists, is that like a Windows drop-down list?
PowerHouse Web does that very easily in quite a nifty way, and I seem to
remember that even green-screen PowerHouse does it (sort of) for relational
databases.
There is also a way of calling a subscreen to list all the valid values so
the users can pick the one they want - useful for lists of codes from a
reference file, etc. Is this the type of thing you are looking for?
Cheers,
Philip
----- Original Message -----
From: "Connie S. Loveland" <csloveland@washtrust.com>
To: <powerh-l@lists.sowder.com>
Sent: Wednesday, March 16, 2005 9:31 PM
Subject: Question
> We are new users to Powerhouse. We have a page which uses dynamic lists
> to populate a master table. We are trying to create the same page with
> modify capabilities where we would use a dynamic list that would first
> show the value that's populated in the master table then allow the user to
> pick a new value from the dynamic list. Has anyone written any language
> that utilizes dynamic lists in this mannor?
>
> Thanks in advance for any assistance
> Connie Loveland
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to
> powerh-l-request@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.
> ---
> [This E-mail was scanned for viruses for your protection]
>
>
--__--__--
Message: 9
From: "Knox, Dave (Dallas, CSC)" <KnoxDa01@unisourcelink.com>
To: "'Ted Johnson'" <johnsont@wfu.edu>, powerh-l@lists.sowder.com
Subject: RE: Removing Spaces
Date: Wed, 16 Mar 2005 17:10:30 -0500
Under some circumstances defines an not evaluated unless required.
Reporting T-BB is probably not causing T-DD to be actioned...
Try adding a condition to the end of each define referencing another to
trigger them...
T-DD......if T-CC = "Y"
T-BB.......if T-DD = "Y"
Report T-BB...
Regards
Dave Knox
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Ted Johnson
Sent: Wednesday, March 16, 2005 3:43 PM
To: powerh-l@lists.sowder.com
Subject: Removing Spaces
I am trying to remove all the spaces from a field. I found the following
code
from some previous postings.
DEFINE T-AA CHAR*20 = "12 456 789 A B C"
DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,' ','')]")
DEFINE T-BB CHAR*20 = GETSYSTEMVAL("VAR_BB")
REPORT T-AA T-BB
go
Which I changed to:
ACCESS PRIMARY-MST
SELECT IF BOX-CREATE-WHO = 'SCTSYNCH'
DEFINE T-AA CHAR*30 = BOX-SORT-NAME
DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,' ','')]")
DEFINE T-BB CHAR*30 = GETSYSTEMVAL("VAR_BB")
REPORT T-AA T-BB
GO
EXIT
However the output field T-BB is always blank.
When I do
ACCESS PRIMARY-MST
DEFINE T-AA CHAR*30 = "Johnson, Theodore H."
DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,' ','')]")
DEFINE T-BB CHAR*30 = GETSYSTEMVAL("VAR_BB")
REPORT T-AA T-BB
GO
EXIT
I get the following output
T-AA T-BB
Johnson, Theodore Harold Johnson,TheodoreHarold
Why can't I get the output to work correctly when reading from a field?
Thanks,
Ted Johnson
--
****************************************************
Ted Johnson johnsont@wfu.edu
Information Systems
Wake Forest University 336-758-4374
Winston-Salem, NC 27109 336-758-7127 FAX
"Good judgment comes from experience and a lot of
that comes from bad judgment".
-- Richard Karn
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
--__--__--
Message: 10
Date: Wed, 16 Mar 2005 17:03:40 -0500
To: powerh-l@lists.sowder.com
From: "Connie S. Loveland" <csloveland@washtrust.com>
Subject: Re: Question
We are using SQL Server and Powerhouse Web.
I believe a Windows drop-down list and Dynamic list are the same thing. We
have a reference table which is where the data is stored. We have another
table where information is passed. We want the modify screen to allow the
user to first see what they originally picked from the reference table and
then be able to pick a different value from the reference table, which
would re-populate the other table. In other words I am a user who pick ABC
from the drop down list. I go back to that record and realize I made a
mistake I really wanted DEF, I want to pick DEF from the drop down list and
store that information for this record.
At 04:50 PM 3/16/2005, Philip Jackson wrote:
>Can you please specify what breed of machine and version of PowerHouse you
>are using? And what is your underlying database?
>
>When you say dynamic lists, is that like a Windows drop-down list?
>PowerHouse Web does that very easily in quite a nifty way, and I seem to
>remember that even green-screen PowerHouse does it (sort of) for
>relational databases.
>
>There is also a way of calling a subscreen to list all the valid values so
>the users can pick the one they want - useful for lists of codes from a
>reference file, etc. Is this the type of thing you are looking for?
>
>Cheers,
>Philip
>
>----- Original Message ----- From: "Connie S. Loveland"
><csloveland@washtrust.com>
>To: <powerh-l@lists.sowder.com>
>Sent: Wednesday, March 16, 2005 9:31 PM
>Subject: Question
>
>
>>We are new users to Powerhouse. We have a page which uses dynamic lists
>>to populate a master table. We are trying to create the same page with
>>modify capabilities where we would use a dynamic list that would first
>>show the value that's populated in the master table then allow the user
>>to pick a new value from the dynamic list. Has anyone written any
>>language that utilizes dynamic lists in this mannor?
>>
>>Thanks in advance for any assistance
>>Connie Loveland
>>
>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>>Mailing list: powerh-l@lists.sowder.com
>>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
>>Unsubscribe: "unsubscribe <password>" in message body to
>>powerh-l-request@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.
>>---
>>[This E-mail was scanned for viruses for your protection]
>>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@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.
--__--__--
Message: 11
From: "brian_matthewsbrian matthews" <brian_matthews_bmw@hotmail.com>
To: johnsont@wfu.edu, powerh-l@lists.sowder.com
Subject: RE: Removing Spaces
Date: Wed, 16 Mar 2005 22:34:35 +0000
defines are evaluated only when referenced, try ' report T-AA T-CC T-DD T-BB
'.
If you want this to execute for many records in the file PRIMARY-MST you
will probably have to modiffy three of the lines as below,
>DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA)) &
if record PRIMARY-MST exists
>DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,'
>','')]") &
if record PRIMARY-MST exists
>DEFINE T-BB CHAR*30 = GETSYSTEMVAL("VAR_BB") &
if record PRIMARY-MST exists
this is because items which do not reference record items are evaluated only
once ( I think ), the code above ties the define processing to the primary
file.
regards Bri,
>From: Ted Johnson <johnsont@wfu.edu>
>To: powerh-l@lists.sowder.com
>Subject: Removing Spaces
>Date: Wed, 16 Mar 2005 16:42:52 -0500
>
>I am trying to remove all the spaces from a field. I found the following
>code from some previous postings.
>
>DEFINE T-AA CHAR*20 = "12 456 789 A B C"
>DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
>DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,' ','')]")
>DEFINE T-BB CHAR*20 = GETSYSTEMVAL("VAR_BB")
>REPORT T-AA T-BB
>go
>
>Which I changed to:
>
>ACCESS PRIMARY-MST
>
>SELECT IF BOX-CREATE-WHO = 'SCTSYNCH'
>
>DEFINE T-AA CHAR*30 = BOX-SORT-NAME
>DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
>DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,'
>','')]")
>DEFINE T-BB CHAR*30 = GETSYSTEMVAL("VAR_BB")
>REPORT T-AA T-BB
>GO
>EXIT
>
>However the output field T-BB is always blank.
>
>When I do
>
>ACCESS PRIMARY-MST
>
>DEFINE T-AA CHAR*30 = "Johnson, Theodore H."
>DEFINE T-CC CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_AA",(T-AA))
>DEFINE T-DD CHAR*6 = "Y" IF SETSYSTEMVAL("VAR_BB","![REPL(VAR_AA,'
>','')]")
>DEFINE T-BB CHAR*30 = GETSYSTEMVAL("VAR_BB")
>REPORT T-AA T-BB
>GO
>EXIT
>
>I get the following output
>
>T-AA T-BB
>
>Johnson, Theodore Harold Johnson,TheodoreHarold
>
>Why can't I get the output to work correctly when reading from a field?
>
>Thanks,
>
>Ted Johnson
>
>
>
>--
>****************************************************
>Ted Johnson johnsont@wfu.edu
>Information Systems
>Wake Forest University 336-758-4374
>Winston-Salem, NC 27109 336-758-7127 FAX
>
>"Good judgment comes from experience and a lot of
>that comes from bad judgment".
> -- Richard Karn
>
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@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.
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!
http://toolbar.msn.co.uk/
--__--__--
Message: 12
Date: Thu, 17 Mar 2005 09:51:05 +1100
From: Murray Scholz <murray.scholz@abri.une.edu.au>
To: Robert Edis <robeconsult@sbcglobal.net>
Cc: PowerHouse List <powerh-l@lists.sowder.com>
Subject: Re: Blue is curious
G'Day Blue,
1. PH 710G1 on OpenVMS, various flavours 7.1/7.2/7.3 - RMS Files.
2. No. Been with it since late 80's !!
3. In the process of moving client base to new platform/new application
Linux / Postgres / Kylix (that's Borland's Delphi for Linux) back-end.
Windows or Linux client front-end.
... but it will take a few years to migrate everything, so we'll be with PH
for a while yet.
Cheers
Murray Scholz
Agricultural Business Research Institute
University of New England
Armidale NSW 2351 Australia
Robert Edis wrote:
> Dear listers.
>
> May I impose on you to satiate my curiousity?
>
> Would you mind telling me:
>
> 1. what environment (OS and DB) that you use PH in?
> 2. have you recently moved to this environment from
> another and if so what was that?
> 3. are you thinking of or planning to move from your
> current environment to another and if so what?
>
> This is NOT for any commercial purpose: I'm just
> curious of what platforms people are using PH on and
> the fluidity of those enviornments.
>
> I'm particularly interested in where OpenVMS is with
> PH these days. I have an emotional attachment to that
> platform though I've been working in UNIX and NT since
> 1999.
>
> Regards,
>
> Blue
--__--__--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
End of powerh-l Digest