[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

230.0. "Can DATA_FILE GET use alternate key?" by SNOC01::CAMERONJAMES (and God sent him FORTH (Gen 3:23)) Fri Mar 13 1992 04:18

    The ALL-IN-1 function DATA_FILE GET uses the primary key for locating
    record in an indexed file.
    
    Is there a way to use an alternate key to look up records using
    DATA_FILE get style syntax?
    
    I have read the DATA_FILE function documentation in the Reference
    Manual, and found no reference to such a possibility.
    
    Regards...
    James Cameron
    (Sydney, Australia)
T.RTitleUserPersonal
Name		DateLines
230.1Not sure, but...SHALOT::NICODEMWho told you I'm paranoid???Fri Mar 13 1992 13:4715
	I could be wrong (it certainly wouldn't be the first time!), but I
believe that you have to have specified the key-of-access on the DATA_FILE OPEN.
The syntax is something like:

	DATA_FILE OPEN/READ MYDATA "PERSONNEL:SSN"

	Then, if SSN is an alternate key to the PERSONNEL data base, you would
do something like:

	DATA_FILE GET MYDATA "123-45-6789"

	I'm doing this from memory, so some of it could be a little off; but
that's the general idea.

	F