Date: Tue, 16 Oct 2001 13:08:16 -0600
Reply-To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject: Re: Update Multiple Recods using Form (Sas Dispatcher)
Content-Type: text/plain; charset=us-ascii
Are you using the correct macro variable names when you do the update? SAS has probably set variables with names like KEYFIELD, KEYFIELD1, KEYFIELD2, etc. Are you using only KEYFIELD? What variables are shown as available in the debug log?
The method you need to use to get multiple instances of a field is not explained well in the documentation.
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA
>>> "Action Man" <email@example.com> 10/16/2001 11:44 AM >>>
Yes I am talking about SAS/Intrnet Dispatcher. I am able to display multiple
records forms. But WHen I update those forms, The value of first record
update all records. Is there anything I need to do in front end, beofer I
brought the data into the form?
>From: "Jack Hamilton" <JackHamilton@firsthealth.com>
>To: wollo_desse@HOTMAIL.COM, SAS-L@LISTSERV.UGA.EDU
>Subject: Re: Update Multiple Recods using Form (Sas Dispatcher)
>Date: Tue, 16 Oct 2001 11:37:22 -0600
>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.
>Development Manager, Technical Group
>METRICS Department, First Health
>West Sacramento, California USA
> >>> "Action Man" <wollo_desse@HOTMAIL.COM> 10/16/2001 10:18 AM >>>
>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.
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp