RE: [sqr-users] Load-Lookup command

["Devinder Singh Kunwar (STP)" <kunward3@anz.com>]

Edward,
         
LOAD-LOOKUP
    NAME = 1111
    TABLE = 2222
    KEY = 333
    RETURN_VALUE = 4444

You can combine several columns into an expression if you need several fields 
returned for each lookup . This is done by concatenating columns. For Eg in 
Oracle
 RETURN_VALUE= 'name' || 'address' || 'designation'   could be used.

But you need to check your database manual for the correct syntax to 
concatenate.

Haven't tried it out but guess same could be tried out for the key field also
like KEY = 'key_1' || 'key_2'

 
Cheers,
Devinder 

-----Original Message-----
From: Lock, Edward J [mailto:EJLock@Central.UH.EDU]
Sent: Thursday, April 17, 2003 5:23 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] Load-Lookup command


Is it possible to load multiple keys or fields with a "Load-Lookup" command?
I've only seen references for a single key in this type of array.  

Thanks,

Edward Lock
ejlock@central.uh.edu

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users