Quiz question

[Knox, Dave (Dallas CSC Citrix)]

Try this...

access fileA link (getsystemval("MYYEAR") + rest-of-key) to fileB

define D-MYYEAR char*4 = parm prompt "Enter Year:"

select fileA if setsystemval("MYYEAR",D-MYYEAR)



Note that the select is against fileA and therefore therefore evaluated (and
the system variable set) PRIOR to linking to fileB.

It should work, but I don't know what the performance impact would be like
with setting/getting variables for every record structure...also tested this
interactive, but should work okay if compiled too.

Regards
Dave

> ----------
> From: 	Arnone, Anthony[SMTP:aarnone@grey.com]
> Sent: 	Thursday, February 10, 2000 2:19 PM
> To: 	'POWERH-L@LISTS.SWAU.EDU'
> Subject: 	Quiz question
> 
> Hello,
> 
> 	I'm working on HP3000 w/ MPE/iX. I need to use the year in linking
> two datasets in my Access statement. I was wondering how I can create a
> prompt for the user to enter instead of hardcoding the year in the Access.
> 
> 
> 				Anthony
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.