Gas Prices
Mikael.Olesen@qss-uk.com
Mikael.Olesen@qss-uk.com
Wed, 19 May 2004 10:52:59 +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_01C43D87.1190FB50
Content-Type: text/plain
Also, Gas prices here in the UK and in most of Europe are still 300% higher
than in the US, so........
-----Original Message-----
From: Butland, Nick [mailto:nick.butland@acco-uk.co.uk]
Sent: 19 May 2004 10:22
To: 'Jon Hawks'
Cc: powerh-l@lists.sowder.com
Subject: RE: Gas Prices
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.
r============================ DISCLAIMER =============================
This message is intended only for the use of the person(s)
(\"Intended Recipient\") to whom it is addressed. It may contain
information, which is privileged and confidential. Accordingly
any dissemination, distribution, copying or other use of this
message or any of its content by any person other than the Intended
Recipient may constitute a breach of civil or criminal law and is
strictly prohibited. If you are not the Intended Recipient, please
contact the sender as soon as possible.
Reed Business Information Ltd. and its subsidiary companies
Tel: +44 (0)20 8652 3500
=======================================================================
------_=_NextPart_001_01C43D87.1190FB50
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{font-family:Garamond;
color:navy;
font-weight:normal;
font-style:normal;}
span.EmailStyle20
{font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-GB link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Also, Gas prices here in the </span></=
font><font
size=3D2 color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;font-f=
amily:Arial;
color:navy'>UK</span></font><font size=3D2 color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'> and in most of </s=
pan></font><font
size=3D2 color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;font-fa=
mily:Arial;
color:navy'>Europe</span></font><font size=3D2 color=3Dnavy face=3DArial><=
span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'> are still 300% hig=
her
than in the </span></font><font size=3D2 color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>US</span></font><=
font
size=3D2 color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;font-fam=
ily:Arial;
color:navy'>, so........</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 face=3DTah=
oma><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Butland, Nick
[mailto:nick.butland@acco-uk.co.uk] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> </span></font><font si=
ze=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:10.0pt;font-fami=
ly:Tahoma'>19
May 2004</span></font><font size=3D2 face=3DTahoma><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><font
size=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:10.0pt;font-f=
amily:Tahoma'>10:22</span></font><font
size=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:10.0pt;font-fa=
mily:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Jon Hawks'<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> powerh-l@lists.sowder.co=
m<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Gas Prices</spa=
n></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> </span></fo=
nt></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>Jon,=
</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>&nbs=
p;</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>You =
have fallen
into the same hole as 99% of all spam. </span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>&nbs=
p;</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>"Int=
erest
rates are at an all-time low". No they aren't, they've just
gone up (again).</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>"Por=
n for
a buck". Why would a young deer want a video?</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>&nbs=
p;</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>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.</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>&nbs=
p;</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>Anyw=
ay, we in
the UK will support your call by not buying any gasoline, but some of us may
have to fill up with petrol.</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>&nbs=
p;</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>Can =
I suggest
any campaigning issues filter out email addresses ending ".co.uk"?</span></=
font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
size=3D3 color=3Dnavy face=3DGaramond><span style=3D'font-size:12.0pt'>&nbs=
p;</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D5 color=3Dna=
vy
face=3DGaramond><span style=3D'font-size:16.0pt;font-family:Garamond;color:=
navy;
layout-grid-mode:line'>Keep smiling,</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D5 color=3Dna=
vy
face=3DGaramond><span style=3D'font-size:16.0pt;font-family:Garamond;color:=
navy;
layout-grid-mode:line'>Nick Butland</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D4 color=3Dna=
vy
face=3DGaramond><span style=3D'font-size:14.0pt;font-family:Garamond;color:=
navy;
layout-grid-mode:line'>IT Project Leader, ACCO UK</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D4 face=3DGar=
amond><span
style=3D'font-size:14.0pt;font-family:Garamond;layout-grid-mode:line'> =
;</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D4 color=3Dna=
vy
face=3DGaramond><span style=3D'font-size:14.0pt;font-family:Garamond;color:=
navy;
layout-grid-mode:line'>Telephone 01296-732150</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D4 color=3Dna=
vy
face=3DGaramond><span style=3D'font-size:14.0pt;font-family:Garamond;color:=
navy;
layout-grid-mode:line'>Fax &=
nbsp; 01296-732151</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><span class=3DEmailStyle1=
7><font
color=3Dnavy face=3DGaramond> </font></span></p>
<p class=3DMsoNormal style=3D'margin-left:72.0pt'><font size=3D2 color=3Dbl=
ack
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma;color:blac=
k'>-----Original
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Jon Hawks
[mailto:hawksj@yahoo.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Tuesday, May 18, 2004 =
11:51
PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> POWERHOUSE NEW (E-mail)<=
br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Gas Prices</span></=
font></p>
<p class=3DMsoNormal style=3D'margin-left:72.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> </span></fo=
nt></p>
<p class=3DMsoNormal style=3D'margin-left:72.0pt'><font size=3D2 color=3D"#=
0033cc"
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:#0033C=
C'>This
was sent to me. Thought it might be of interest to this community as well. =
Who
knows?</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:72.0pt'><font size=3D3 color=3Dbl=
ack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:72.0pt'><font size=3D2 color=3D"#=
0033cc"
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:#0033C=
C'>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>
&nb=
sp;
**MAY 19TH*****<br>
<br>
HAS BEEN FORMALLY DECLARED " STICK IT TO THEM DAY" <b=
r>
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 PRICE=
S<br>
WHICH AFFECTS PRICES ON EVERYTHING THAT IS
SHIPPED. <br>
THINGS LIKE FOOD, CLOTHING, BUILDING MATERIA=
LS,<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 G=
ET
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>
&nb=
sp;
MAY 19TH <br>
A DAY THAT THE CITIZENS OF THE UNITED STATES SAY " ENOUGH IS ENO=
UGH
"<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></p>
<p class=3DMsoNormal style=3D'margin-left:72.0pt'><font size=3D3 color=3Dbl=
ack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'><br>
<br>
<b><i><span style=3D'font-weight:bold;font-style:italic'>"Thomson, Mar=
tyn
EDUC:EX" <Martyn.Thomson@gems1.gov.bc.ca></span></i></b> wrote:<=
/span></font></p>
<div style=3D'border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0=
cm 4.0pt;
margin-left:75.75pt;margin-right:36.0pt'>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblue
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:blue'>=
Thanks
for the suggestions.</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblue
face=3DArial><span style=3D'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></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblue
face=3DArial><span style=3D'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, positio=
ned
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 temporar=
y to
the table field, control it's display on prescroll, postscroll, etc.</=
span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D3 color=
=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D3 color=
=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D3 color=
=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
</div>
<div style=3D'border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0=
cm 4.0pt;
margin-left:111.75pt;margin-right:36.0pt'>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt;border:none;padding:0cm'=
><font
size=3D2 color=3Dblack face=3DTahoma><span style=3D'font-size:10.0pt;font-f=
amily:Tahoma;
color:black'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Pickering, John (NORBO=
RD)
[mailto:PICKERIJ@norbord.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> May 18, 2004 2:27 PM<b=
r>
<b><span style=3D'font-weight:bold'>To:</span></b> Thomson, Martyn EDUC:EX;
POWERHOUSE NEW (E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Testing for num=
eric
input</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblue
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:blue'>=
How
about letting PowerHouse do the job for you. Even though the field is defin=
ed
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 "+&q=
uot;
and with appropriate picture will deal with the decimal point correctly.</s=
pan></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D3 color=
=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblue
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:blue'>=
Stop
fighting the tool :-)</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D3 color=
=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D3 color=
=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt;border:none;padding:0cm'=
><font
size=3D2 color=3Dblack face=3DTahoma><span style=3D'font-size:10.0pt;font-f=
amily:Tahoma;
color:black'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Thomson, Martyn EDUC:EX
[mailto:Martyn.Thomson@gems1.gov.bc.ca]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Tuesday, May 18, 2004 =
4:24
PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> POWERHOUSE NEW (E-mail)<=
br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Testing for numeric=
input</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'=
>Hello
listers,</span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'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></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'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></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'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 inp=
ut,
and the range has be taken into account, the number of combinations soon ge=
ts
unmanageable. </span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'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></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'=
>There
must be a more elegant method eh?</span></font></p>
<p style=3D'border:none;padding:0cm'><font size=3D2 color=3Dblack face=3DAr=
ial><span
style=3D'font-size:10.0pt;font-family:Arial;color:black'>Regards,</span></f=
ont><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span style=3D'font=
-size:10.0pt;
font-family:Arial;color:black'>Martyn Thomson</span></font><font color=3Dbl=
ack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span style=3D'font=
-size:10.0pt;
font-family:Arial;color:black'>Ministry of Education, Victoria, BC</span></=
font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span style=3D'font=
-size:10.0pt;
font-family:Arial;color:black'> </span></font><font color=3Dblack><span
style=3D'color:black'> </span></font></p>
<p class=3DMsoNormal style=3D'border:none;padding:0cm'><font size=3D3 color=
=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'> =
;</span></font></p>
</div>
<p class=3DMsoNormal style=3D'margin-right:0cm;margin-bottom:12.0pt;margin-=
left:
72.0pt'><font size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12=
.0pt'> </span></font></p>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'margin-left:36.0pt;text-alig=
n:center'><font
size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter>
</span></font></div>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>DISCLAIMER<br>
*****************<br>
This email and any attachments thereto, may contain information which is
confidential and/or protected by intellectual property rights and are inten=
ded
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 reproducti=
on,
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.</span></font></p>
</div>
</div>
<FONT SIZE=3D3><BR>
<BR>
r=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D DISCLAIMER =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>
This message is intended only for the use of the person(s) <BR>
(\"Intended Recipient\") to whom it is addressed. It may contain <BR>
information, which is privileged and confidential. Accordingly <BR>
any dissemination, distribution, copying or other use of this <BR>
message or any of its content by any person other than the Intended <BR>
Recipient may constitute a breach of civil or criminal law and is <BR>
strictly prohibited. If you are not the Intended Recipient, please <BR>
contact the sender as soon as possible.<BR>
<BR>
Reed Business Information Ltd. and its subsidiary companies<BR>
Tel: +44 (0)20 8652 3500<BR>
<BR>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D <BR>
<BR>
</FONT>
</body>
</html>
------_=_NextPart_001_01C43D87.1190FB50--