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

Conference ilbbak::ibi_focus

Title:FOCUS, from INFORMATION BUILDERS
Moderator:ZAYIUS::BROUILLETTE
Created:Thu Feb 19 1987
Last Modified:Mon May 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:615
Total number of notes:1779

228.0. "Format problem with Rdb signed longword scale -2" by ESDENG::HENDRIKS () Tue Jun 27 1989 06:39

    
    I'm having trouble putting in the right FOCUS format description in
    my .MAS for an RdB field PART_STD_COST datatype 'signed longword scale -2'.
    
    An example of the field occurence is '15.21'.
    
    I tried
    
    USAGE	ACTUAL	RESULT
    --------------------------
    D9		I4	15
    D9		I4.2	0
    D9.2	I4	15.00
    D9.2	I4.2	.15
    I9		I4.2	0
    I9		I4	15
    --------------------------
    
    I assume I could go on trying, but does anyone know what the right
    USAGE/ACTUAL definition is to get '15.21' as a result?
    
    
    Thanks, Eric.
                 
T.RTitleUserPersonal
Name
DateLines
228.1Example reading signed Quadword scale -2NRPUR::CUSACKFri Jun 30 1989 10:128
    Your Actual should definitely be I4, but I think the problem may
    be in your usage.  I have a field in Rdb that is 'signed quadword
    scale -2', and the values I use are:  Actual=I8; Usage=D12.2.  I
    have no problem using these fieldtypes.  Try bumping up your
    usage to D10.2, perhaps, although it doesn't seem like you should
    have any problems with I4 and D9.2.  It's worth a shot.
    
    Mike
228.2Use D4.2 Actual for Signed Longword Scale -2NRPUR::CUSACKTue Jul 11 1989 10:0712
    My previous reply to this is wrong (228.1).  I had the same problem
    with SIGNED QUADWORD SCALE -2.  The solution is to have the actual
    be D4.2 for the SIGNED LONGWORD SCALE -2, or actual D8.2 for SIGNED
    QUADWORD SCALE -2.  The USAGE would then be D10.2 or D16.2
    respectively.  Also, if you use autordb to generate the .MAS and
    .ACX files for Focus, it will not give the correct actual for these
    Rdb datatypes, it will use I4.2 or I8.2, which is wrong.  IBI verified
    the solution for me.
    
    Hope this helps,
    
    Mike