Yes, Ernie, you can update from a table.  The option you need is the
DATA option on the TBALS statement.  There is a very good example in the
SUPRTOOL help (se the EXTRACT command help).


HTH,


Ray Shahan

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Newton, Ernie
Sent: Tuesday, November 08, 2005 1:33 PM
To: [log in to unmask]
Subject: [HP3000-L] Suprtool question

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 *
========================================================================
This e-mail message has been scanned for Viruses and Content and cleared

by School Specialty's email filtering solution.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *