Date: Tue, 16 Oct 2001 13:58:45 -0400
Reply-To: "Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM>
Subject: Re: Update Multiple Records using Form (Sas Dispatcher)
Content-Type: text/plain; charset="iso-8859-1"
Again, if this SAS/Intrnet, another consideration is the service timeout.
If the time required for the update process exceeds the service timeout,
you're better off having your SAS/Intrnet program ( i.e. the one initiated
by the HTML form ) fire off a batch SAS process to do the update. If
notification of update completion is important to the user, the HTML page
back to the browser can display update status ( as set by the batch update
process or dataset interrogation ). You can also use the META REFRESH tag
on the returned page to automatically redisplay update status every XX
seconds.
-----Original Message-----
From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM]
Sent: October 16, 2001 1:37 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Update Multiple Recods using Form (Sas
Dispatcher)
If by "SAS Dispatcher" you mean the Application Dispatcher
in SAS/Intrnet, there's no restriction on the number of records that may be
updated, or if there is it's a large limit. I have a form that updates as
many as 6 records in 2 different tables.
--
JackHamilton@FirstHealth.com
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA
>>> "Action Man" <wollo_desse@HOTMAIL.COM> 10/16/2001 10:18
AM >>>
Hi SASL;
I have multiple records with one Key Variable as follow:
ID is the key variable.
ID Camp_name L_code
0004 Duba_maufacturing 32
0005 Duba_maufacturing 25
0006 Duba_maufacturing 32
I need to use SAS Dispatcher FORM to update all records in
one form. But a
form can update only one record at a time. Is there anyway
to update all
these records displayed on this form at the same time and
update it at once
with one "Submit" Button.
Kindly;
Wollo
_________________________________________________________________
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp