Subject: | |
From: | |
Reply To: | |
Date: | Tue, 8 Nov 2005 15:35:01 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
At 02:32 PM 11/8/2005, Newton, Ernie wrote:
Ernie,
Yes you can:
http://www.robelle.com/tips/upd-from-table.html
Neil
>Greetings,
>
>Can you update an item in a dataset with a value in a table?
>
>I have a table called Widgets, that looks like this...
>
>WIDGET-NUMBER <KEY FIELD>
>WIDGET-COLOR
>
>I have a dataset called WIDGET-TYPES, that looks like this...
>
>WIDGET-NUMBER <KEY FIELD>
>WIDGET-TYPES
>
>I want to do this...
>
>GET WIDGET-TYPES
>IF $LOOKUP(WIDGETS,WIDGET-NUMBER)
>UPDATE
>EXT WIDGET-TYPES=WIDGET-COLOR
>
>I then get this error...
>
>Error: Item "WIDGET-COLOR" not in the dataset WIDGET-TYPES
>
>Is there a way to do what I'm trying to do?
>
>Thanks,
>
>Ernie
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.1.362 / Virus Database: 267.12.8/162 - Release Date: 11/5/2005
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|