Gas Prices
Jon Hawks
hawksj@yahoo.com
Tue, 18 May 2004 15:51:28 -0700 (PDT)
--0-264696753-1084920688=:64839
Content-Type: text/plain; charset=us-ascii
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 FORCED 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
--0-264696753-1084920688=:64839
Content-Type: text/html; charset=us-ascii
<DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=#0033cc size=2><SPAN style="FONT-SIZE: 10pt; COLOR: #0033cc; FONT-FAMILY: Arial">This was sent to me. Thought it might be of interest to this community as well. Who knows?</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=#0033cc size=2><SPAN style="FONT-SIZE: 10pt; COLOR: #0033cc; FONT-FAMILY: Arial"></SPAN></FONT><FONT face=Arial color=#0033cc size=2><SPAN style="FONT-SIZE: 10pt; COLOR: #0033cc; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=#0033cc size=2><SPAN style="FONT-SIZE: 10pt; COLOR: #0033cc; FONT-FAMILY: Arial">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 FORCED 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></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=#0033cc size=2><SPAN style="FONT-SIZE: 10pt; COLOR: #0033cc; FONT-FAMILY: Arial"></SPAN></FONT><BR><BR><B><I>"Thomson, Martyn EDUC:EX" <Martyn.Thomson@gems1.gov.bc.ca></I></B> wrote:</P></DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=765462321-18052004>Thanks for the suggestions.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=765462321-18052004>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></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=765462321-18052004>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. </SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN class=765462321-18052004>Then I'll have to manually assign the temporary to the table field, control it's display on prescroll, postscroll, etc.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=765462321-18052004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=765462321-18052004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=765462321-18052004></SPAN></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com]<BR><B>Sent:</B> May 18, 2004 2:27 PM<BR><B>To:</B> Thomson, Martyn EDUC:EX; POWERHOUSE NEW (E-mail)<BR><B>Subject:</B> RE: Testing for numeric input<BR><BR></FONT></DIV>
<DIV><SPAN class=328372821-18052004><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=328372821-18052004><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328372821-18052004><FONT face=Arial color=#0000ff size=2>Stop fighting the tool :-)</FONT></SPAN></DIV>
<DIV><SPAN class=328372821-18052004><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328372821-18052004><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Thomson, Martyn EDUC:EX [mailto:Martyn.Thomson@gems1.gov.bc.ca]<BR><B>Sent:</B> Tuesday, May 18, 2004 4:24 PM<BR><B>To:</B> POWERHOUSE NEW (E-mail)<BR><B>Subject:</B> Testing for numeric input<BR><BR></FONT></DIV>
<DIV><SPAN class=593515719-18052004><FONT face=Arial size=2>Hello listers,</FONT></SPAN></DIV>
<DIV><SPAN class=593515719-18052004><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=593515719-18052004><FONT face=Arial size=2>Using NCONVERT(fieldtext) causes a data expression error when the argument is not numeric.</FONT></SPAN></DIV>
<DIV><SPAN class=593515719-18052004><FONT face=Arial size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=593515719-18052004><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=593515719-18052004><FONT face=Arial size=2>There must be a more elegant method eh?</FONT></SPAN></DIV>
<P><FONT face=Arial size=2>Regards,</FONT> <BR><FONT face=Arial size=2>Martyn Thomson</FONT> <BR><FONT face=Arial size=2>Ministry of Education,<SPAN class=593515719-18052004> </SPAN>Victoria, BC</FONT> <BR><FONT face=Arial size=2> </FONT> </P>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></DIV><BR><BR>
--0-264696753-1084920688=:64839--