We have some queries that are used in separate gINT project using gINT Professional.
When the same queries are run when the projects have been upsized to Professional Plus then they don't run, despite all of the relevant tables and libraries existing.
Is there a way to only run the queries against the current project selected from the SQL database? I can't seem to find anything in the Help Documentation to assist.
The queries that just look at a particular table run fine (such as Unique Geology Codes / Unique Legend Codes), but return everything from the database across multiple projects, which is not what we want.
Hi Paul
I think the problems is you are joining to a table in the library. The project is SQL Server and library is Access. You should try sub queries
select [POINT].[Type], (select [DG_COM_HOLE_TYPE].[Description] from [o:\dgdt-dlst 5.05.0 lib.glb].[DG_COM_HOLE_TYPE] where [DG_COM_HOLE_TYPE].[Code] = [POINT].[Type]) from POINT
I have found it more stable to use [<library path name>].[TableName] rather than: IN 'lib...'
You will need to add: where [gINTProjectID] = '<integer number>'
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.