Skip to main content

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

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

Hi

There are two functions that can help you

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

regards

Jip


Author: Jip Westerman (jipwesterman@gmail.com)

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

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)

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

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)

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

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)

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

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)

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

Another undocumented function?

I didn't find it even in 9.5.01 documentation


Author: ezioze (ezioze@aruba.it)

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

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)

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

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)

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

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)