Configuring .ini files to use in-built and custom MS Access functions

When configuring the mapping section of an .ini file for any exeGesIS product certain limitations apply to the use of functions to extract data from the relational database. Specifically, functions that need more data than the relevant entity UID need to be 'wrapped' in a DLookup. For example, in the cases of 'NGRoutput' and 'Left', respectively:

AccessField1==Dlookup("NGRoutput([Easting],[Northing])","Mon","[MonUID]=""#MonUID#"""))

AccessField2==Dlookup("Left([Summary],254)","Mon","[MonUID]=""#MonUID#""")

Comments

Comments are closed on this post.
Find out more