System queries on project lever from version 10 or higher – GeoDin Support

With the switch to the new GeoDin project structure from version 10 onwards (for more information, see our Help Centre article Object limit for projects removed and Upgrade to GeoDin 10), it is necessary to integrate the object registration table GEODIN_LOC_LOCREG into system queries that are to be displayed at project level (see screenshots).

System query at project level (display conditions)

Object registration table GEODIN_LOC_LOCREG as part of a system query at project level

Object registration table GEODIN_LOC_LOCREG as part of the FROM clause of a system query at project level

Otherwise, depending on the database system, you will receive the following error message when executing the query:

Microsoft Access database:

[FireDAC][...] Too few parameters. Expected 1.
Client/server database:

[FireDAC][...]Invalid column name 'ProjectGUID'.

Related to