• 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…

  • sqlrange in output condition

    At first, I could not get lab data to print with an output condition of: <<Report Var.Stratum>> = <<SqlRange(_ <<Depth>>,_ [SAMPLE].[Stratum],_ [SAMPLE].[Depth] + [SAMPLE].[Length] / 12_ )>> Yet the sqlrange statement correctly printed "Soil" when…

  • Re: Average discontinuities per run

    You just need to take the Query that you have working and make a few changes so that it will work on a Log report. Here is your Query: Select Count ([DISCONTINUITY].[Angle]) From [DISCONTINUITY],[SAMPLE] Where [DISCONTINUITY].[Depth] >= [SAMPLE…

  • 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…

  • Date SQL Query Not Working

    Hi all, Phil Wade helped me with the SQL for this query the other week and it worked fin, until now! It goes like this:- A non-SI based gINT setup for concrete cube testing. Data about each cube is stored in the CUBEDATA table, including Date created…

  • 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…

  • Re: Show geological layer name for test results on graph report

    I also have the same problem. I have a graphic table with various results (Blow Counts, PI, Su, etc.) and would also like to display the geologic origin and USCS code in the sample table. I used the SqlRange function and followed example 2 from the help…
  • PDF

    gint_articles_whitepaper_sql.pdf

    • gint_articles_whitepaper_sql.pdf
    • View

  • Programming

    Inside gINT is a VBA-like programming module called gINT Rules. This allows you to modify the way the gINT program behaves. Add Your Own Menu Commands to gINT's Menus Create Custom Lab Lesting Data Entry Screens Programming Color the Data…
Communities
Support and Services
Training and Learning
Social Media