Text vs Depth Formatting Questions
1) How do I add/format proper callouts to my text expression in my strata description? (Image 1.1, 2.1)
Image 1.1 (Desired Output)
2) Why is my strata description repeating at the top of each page? Also, why am I receiving text for areas where there…
Do we have a database sample for AGS 4.1 for the gINT?
Do we have a database sample for AGS 4.1 for the gINT?
populate table from multiple other table - null error
I'm using 10.02.00.04 working with enterprise database.
I'm trying to pre-populate a table with data from 2 other tables. modifying gr005 my rule works fine as long as all the fields I'm pulling from have a value. Otherwise I get this:
When I try…
GRAT table. gINT Code Execution Error: too few parameters. Expected:1
gINT Rules Code execution error. Error Text = (&H800a0bf5) Too few parameters. Expected 1. Line: 936 Table: GRAT Data set: OCW02_REC_ECR_001_VC,1,1-2,C,03ca9beb-8b32-4c31-8897-c36acc4c5a04,1.75,001_VC_02_C Row 0, Column 'Reading'
I'm not sure what…
2nd Data Markers (Multiple Plots) do not show on plot
Hello,
I'm having trouble getting my 2nd Data Marker to show in the plot on the right. The first data (DCPT - triangles) shows but the second data (SPT - squares) does not. However, I can see that the program does recognize that there is a 2nd Data…
how to change field properties with rules
I'm trying to make a rule that will change field properties (required, read only) and can't figure out how the correct usage. Any pointers?
it will eventually be part of if statements but for now...
I get ActiveX automation object var is Nothing …
gra008 modification for Enterprise DB
I'm unsuccessfully trying to modify gra008 to work with our Enterprise database.
I think the main problem is with my sSql select & set code:
sSql = "Select * " & _ "From POINT " & _ "Where sProjectIDfield = gINTRules.EnterpriseCurrPrjID" Set snPointIDs…
gINT Rules in Enterprise Database
I am attempting to run gINT Rules while working in an Enterprise Database - gINT Connect V 10.02.00.04 ( Professional Plus) - and can not figure out how to implement them.
In a single project I am able to go to "Table Properties" - gINT Rules. and select…
How to add field for depth below stratum?
Hi,
I am new to gINT, my goal is to plot a graph that shows Data vs depth below stratum top (e.g. the ground comprises 0.2m Topsoil + 0.8m Clay and I want to plot the data at 1m bgl as 0.8m instead).
In excel, I was able to obtain such depth by…
Potential gINT rules bug with first row?
This may be a known issue and I'm unaware that it exists.
I have a split table kDCP (parent) and kDCPreadings (child). The parent table has field for the start depth in millimeters (mm). The child table has input fields for Depth captioned as "Cumulative…
gINT Rules - Write to a field in the Project Table
I've been asked to write a gINT Rule that will fill out a field in the Project table based on data written to another field in the Project table when data is imported.. I've done a number of gINT rules in the past to write to Point and Sample tables and…
Uppercase Letters in gINT Output Tab
Hey,
Is there a way of exporting file names with upper case letters in the output tab in gINT? I tried using Ucase in export scripts but no success.
I've got Excel and AGS exporting from the Input tab with capital letters but unable to get any of…
GintPointSort using sigle digit number and sorts in wrong order
Hi,
we are using GintPointSort rule (GR016) for sorting boreholes with different names. Assigning sort number works properly. Problem is that gint rule assign number with single digit (without leading zero) which causes problem with sorting (1,10,11…
gINT Rules throws error at CallByName
I am beginner learning the gINT Rules .
I am trying follow with the GR001 tutorial at page 97 (Code Samples) First Iteration in the book and apply it against a simple trial code project to see if I could get a sample text placed in the grid.
I have…
gINT SQL Sum Quandry
I'm trying to parse some SQL to ultimately export N60 information for soil classifications (line numbers added for discussion sake, not in the code). The trouble is, gINT isn't liking it when I use gINT code inside the SQL other than '<<PointID>>'. It…
Generating N60 in rules
I am looking for guidance on how best to generate an N60 value in the database itself. The main problem I have is I just can't code worth a darn, and to be honest, I don't completely (ie barely) understand gint rules. I currently use a modified version…
Cell Color Property gINT Rules Writable by DAO
Is there a way to access the cell color property in gINT Rules through DAO or ADODB? I would like to change the cell color of tables not currently active (ie. GridData procedures won't work here).
Atterberg Limits Graph - adding the U-Line to the graph
Hello - I got a request to modify our Atterberg Limits graph to include the U-line in addition to the A-line. Has anyone attempted to plot the U-line (equation is PI = 0.9(LL-8)) on this graph along with the A -line?
I can't seem to figure out where…
User Dialog Picture Items in gINT Rules
Does the gINT Rules language support the use of picture items within user dialogs? User dialogs function as in other VBA platforms, but I cannot seem to pull picture items to display in the dialog box. The function I would like to use is:
Sub Main…
Re: Automatically Include Log Key (Key to Symbols) Report with Output
John Sharkey asked: I’d like to automate the addition of a 2-page legend, describing our report symbology, to our final log report export to pdf. I’d rather not write a script to accomplish this since the guys would have to run the script each time they…
Re: User System Data?
Welcome to using gINT!
Functionality can be added to your Water Content table in the INPUT application using gINT Rules, and there are several examples of gINT Rules that populate calculated data into the project database here in the WIKI .
However…
Re: Updating data using recordsets
There are many different programming styles that will work for gINT Rules, below is one style. It took longer to write this description up than it took to create the code that works. Again, this is just one suggestion as to what might work for you.
…
Re: gINT Rules, calculations on input data
Martin, I am confused by your description of the process. If the table is empty, what data are you loading from it into the array?
If you look in your Docs folder (gINT Help menu/Manuals), you will find a document called gINT_Rules_Code_v8i.pdf. Search…
Re: "Type Mismatch" Error in Windows 7 (64-bit)
The statement:
Dim Boo_Check As Variant
is the declaration. What Phil suggested is that you change this declaration to:
Dim Boo_Check As Boolean
That limits the valid settings for Boo_Check to True or False . (The Variant data type is defined…