LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2001, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page