<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR>
<STYLE>@font-face {
font-family: Wingdings;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=purple link=blue bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=500161317-05092007><FONT face=Arial
color=#0000ff size=2>I do see the value of some form of user defined function as
part of an expression so I'm not debating that. All I'm saying is that you can
do something like that in QUICK already via the DO EXTERNAL. Maybe not as
convenient, but in most cases it can get the job done.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=500161317-05092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=500161317-05092007><FONT face=Arial
color=#0000ff size=2>As for two versions of QUIZ, it's a question of what sort
of access the user has. Others have pointed out that you can already access
stored procedures so restricting access to a user-written function is a little
late. Point taken.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=500161317-05092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=500161317-05092007><FONT face=Arial
color=#0000ff size=2>Bob</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com] <B>On Behalf
Of </B>Joe Boyle<BR><B>Sent:</B> September 5, 2007 10:03 am<BR><B>To:</B>
Robert Mills<BR><B>Cc:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Re:
new feature request - user defined functions<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>i think that a define is'nt
actually asigned a value until it is referenced,</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>define mydefine = 'item returned
from do ext' ;...( defined item mydefine contains nothing )</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>if mydefine = .... ( defined item
mydefine now contains value in 'item returned from do ext' )</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=robert.mills@pinnaclearvato.co.uk
href="mailto:robert.mills@pinnaclearvato.co.uk">Robert Mills</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=Bob.Deskin@cognos.com
href="mailto:Bob.Deskin@cognos.com">Deskin, Bob</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 05, 2007
9:00 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: new feature request - user
defined functions</DIV>
<DIV><BR></DIV>
<DIV dir=ltr align=left><SPAN class=793351907-05092007><FONT face=Arial
color=#0000ff size=2>Bob,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=793351907-05092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=793351907-05092007><FONT face=Arial
color=#0000ff size=2>The problem with Quick's DO EXTERNAL is that you have
to call it within a procedure. What if you need to load a define with the
data returned from an external routine?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=793351907-05092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=793351907-05092007><FONT face=Arial
color=#0000ff size=2>Why would you need two versions of
Quiz?</FONT></SPAN></DIV>
<DIV> </DIV><FONT face="Comic Sans MS" size=2>
<P align=left>regards,<BR> <BR>Robert W.Mills<BR>Business Systems
Development Analyst<BR>Group Information Systems &
Technology<BR>Pinnacle Arvato<BR>DDI: +44 (0)20 8309 3604 </P></FONT>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Deskin, Bob
[mailto:Bob.Deskin@Cognos.COM] <BR><B>Sent:</B> 04 September 2007
14:48<BR><B>To:</B> Robert Mills<BR><B>Cc:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: new feature request - user
defined functions<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>
<DIV dir=ltr align=left><SPAN class=609144313-04092007><FONT face=Arial
color=#0000ff size=2>QUICK can access any library via DO EXTERNAL. It's a
lot easier to do that than to force a specific format on the developer. As
well, external calls are different on each platform and with DO EXTERNAL,
you can have a generic format or close if you care.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=609144313-04092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=609144313-04092007><FONT face=Arial
color=#0000ff size=2>As for QUIZ, we've always been torn because of QUIZ's
nature as a read-only product plus the fact that it is often used by end
users. We'd have to provide two versions, one with and one
without.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=609144313-04092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=609144313-04092007><FONT face=Arial
color=#0000ff size=2>Bob</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Robert Mills
[mailto:robert.mills@pinnaclearvato.co.uk] <BR><B>Sent:</B> August 31,
2007 9:58 am<BR><B>To:</B> Deskin, Bob<BR><B>Cc:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: new feature request -
user defined functions<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=466362113-31082007>Allow Quick, Quiz and Qtp to call a user defined
function that is defined within a library.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=466362113-31082007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=466362113-31082007>An example of it's use would be for check
digit calculation/validation and encryption/decryption routines.
</SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN
class=466362113-31082007>Both here and at previous sites I implemented the
code in USE files. This was fine with the check digit routines but not the
encryption routines as the encryption method and key(s) were easily seen
(w</SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN
class=466362113-31082007>e had to roll our own encryption routines as
the auditors were after something stronger).</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=466362113-31082007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=466362113-31082007>This feature would also enable the developer to
include the mathematical functions (sin, cos, tan, etc.) that have not
been implemented in PowerHouse.</SPAN></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face="Comic Sans MS"><FONT size=2>regards,<BR> <BR>Robert
W.Mills<BR>Business Systems Development Analyst<BR>Group Information
Systems & Technology<BR>Pinnacle Arvato<BR>DDI: +44 (0)20 8309
3604<SPAN class=466362113-31082007><FONT face=Arial
color=#0000ff> </FONT></SPAN></FONT></DIV>
<P align=left><FONT size=2><SPAN
class=466362113-31082007></SPAN></FONT></FONT> </P></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> 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. </DIV>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe:
&quot;subscribe&quot; in message body to
powerh-l-request@lists.sowder.com<BR>Unsubscribe: &quot;unsubscribe
&lt;password&gt;&quot; in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.</BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>