GoldSQL: Practical Example
Resizing editor: The following query in the GoldMine editor finds email addresses:
CS.Accountno,
C1.Contact,
CS.Contsupref + CS.Address1 as email
from
CONTSUPP CS
left outer join Contact1 C1
on C1.Accountno = CS.Accountno
where
CS.Contact = 'E-mail Address' and
CS.Contsupref + CS.Address1 in
(
select
CS1.Contsupref + CS1.Address1
from
contsupp CS1
where
CS1.RecType = 'P' and
CS1.Contact = 'E-mail Address'
and upper(CS1.Contsupref + CS1.Address1) like '%.COM%'
)
order by email
In the GoldMine editor, the first 5 lines up to ‘from’ are visible, necessitating scrolling to see the rest of the query. This is cumbersome and makes queries difficult to find, as you cannot view the whole query in the editor. If there are errors and the query cannot execute, it is even more problematic.
Opening multiple copies of GoldSQL: The following two queries extract history events in the last week or in the last quarter.
select * from conthist where ondate < getdate() - 90
GoldSQL makes it possible to load two different instances of the program, load the two queries and execute them. The results can then be compared, while retaining the ability to instantly go to the GoldMine record using the ActiveSync checkbox. Read the full datasheet or view the demonstration video to learn more.
