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:
From:
Neil Armstrong <[log in to unmask]>
Reply To:
Neil Armstrong <[log in to unmask]>
Date:
Tue, 8 Nov 2005 15:35:01 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (54 lines)
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 *

ATOM RSS1 RSS2