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

Notification

Icon
Error

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

Reputation:

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

or 

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

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

Reputation:

Groups: Registered, Administrators
Posts: 42
Australia
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.