RE: [U2] Auto-updating of secondary indices.

2009-05-18 Thread Israel, John R.
Just to be 100% clear - it's not just indexes on subroutines that will get out of sync. Even indexing a simple TRANS statements will cause problems. This is because the index is updated whenever the primary file (the one with the index) is updated. If the data is in the 2nd file (the TRANS or

RE: [U2] LIST DICT.DICT

2009-05-18 Thread Brutzman, Bill
While I am glad to find out about LIST DICT.DICT, it is not clear to me what it is. Elaboration would be appreciated. --Bill -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jo Lester Sent: Friday, May 15, 2009 6:39 PM

Re: [U2] LIST DICT.DICT

2009-05-18 Thread Martin Phillips
Hi, While I am glad to find out about LIST DICT.DICT, it is not clear to me what it is. DICT.DICT is the dictionary that describes dictionaries (and hence itself too). It is used whenever you do LIST DICT filename Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone,

Re: [U2] Auto-updating of secondary indices.

2009-05-18 Thread Scott Ballinger
On Sun, May 17, 2009 at 7:30 PM, Charlie Noah cwn...@comcast.net wrote: Considering the nature of secondary indexes, and not just Universe, you should never count on an index built on a subroutine to be updated automatically. If Universe does this, it must be magic. ;-) The same goes

Re: [U2] LIST DICT.DICT

2009-05-18 Thread Charles Stevenson
One quick point is that this is one of the differences between Pick heritage Prime heritage. See Guide for Pick Users in the UV doc set. If you were a Pickie, it helps UV make sense in a hurry. UV republished that guide after a long lapse, thanks to U2UG's pressure, iirc. For Primates, the

RE: [U2] LIST DICT.DICT

2009-05-18 Thread Jo Lester
Sorry if I was too short. DICT.DICT is the default dictionary of all Dictionary files that ships with the system and defines how the Dictionaries of all files are structured. By listing it you can see what part of a record to inspect to extract the information you want. You will see that

RE: [U2] Capture Dictionary IDs

2009-05-18 Thread Ken Wallis
Check the documentation on CALCULATE() and its shorthand notation {} in the UniData manuals. Cheers, Ken -Original Message- From within UniBasic, I need to determine the name of a DICTionary field, given the dict field number. While I have the beginnings of some code, some help is