Error checking & correcting

Article View: comp.databases.ms-sqlserver

Article #96

Back to comp.databases.ms-sqlserver Previous Next

#96

From: ^-^
Date: Thu, 10 Apr 2003 04:38

35 lines
3340 bytes

Hi there....

This is a bit of background of my database:

I have a table called dc_machinehours_MAIN which captures machine working
hours...(SQL server)  this is how the layout of the table looks:

Columns:

Machine_Name, Date_Stamp, Hr23, Operator_Name_23, Hr00, Operator_Name_00,
Hr01, Operator_Name_01, Hr02, Operator_Name_02,
                      Operator_Name_03, Hr03, Hr04, Operator_Name_04, Hr05,
Operator_Name_05, Hr06, Hr07, Operator_Name_07, Hr08, Operator_Name_08,
Hr09,
                      Operator_Name_09, Hr10, Operator_Name_10, Hr11,
Operator_Name_11, Hr12, Operator_Name_12, Hr13, Hr14, Operator_Name_14,
Hr15,
                      Operator_Name_13, Hr16, Operator_Name_15,
Operator_Name_16, Hr17, Operator_Name_17, Hr18, Operator_Name_18, Hr19,
Operator_Name_19,
                      Hr20, Operator_Name_20, Hr21, Operator_Name_21, Hr22

an append query pastes all the machine names into the form so that your form
looks like an excel sheet kind of way when the capturer inserts the data...
I want to create stored procedure or something that checks if the machine is
standing still...  i.o.w if a machine's hours is the same for any 3 hours in
the day thereafter (eg, Hr08, Hr09, Hr10) then the form has to popup a
dialog box that warns me that it has been the same, and if this is ok...  if
it isn't ok, then it just has to popup another access form for me.... called
dc_machinehours_form_error

can anyone help me on this matter?
thanks alot in advance...

^-^

Technical Details

Message-ID: <b72sem$enp$1@ctb-nnrp2.saix.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!newsfeed.mathworks.com!btnet-peer0!btnet!ctb-nntp1.saix.net!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1041a7,25307826da33044a,start
X-Google-Attributes: gid1041a7,public
X-Google-Thread: ff490,25307826da33044a,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 100e19,25307826da33044a,start
X-Google-Attributes: gid100e19,public
X-Google-Thread: 10354c,25307826da33044a,start
X-Google-Attributes: gid10354c,public
X-Google-Thread: 10e484,25307826da33044a,start
X-Google-Attributes: gid10e484,public
X-Google-Thread: 11001f,25307826da33044a,start
X-Google-Attributes: gid11001f,public
X-Google-Thread: 104de1,25307826da33044a,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 101bdd,25307826da33044a,start
X-Google-Attributes: gid101bdd,public
X-Google-ArrivalTime: 2003-04-09 21:37:44 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!newsfeed.mathworks.com!btnet-peer0!btnet!ctb-nntp1.saix.net!not-for-mail
From: "^-^" <mortalnightmare@hotmail.com>
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.access.adp.sqlserver,microsoft.public.access.forms,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign,microsoft.public.it.sql,microsoft.public.jp.officexp.access
Subject: Error checking & correcting
Date: Thu, 10 Apr 2003 06:38:09 +0200
Organization: The South African Internet Exchange
Lines: 37
Message-ID: <b72sem$enp$1@ctb-nnrp2.saix.net>
NNTP-Posting-Host: 196.25.159.177
X-Trace: ctb-nnrp2.saix.net 1049949462 15097 196.25.159.177 (10 Apr 2003 04:37:42 GMT)
X-Complaints-To: abuse@saix.net
NNTP-Posting-Date: 10 Apr 2003 04:37:42 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000