Gas Prices
Butland, Nick
nick.butland@acco-uk.co.uk
Wed, 19 May 2004 10:21:56 +0100
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C43D82.BAF6DD40
Content-Type: text/plain
X-NAIMIME-Disclaimer: 1
Content-Transfer-Encoding: 7bit
X-NAIMIME-Modified: 1
Jon,
You have fallen into the same hole as 99% of all spam.
"Interest rates are at an all-time low". No they aren't, they've just gone
up (again).
"Porn for a buck". Why would a young deer want a video?
Why do these things not make sense? Because there are several billion
non-Americans out here & things just aren't the same for us, whether it's
world view or linguistic.
Anyway, we in the UK will support your call by not buying any gasoline, but
some of us may have to fill up with petrol.
Can I suggest any campaigning issues filter out email addresses ending
".co.uk"?
Keep smiling,
Nick Butland
IT Project Leader, ACCO UK
Telephone 01296-732150
Fax 01296-732151
-----Original Message-----
From: Jon Hawks [mailto:hawksj@yahoo.com]
Sent: Tuesday, May 18, 2004 11:51 PM
To: POWERHOUSE NEW (E-mail)
Subject: Gas Prices
This was sent to me. Thought it might be of interest to this community as
well. Who knows?
IT HAS BEEN CALCULATED THAT IF EVERYONE IN THE UNITED STATES DID NOT
PURCHASE A DROP OF GASOLINE FOR ONE DAY AND ALL AT THE SAME TIME, THE
OIL COMPANIES WOULD CHOKE ON THEIR STOCKPILES.
THEREFORE
**MAY 19TH*****
HAS BEEN FORMALLY DECLARED " STICK IT TO THEM DAY"
AND THE PEOPLE OF THIS NATION SHOULD NOT BUY A SINGLE DROP OF
GASOLINE THAT DAY.
THE ONLY WAY THIS CAN BE DONE IS IF YOU FORWARD THIS E-MAIL TO AS
MANY PEOPLE AS YOU CAN AND AS QUICKLY AS YOU CAN TO GET THE WORD OUT.
WHAT HAPPENED TO THE REDUCTION AND CONTROL IN PRICES THAT THE ARAB
NATIONS PROMISED TWO WEEKS AGO?
>>REMEMBER: NOT ONLY IS THE PRICE OF GASOLINE GOING UP BUT AT THE
>SAME TIME AIRLINES ARE FOR! CED TO RAISE THEIR PRICES,
TRUCKING COMPANIES ARE FORCED TO RAISE THEIR PRICES
WHICH AFFECTS PRICES ON EVERYTHING THAT IS SHIPPED.
THINGS LIKE FOOD, CLOTHING, BUILDING MATERIALS,
MEDICAL SUPPLIES ETC.
WHO PAYS IN THE END?
WE DO!
> >WE CAN MAKE A DIFFERENCE. ON May 19th. IF THEY DON'T GET THE
MESSAGE AFTER ONE DAY,WE WILL DO IT AGAIN AND AGAIN.
>
SO DO YOUR PART AND SPREAD THE WORD. FORWARD THIS EMAIL TO EVERYONE
YOU >KNOW. MARK YOUR CALENDARS AND MAKE
MAY 19TH
A DAY THAT THE CITIZENS OF THE UNITED STATES SAY " ENOUGH IS ENOUGH "
>
Note: this is only for one day! ! A week from tomorrow, Wednesday the
>19th.....please try to remember and buy your gas the day before or
wait >until the day after. Call your family and friends...get the
word out. Lets show them where the power is in this country!!!
>
"Thomson, Martyn EDUC:EX" <Martyn.Thomson@gems1.gov.bc.ca> wrote:
Thanks for the suggestions.
I should have mentioned that depending on the value entered in a previous
field, the user can enter a letter in the range A to H, or a numeric value!
That's why I wanted to be able to test if the value entered was numeric
after the event.
I see that I'm overloading this field and that's not really going to fly, so
now I'm experimenting with a temporary that occurs with the table,
positioned just before the numeric field and will control which field is
ACCEPTed from a silent field before the two. Then I'll have to manually
assign the temporary to the table field, control it's display on prescroll,
postscroll, etc.
-----Original Message-----
From: Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com]
Sent: May 18, 2004 2:27 PM
To: Thomson, Martyn EDUC:EX; POWERHOUSE NEW (E-mail)
Subject: RE: Testing for numeric input
How about letting PowerHouse do the job for you. Even though the field is
defined as character in the dictionary or screen you can put NUMERIC on the
field statement along with any of the numeric field statement parameters
such as a suitable picture clause and a values clause. PowerHouse will quite
happily refuse non-numeric entries, will accept the "-" and the "+" and with
appropriate picture will deal with the decimal point correctly.
Stop fighting the tool :-)
-----Original Message-----
From: Thomson, Martyn EDUC:EX [mailto:Martyn.Thomson@gems1.gov.bc.ca]
Sent: Tuesday, May 18, 2004 4:24 PM
To: POWERHOUSE NEW (E-mail)
Subject: Testing for numeric input
Hello listers,
Does anyone know of a simple way to test if the input to a text field is
numeric within a range -999.99 to +999.99 with the "+" being optional.
Using NCONVERT(fieldtext) causes a data expression error when the argument
is not numeric.
I looked at matching against every possible pattern the user could enter,
but since the "-","+" and "." are optional on input, and the range has be
taken into account, the number of combinations soon gets unmanageable.
I could loop through each character matching against characters 0 to 9 , . -
+ but then coding to ensure that the plus, negative and period characters
are in appropriate positions and not repeated, also soon becomes lengthy.
There must be a more elegant method eh?
Regards,
Martyn Thomson
Ministry of Education, Victoria, BC
DISCLAIMER
*****************
This email and any attachments thereto, may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including but not limited to total or, partial reproduction, communication or, distribution in any form) or, the taking of any action in reliance on the contents by persons other than the designated recipient(s) is strictly prohibited.
If you have received this email in error, please notify the sender either by telephone or, by email and delete the material from any computer.
Thank you for your co-operation.
------_=_NextPart_001_01C43D82.BAF6DD40
Content-Type: text/html
Content-Transfer-Encoding: 7bit
X-NAIMIME-Modified: 1
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C43D8B.33AD7250">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:ForgetLastTabAlignment/>
<w:DoNotUseHTMLParagraphAutoSpacing/>
</w:Compatibility>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:647 0 0 0 159 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:553679495 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p
{margin-right:0cm;
mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle16
{mso-style-type:personal-reply;
mso-ansi-font-size:12.0pt;
mso-ascii-font-family:Garamond;
mso-hansi-font-family:Garamond;
mso-bidi-font-family:Arial;
color:navy;
font-weight:normal;
font-style:normal;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB style='tab-interval:36.0pt'>
<div class=Section1>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'>Jon,<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'>You have
fallen into the same hole as 99% of all spam. <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'>“Interest
rates are at an all-time low”. No they aren’t, they’ve just gone up (again).<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'>“Porn for a
buck”. Why would a young deer want a video?<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'>Why do these
things not make sense? Because there are several billion non-Americans out here
& things just aren’t the same for us, whether it’s world view or
linguistic.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'>Anyway, we in
the UK will support your call by not buying any gasoline, but some of us may
have to fill up with petrol.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'>Can I suggest
any campaigning issues filter out email addresses ending “.co.uk”?<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=3 color=navy
face=Garamond><span style='font-size:12.0pt;font-family:Garamond'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><!--[if supportFields]><span class=EmailStyle16><font
color=navy face=Garamond><span style='font-family:Garamond'><span
style='mso-element:field-begin'></span><span style="mso-spacerun:
yes"> </span>AUTOTEXTLIST \s "E-mail Signature" <span
style='mso-element:field-separator'></span></span></font></span><![endif]--><font
color=navy face=Garamond><span style='font-family:Garamond;color:navy;
mso-color-alt:windowtext;layout-grid-mode:line'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=5 color=navy face=Garamond><span
style='font-size:16.0pt;mso-bidi-font-size:12.0pt;font-family:Garamond;
color:navy;layout-grid-mode:line'>Keep smiling,</span></font><font size=5
color=navy face=Garamond><span style='font-size:16.0pt;mso-bidi-font-size:12.0pt;
font-family:Garamond;color:navy;mso-color-alt:windowtext;layout-grid-mode:line'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=5 color=navy face=Garamond><span
style='font-size:16.0pt;mso-bidi-font-size:12.0pt;font-family:Garamond;
color:navy;layout-grid-mode:line'>Nick Butland</span></font><font size=4
color=navy face=Garamond><span style='font-size:14.0pt;mso-bidi-font-size:12.0pt;
font-family:Garamond;color:navy;mso-color-alt:windowtext;layout-grid-mode:line'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 color=navy face=Garamond><span
style='font-size:14.0pt;mso-bidi-font-size:12.0pt;font-family:Garamond;
color:navy;layout-grid-mode:line'>IT Project Leader, ACCO UK</span></font><font
size=4 color=navy face=Garamond><span style='font-size:14.0pt;mso-bidi-font-size:
12.0pt;font-family:Garamond;color:navy;mso-color-alt:windowtext;layout-grid-mode:
line'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 color=navy face=Garamond><span
style='font-size:14.0pt;mso-bidi-font-size:12.0pt;font-family:Garamond;
color:navy;layout-grid-mode:line'><![if !supportEmptyParas]> <![endif]></span></font><font
size=4 color=navy face=Garamond><span style='font-size:14.0pt;mso-bidi-font-size:
12.0pt;font-family:Garamond;color:navy;mso-color-alt:windowtext;layout-grid-mode:
line'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 color=navy face=Garamond><span
style='font-size:14.0pt;mso-bidi-font-size:12.0pt;font-family:Garamond;
color:navy;layout-grid-mode:line'>Telephone 01296-732150</span></font><font
size=4 color=navy face=Garamond><span style='font-size:14.0pt;mso-bidi-font-size:
12.0pt;font-family:Garamond;color:navy;mso-color-alt:windowtext;layout-grid-mode:
line'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 color=navy face=Garamond><span
style='font-size:14.0pt;mso-bidi-font-size:12.0pt;font-family:Garamond;
color:navy;layout-grid-mode:line'>Fax<span style='mso-tab-count:2'> </span>01296-732151</span></font><font
size=4 color=navy face=Garamond><span style='font-size:14.0pt;mso-bidi-font-size:
12.0pt;font-family:Garamond;color:navy;mso-color-alt:windowtext;layout-grid-mode:
line'><o:p></o:p></span></font></p>
<p class=MsoNormal><!--[if supportFields]><span class=EmailStyle16><font
color=navy face=Garamond><span style='font-family:Garamond'><span
style='mso-element:field-end'></span></span></font></span><![endif]--><span
class=EmailStyle16><font color=navy face=Garamond><span style='font-family:
Garamond'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Jon Hawks
[mailto:hawksj@yahoo.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, May 18, 2004 11:51
PM<br>
<b><span style='font-weight:bold'>To:</span></b> POWERHOUSE NEW (E-mail)<br>
<b><span style='font-weight:bold'>Subject:</span></b> Gas Prices</span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><font size=2 color="#0033cc" face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:#0033CC'>This was sent to me.
Thought it might be of interest to this community as well. Who knows?</span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><font size=2 color="#0033cc" face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:#0033CC'>IT HAS BEEN CALCULATED
THAT IF EVERYONE IN THE UNITED STATES DID NOT<br>
PURCHASE A DROP OF GASOLINE FOR ONE DAY AND ALL AT THE SAME TIME, THE<br>
OIL COMPANIES WOULD CHOKE ON THEIR STOCKPILES.<br>
THEREFORE <br>
**MAY 19TH*****<br>
<br>
HAS BEEN FORMALLY DECLARED " STICK IT TO THEM DAY" <br>
AND THE PEOPLE OF THIS NATION SHOULD NOT BUY A SINGLE DROP OF <br>
GASOLINE THAT DAY.<br>
<br>
THE ONLY WAY THIS CAN BE DONE IS IF YOU FORWARD THIS E-MAIL TO AS<br>
MANY PEOPLE AS YOU CAN AND AS QUICKLY AS YOU CAN TO GET THE WORD OUT.<br>
<br>
WHAT HAPPENED TO THE REDUCTION AND CONTROL IN PRICES THAT THE ARAB<br>
NATIONS PROMISED TWO WEEKS AGO?<br>
<br>
>>REMEMBER: NOT ONLY IS THE PRICE OF GASOLINE GOING UP BUT AT THE<br>
>SAME TIME AIRLINES ARE FOR! CED TO RAISE THEIR PRICES, <br>
TRUCKING COMPANIES ARE FORCED TO RAISE THEIR PRICES<br>
WHICH AFFECTS PRICES ON EVERYTHING THAT IS
SHIPPED. <br>
THINGS LIKE FOOD, CLOTHING, BUILDING MATERIALS,<br>
MEDICAL SUPPLIES ETC. <br>
WHO PAYS IN THE END? <br>
WE DO!<br>
<br>
> >WE CAN MAKE A DIFFERENCE. ON May 19th. IF THEY DON'T GET
THE<br>
MESSAGE AFTER ONE DAY,WE WILL DO IT AGAIN AND AGAIN.<br>
><br>
SO DO YOUR PART AND SPREAD THE WORD. FORWARD THIS EMAIL TO EVERYONE<br>
YOU >KNOW. MARK YOUR CALENDARS AND MAKE <br>
MAY 19TH <br>
A DAY THAT THE CITIZENS OF THE UNITED STATES SAY " ENOUGH IS ENOUGH
"<br>
><br>
Note: this is only for one day! ! A week from tomorrow, Wednesday the<br>
>19th.....please try to remember and buy your gas the day before or<br>
wait >until the day after. Call your family and friends...get the<br>
word out. Lets show them where the power is in this country!!!<br>
></span></font><font color=black><span style='color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><br>
<br>
<b><i><span style='font-weight:bold;font-style:italic'>"Thomson, Martyn
EDUC:EX" <Martyn.Thomson@gems1.gov.bc.ca></span></i></b> wrote:</span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<div style='border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:39.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>Thanks for the suggestions.</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:39.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>I should have mentioned that depending on the value entered in a
previous field, the user can enter a letter in the range A to H, or a numeric
value! That's why I wanted to be able to test if the value entered was numeric
after the event. </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:39.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>I see that I'm overloading this field and that's not really going
to fly, so now I'm experimenting with a temporary that occurs with
the table, positioned just before the numeric field and will control which
field is ACCEPTed from a silent field before the two. Then I'll have to
manually assign the temporary to the table field, control it's display on
prescroll, postscroll, etc.</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:39.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:39.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:39.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
</div>
<div style='border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
margin-bottom:12.0pt;margin-left:75.75pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;
padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Pickering, John (NORBORD)
[mailto:PICKERIJ@norbord.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> May 18, 2004 2:27 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Thomson, Martyn EDUC:EX;
POWERHOUSE NEW (E-mail)<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: Testing for numeric
input</span></font><font color=black><span style='color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>How about letting PowerHouse do the job for you. Even though the
field is defined as character in the dictionary or screen you can put NUMERIC
on the field statement along with any of the numeric field statement parameters
such as a suitable picture clause and a values clause. PowerHouse will quite
happily refuse non-numeric entries, will accept the "-" and the
"+" and with appropriate picture will deal with the decimal point
correctly.</span></font><font color=black><span style='color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>Stop fighting the tool :-)</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
margin-bottom:12.0pt;margin-left:75.75pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;
padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Thomson, Martyn EDUC:EX
[mailto:Martyn.Thomson@gems1.gov.bc.ca]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, May 18, 2004 4:24
PM<br>
<b><span style='font-weight:bold'>To:</span></b> POWERHOUSE NEW (E-mail)<br>
<b><span style='font-weight:bold'>Subject:</span></b> Testing for numeric input</span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>Hello listers,</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>Does anyone know of a simple way to test if the input to a
text field is numeric within a range -999.99 to +999.99 with the
"+" being optional.</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>Using NCONVERT(fieldtext) causes a data expression error when the
argument is not numeric.</span></font><font color=black><span style='color:
black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>I looked at matching against every possible pattern the user could
enter, but since the "-","+" and "." are optional
on input, and the range has be taken into account, the number of combinations
soon gets unmanageable. </span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>I could loop through each character matching against characters 0
to 9 , . - + but then coding to ensure that the plus, negative and
period characters are in appropriate positions and not repeated, also soon
becomes lengthy.</span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>There must be a more elegant method eh?</span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-right:36.0pt;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>Regards,</span></font><font color=black><span style='color:black'>
<br>
</span></font><font size=2 color=black face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:black'>Martyn Thomson</span></font><font color=black><span
style='color:black'> <br>
</span></font><font size=2 color=black face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:black'>Ministry of Education, Victoria, BC</span></font><font
color=black><span style='color:black'> <br>
</span></font><font size=2 color=black face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:black'> </span></font><font color=black><span
style='color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-right:36.0pt;mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;margin-left:75.75pt;border:none;mso-border-left-alt:
solid #1010FF 1.5pt;padding:0cm;mso-padding-alt:0cm 0cm 0cm 4.0pt'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
</div>
<DIV><P><HR>
DISCLAIMER<BR>*****************<BR>This email and any attachments thereto, may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including but not limited to total or, partial reproduction, communication or, distribution in any form) or, the taking of any action in reliance on the contents by persons other than the designated recipient(s) is strictly prohibited.<BR>If you have received this email in error, please notify the sender either by telephone or, by email and delete the material from any computer.<BR>Thank you for your co-operation.<BR>
</P></DIV>
</body>
</html>
------_=_NextPart_001_01C43D82.BAF6DD40--