HP3000-L Archives

November 2005, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Suprtool question
From:
"Newton, Ernie" <[log in to unmask]>
Reply To:
Newton, Ernie
Date:
Tue, 8 Nov 2005 11:32:58 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (34 lines) 
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 *

ATOM RSS1 RSS2