Configurator - Blank Title 135300

Yahoo Archive
1
I have only played with this a bit, but here's my experience.

I had issues importing my spreadsheet with the table setup I best-guessed from the documentation. Someone recommended entering a new table in Configuration Lookup Table entry, then exporting that and examining it to get a good format.

If this is your issue maybe this will help.

Joe Trent
Bigham Ag

On Fri, Mar 6, 2015 at 8:08 AM, erp07052@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p>OK - this should be simple and straightforward...but not so lucky<br></p><p>

Â

using a PCLOOKUP.DataLookUp to lookup data from a configuration LOOKUP table

which is almost exactly the same as the OUT OF THE BOOKÂ sample


but It doesn’t work … it always returns a null value.. There are NO error messages

Â

Here is the lengthy documentation on this command

  • DataLookup(<lookuptable>,<columnname>,<rowname>) returns single value

Â

Code used to call from a On Change field - is

Â

Inputs.Comments.Value = PCLookUp.DataLookup("TYPETABLE","PARTNUM","8");

Â

I’ve hard coded an “8” as the row value .. but i've also used values from other inputs

 it doesn’t make a difference. The system  never returns a value from the table.


The lookup table is populated

the columns are

seq1 - TYPE - string 1

seq2 - DESC - srting 50

seq3 - PARTNUM - string 20


table is TEMPLATE

column set is TYPES

lookup table is TYPETABLE


any ideas?

regards


<p></p></div>
 


<div style="color:#fff;min-height:0;"></div>