sql - path to table

Author: None (None)

Hello!

To execute DLM statement via "sql" proc statement, one has to know the path to table.

Is it possible to get this path by proc code based on entity name? Haven't found anything about it in Uniface Library for 9401.

Regards
Jean-Luc

9 Comments

  1. Hi

    There are two functions that can help you

     $assignments("PATHS")
     $assignments("ENTITIES")
     

    regards

    Jip


    Author: Jip Westerman (jipwesterman@gmail.com)
  2. Hi Jip,

    where have you found this info?

    I could not get a documentation on the 9.5.01 chm file (neither index nor search nor "uniface Reference => Proc: Functions)

    Because this CHM seems to be the only documentation CPWR delivers, it should be somewhere in this file.

    Uli

     


    Author: ulrich-merkel (ulrichmerkel@web.de)
  3. Hi Uli,

    just a little reminder for us all... look here.

    And also be warned, that there is the $entinfo("MYENT", "DBMSPATH") function, but accoring to ulibrary it returns path assigned to entity in the applicaton model (so it is not the real path used at runtime?!?).

    Zdenek


    Author: sochaz (zdenek.socha@fullsys.cz)
  4. Hi Zdenek,

    that's exactly the point; somewhere, 3rd hand info, gossip, ...

    If we pay a lot of money for this tool, do we not have the right of a complete documentation??

    Let me explain:

    This is something starting with a $, so it should be found straight under "Reference:Procedure" AND under "index".
    As you see it on 9.5.01 E101 CHM, no chance to find it. This is pure sh***.

    If CPWR can not provide this simple documentation issue, does the tool really meat commercial standards?

     


    Author: ulrich-merkel (ulrichmerkel@web.de)
  5. Hi all,

    I found the information about  $assignments on this site:

    Forum > Uniface Tips and Tricks > $assignments - Return a list of settings of an Assignment File Section and their current values


    Author: Jip Westerman (jipwesterman@gmail.com)
  6. Another undocumented function?

    I didn't find it even in 9.5.01 documentation


    Author: ezioze (ezioze@aruba.it)
  7. Documentation in uniface has turned to a desaster area in the last years.

    Try to find some some issues you have seen in an example usind index or search on the CHM is a frustrating experience.

    looking at the example of "for", we will find a nice way to increment using "+="

     

    for vCounter = 100 to 0 step -2

    vLoops += 1

     

    But have you ever tried to find this documented in the CHM?

    Think it's high time for CPWR to concentrate their efforts to improve the documentation to meet at least minimal industry standards.

     

    I called my local CPWR contact a couple of times and he could not help me either on the question "where is it documented?".


    Author: ulrich-merkel (ulrichmerkel@web.de)
  8. It brings real meaning to 'black art' of uniface development.

    Its all there but bet you cant find it. its my precious

     

    Personally I would not write some ingenious code and then hide it from the world..


    Author: osie_osie (osieman@gmail.com)
  9. Hi Jip,

    Yes, $assignments("ENTITIES") will probably do it.
    Thanks for the hint.

    It would be indeed interesting to know where this kind of "treasure" is buried.

    Cheers
    Jean-Luc


    Author: None (None)