Hello,

Your help is *greatly* appreciated.

How do I create a Q pointer to a file in another account?

Thank you,

*(why is this information so hard to locate out there?)*

UP MD name
001 Q
002 account.name
003 filename


If you are using D3 and have the ability to load an account, you can
download from Raining Data and account that provides most of what you need
as an on-line help catalog. Otherwise, it might be wise to order a set of
D3 reference manuals to read and look up information.

Also you can look in some recent postings here in CDP land within the last
month. Someone has reformatted the RD help database and put it on the web.
The link has been posted in a message on CDP.

Regards,

Dale

"GEEK^&" <darrellulm (AT) yahoo (DOT) com> wrote

In UniVerse, you just issue the SET-FILE command from TCL. You will then be
prompted for the "Q name", which is the name you want to call your Q-Pointer
(not the actual filename), the "Account", which is the name of the account
where the actual file resides, and the "File", which is the actual filename
of the file you are pointing to.

Alternatively, if you are doing this from a program, the VOC entry would be
stored under the name that you want to call your Q Pointer, with attribute
<1> as the letter "Q", attribute <2> as the account name where the actual
file resides, and attribute <3> as the actual filename.

Once this is done (with either method), your "Q Name" will act just like a
local file; you can LIST, SORT, SELECT, etc from TCL, and you can OPEN,
READ, WRITE, etc in a Basic program.

Hope this helps

Dave

"GEEK^&" <darrellulm (AT) yahoo (DOT) com> wrote

Dale - looks like we both posted a reply at exactly the same time.....
Don't know about you, but I always like to help with the easy ones.....


"Dale Benedict" <dale_knowspam_benedict (AT) flightcraft (DOT) ca> wrote

"GEEK^&" <darrellulm (AT) yahoo (DOT) com> wrote

Try http://www.d3ref.com/

If you're on D3, you can path to other accounts/files "on the fly" by this
method:

:list otheracct,otherfile, blah blah blah

....same deal with open in BASIC:

open 'otheracct,otherfile,' to f.filehndl then/else...

Pay attention to the trailing comma...

Ed


"GEEK^&" <darrellulm (AT) yahoo (DOT) com> wrote

ADDITIONAL INFORMATION ON Q-POINTERS
==================================================
ID: If the real file is in another account, this is generally the same
ID as the real file. If the real file is in the SAME account this must
be some other (synonym) ID for the file.

Attr 001: Q
Attr 002: If the real file is in another account, this is the account
name. If the real file is in the same account, this must
be left null.
Attr 003: The name of the real file.

Optional:
Attr 009: L or R justfification. Default is L. If the keys to the
real file are numeric, this should be R to sort the items correctly.
Attr 010: Default is 10. May be coded for a different "key length"
of the keys in the real file.

Optional for D3:
Attr 015: Can contain a "macro" of field names to display if just
LIST filename <cr>. See example below.
Attr 017: Can contain a description of the q-pointer -- anything you
want to say. See MD DESCRIPTION.

Example:
Suppose the real filename is CUSTOMERS and the Q-Pointer name is CUST.
Then ....
001 Q
002 accountname or null (see above)
003 CUSTOMERS
....
009 L
010 17
....
015 ID-SUPP KEY NAME CITY STATE PHONE
....
017 This is a q-pointer to CUSTOMERS with macro in 015.

Dave Weaver, Weaver Consulting