• Text Tables: Statistics For a Non Key Field

    Within the LITHOLOGY table, there is a field .Stratum where each row in LITHOLOGY can be assigned a .Stratum integer 1-9. Suppose they are not necessarily in depth order (interlayered) and several LITHOLOGY rows within a POINT might be assigned the same…
  • dbo.WH_TableProperties and dob.WH_ColumnProperties

    Hello all, Does anyone have a data dictionary for these tables (gINT CONNECT 10.00.00.69 (gINT Professional Plus) & MS SQL Server 2017 Express) which are created on the SQL database when upsizing a gINT project to an enterprise database? Some fields…
  • gINT: Use NextDepth function inside SQL

    Hi All, For a project, I need to get the difference between current depth and the next depth in SQL. I've tried the following code at it fails. I also tried SQL LEAD and it seems it's not supported by gINT. Any idea how to get both current and next…
  • gINT Data in a SQL Environment

    Team, My company is starting to research the use of SQL to host it's gINT data. It is working out very well in our test group. We are able to use the data in a BI software and create boring plans in GIS very efficiently. We are only seeing a few items…
  • Enterprise Databases Hosted in AZURE

    Hi Folks, I am looking for some insight on if anyone has tried or been successful with using AZURE with gINT. I have been able to get the database created but I am having a few problems. When trying to upsize I get a timeout error around 30 seconds…
  • gINT - Correspondence File SQL Query / Text too long?

    I am trying to concatenate a few bits of text into my Hole_Log table. Basically I want to combine 2 fields within some hand written text e.g. "Original log produced by " <<HOLE_LOG>> "in" <<HOLE_STAR),yyyy " and digitally reproduced by My Company…
  • Re: combining data from multiple tables in component descriptions

    I haven't tried to use <<CompDescChild()>> because its stated function is to bring in children of the components table. Since lab data is a child of sample, it doesn't seem applicable. Do you think there's a way to use it here? I asked to find out…
  • Re: gINT Text Reports

    Jaffa, the command Max( expression ) will work for most purposes, including a simple list of dates. In that case, the Julian day number of the date that results from (expression) will be evaluated and the maximum value returned. This will be the latest…
  • Re: Muliple dependant data in graphs

    You need to relate the TRIT data back to the TRIG table, since your graph has a keyset of PointID,Depth. <<SQL(_ select avg([TRIT].[TRIT_CU]) _ from [TRIT] _ where [PointID] = '<<TRIG.PointID>>' _ and [SAMP_Depth] = <<TRIG.SAMP_Depth>> _ and [SAMP_REF…
  • Re: Average of Recovery lengths

    Here are two expressions that will work on Log reports and Fence reports. Average Depth: <<Sql(_ SELECT AVG([SAMPLE].[Depth]) _ From [SAMPLE] _ Where [SAMPLE].[PointID] = '<<PointID>>' _ And [SAMPLE].[Group ID] = <<SAMPLE.Group ID>>; _ 0.000_ )…
  • Re: More than one Foreign PointID Expression

    "...I’d like to show CPT and lab test results [for] up to seven associated points for one borehole..." So in that case, you will probably need a loop from 1 to the count of the associated points to establish a single value for the list item position…
  • Re: "Simple Text"

    You may need an SQL query to collect information from multiple tables, since you are already using the <<PointID>> keyfield in your expression without success. gINT Help has a lot of examples and description of SQL usage under several topic headings…
  • Re: Show geological layer name for test results on graph report

    Rob, it sounds like you want to know what layer stored in GEOL matches the depth of the lab sample from LAB SPECIMEN. This is very similar to Help Example 2 in the SqlRange function topic, where we look for the USCS code that matches a field sample depth…
  • SQL Syntax and Logic in gINT

    RyanZ asked a good question that illustrates a common issue in using the <<SQL()>> function in gINT reports: We are working with two separate coordinate systems in our database. One that is describing the lithology of the soil, lab specimen.depth,…
  • Re: Missing legends on graphs plots from Sql

    Thanks, Phil! I suspect the problem may be the shift from single project to multiple project. RecordItem, as you have noted, works with the single-project GPJ or SQL Server instance. It's only when you are trying to specify data by RecordItem from…
  • Re: Display soil description in Sample Table

    Just looking at the SQL, there are some problems: <<Sql(SELECT (LITHOLOGY.DESCRIPTION) _ FROM LITHOLOGY _ WHERE (<<Sample.Depth>> < <<Lithology.Bottom>>) AND _ (<<Sample.depth>> >= <<lithology.depth>>) _ )>> should be: <<Sql(SELECT [LITHOLOGY…