[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

729.0. "Problem with DOCDB, .%WHOLE and FOR-loop" by SAC::JOYCE (Going Down-Under and I don't give a XXXX) Wed May 20 1992 18:05

    
    A funny with DOCDB in a FOR loop (under V2.4) has been bought tyo my
    attention...
    
    <FOR FIRST DOCDB DO GET .%WHOLE
    
    gives me nothing but 
    
    <GET #A = DOCDB.%FIRST[""] \ GET DOCDB.%WHOLE[#A}
    
    gives me what I'd expect i.e. the whole record.
    
    Similarly
    
    <FORM AUTO SELECT DOCDB WITH .%WHOLE NES "" DO SEL_STYLE/etc. etc.
    
    gives me nothing.
    
    Running with trace  indicates that the .%WHOLE field is not being set
    within the context of the FOR loop.
    
    Any comments? (I don't want to use CAB$ instead).
    
    Andy 
T.RTitleUserPersonal
Name
DateLines
729.1SAC::JOYCEGoing Down-Under and I don&#039;t give a XXXXWed May 20 1992 18:079
     re .-1
    
    that was a typo, it should have read...
    
    <FORM AUTO SELECT FOR DOCDB WITH .%WHOLE NES "" DO SEL_STYLE/etc. etc.
    
    
    
Andy
729.2This has taken a long time to surfaceIOSG::MAURICEA few follicles shortWed May 20 1992 18:537
    Hi,
    
    I've followed the code and it's a bug in the DOCDB action routine. And
    it's in V3.0 as well. It looks like it's always been there and gone
    unnoticed.
    
    Stuart
729.3SAC::JOYCELeaving... and I don&#039;t give a XXXXThu May 21 1992 11:489
    
    Re .-1
    
    Stuart,
    
    	Is it just .%WHOLE or any other fields (.%KEY springs to mind?)
    	(I guess I could try this but I'm lazy...)
    
    Andy
729.4SAC::JOYCELeaving... and I don&#039;t give a XXXXThu May 21 1992 11:526
    I just tried...
    
    <for docdb do get oa$display = .%key \\ force
    
    ...and all I get is blanks 8(
    
729.5Even the XXXX field!IOSG::MAURICEA few follicles shortThu May 21 1992 12:199
    Andy,
    
    Any other fields I'm afraid. Perhaps you could give some details of
    what your application is trying to achieve, so that possibly we could
    suggest an alternative strategy.
    
    Cheers
    
    Stuart
729.6SAC::JOYCELeaving... and I don&#039;t give a XXXXThu May 21 1992 12:5625
    
    re .-1
    
  >  Any other fields I'm afraid. Perhaps you could give some details of
  >  what your application is trying to achieve, so that possibly we could
  >  suggest an alternative strategy.
    
    It's actually a "support tool"; an arg form into which you enter the
    name of a dataset, optional alternate k-o-r, an optional rse, optional
    fields to display etc.etc. and it goes away and builds a SELECT FOR..
    and displays the output to the screen or to a file. If the user does
    not enter in an RSE it actaully uses "WITH .%WHOLE NES ''". I can work
    around this but the other problem is that, if the user does not specfiy
    which fields they want to display it uses "SEL_STYLE .%WHOLE" to output
    the whole record. Obviously I don't want to hard-code any field names
    in as this is supposed to be a generic tool for any entry form dataset.
    I realise that under V3.0 I could probably use the OA$FORM_INFO dsab
    but this is on V2.4. DOCDB is a dataset that they search quiet a lot
    for one reason or another (usually trying to sort pout screwed up
    account transfers!)
    
    Andy
    
    Andy
    
729.7FOR loops don't work with DOCDB dataset.FAILTE::LAAHSAn accumulation of CeltsFri May 22 1992 14:279
    Andy,
    
    I think you will find that DOCDB does not support the necessary action
    routines to perform a FOR loop. In my experience it's always been like
    this so even if you were allowed to get to the fields you require it
    probably won't be enough.
    
    FWIW,
    Kevin
729.8SAC::JOYCELeaving... and I don&#039;t give a XXXXFri May 22 1992 19:177
    
    But surely, DOCDB is just an entry form isn't it? What's the difference
    between it and PROFIL?
    
    If it was CAB$ that I was havinf a problem with I'd understand...
    
    
729.9Non-standardIOSG::MAURICEA few follicles shortFri May 22 1992 19:278
    Re .8
    
    No - both DOCDB and PROFIL are both "special" entry forms where there
    is Bliss code underneath to interpret the actions. For example in the
    Profile action there is special code so that only administrators can
    update certain fields in the record.
    
    Stuart
729.10DOCDB is very strange (or even special)SIOG::T_REDMONDThoughts of an Idle MindSat May 23 1992 21:426
    Right, and in V3.0 DOCDB becomes even more special.  Those that doubt
    this statement should call up the form on screen and press GOLD/V. All
    of a sudeen you see fields that count up to considerably more than the
    500 bytes record length known by RMS...
    
    Tony