Stuart,
it just so happens that Design Bais will convert D types to A types when
you modify anything that is not confined to their extended dictionary.
Maybe System Builder does the same thing ?
Hence you can end up loosing certain dict info such as S/M, SQL settings and
Value marks in the headings.
Even though i came from a pick background i prefer D & Is so i am not happy
about this and would prefer the original dictionary type be maintained.
Hopefully this will be addressed but in the meantime if its an issue i can
create a separate dictionary but it means you have to be careful in accounts
that are not primarily DB.
jak
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <u2-users@listserver.u2ug.org>
Sent: Wednesday, May 17, 2006 5:38 PM
Subject: RE: [U2] LIST DICT FILE Depth and Assoc
John,
Yep, I think you're probably right about A-types being inherently MV.
According to the documentation I mentioned before (which you read
of-course ;) the S/M in an `A' type dictionary is only relevant to SQL
statements and not Retrieve. So unless your front-end can interrogate
the DICT and do something with the value in attr 5 to build specific
WHEN expressions, I would go with the previous suggestion and convert
them to D and I types, they're heaps (a quantum) more functional.
FYI - "LIST DICT" uses an I-type to interrogate the dictionary field;
if you're brave (!!)) you can change this in DICT.DICT to report
anything you like.
S
______________________________________________________________________
From: "John Kent"
if you make either on of these S,
LIST DICT still displays the depth and assoc as M not S
On what does it base this decision.
It looks like Universe assumes all A types are inherently multivalue.
**********************************************************************
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support
Centre (+61 3 9269 7555) immediately, who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer related viruses.
**********************************************************************
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/341 - Release Date: 16/05/2006
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/