Hello,
I am trying to produce a text table with some lab results as well as the material description. I would like to use the ComponentDesc function, however can't get it to work. Could someone please help.
Here is what I have (Name and Desc are not working and return null values):
I have also tried
<<SqlRange(<<Lookup(<<Depth>>,<<DataSetKey(<<#>>)>>)>>,<<ComponentDesc([COF_GOS_DESC_NAME],False,False)>>,[GEOL].[GEOL_BASE])>>but that doesn't work either.
Thanks for your help.
Calan
Hi Calan
After searching my emails I see you asked me almost the same question in Sep 2009.
The second parameter of SqlRange is meant to be a [table].[field] reference.
At this time, I think you have two options:
1. You can’t simply reference the existing COF_GOS_DESC_NAME component library table; you must write a new library table that uses a SqlRange function. For example: <<SqlRange(<<CLSS.Depth>>,[GOSA].[GOSA_NAM],[GOSA].[GEOL_BASE],[GOSA].[Depth],1)>>
2.Via the <<Sql()>> function. Within the SQL SELECT statement you can create a list of items, separators and case definition etc. It isn’t as convenient as the component description.
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Thanks Phil,
Your archiving and searching of old emails is a lot better than mine. :)