Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Friday, January 28, 2022 8:34:58 AM(UTC)
Rank: Newbie


Groups: Registered
Posts: 4

Thanks: 1 times

i have had success pulling data in the gedts file for additional fields in locations and boreholes table. when I try to do this to pull information from the site table I get SID errors. 

there are other site table data that get passed through to the gedts file but seems to be called by the project_out_information  1. is there a way to query out the site data from the site data explicitly for use in the header info section


2. is there a way to adjust the project_out_information to include more site table fields ​​​​​​​thanks in advance

#2 Posted : Friday, February 18, 2022 3:56:32 PM(UTC)
Rank: Administration


Groups: Registered, Administrators
Posts: 49
Location: Sydney

Thanks: 1 times
Was thanked: 5 time(s) in 5 post(s)

Hi DCook,

you will get an SID error because the borehole SID needs to match the site table ID.

You can do this by performing and inner join on the boreholes table and the site table

[Boreholes] inner join  Sites On Sites.ID = Boreholes.SID 

Then specify which fields from the sites table you would like to display.

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.