2. ASPRunnerPro General questions
  3. Lookup Table Custom Expression Problem
This topic is locked

Lookup Table Custom Expression Problem

 		3/28/2008 4:00:05 AM
ASPRunnerPro General questions
M
 matt.cohen author

Hi,
I seem to have found an interesting problem that I was hoping to find a way around.
When using a custom expression in the display field of a lookup table, if all the referenced fields in the expression do not have a value, a blank line appears in the drop down box for that entry.
To say it another way
A line appears in the drop down box for every entry in the lookup table. Only the records that have all referenced fields in the custom expression completed are actually shown.
I hope this makes sense.
It would be nice if there is a not a value in the field just not to display its value. Not just scrap the whole line.
Cheers
J
 		Jane 3/28/2008

Hi,
to hide records with empty fields add where clause to your dropdown on the "Edit as" settings dialog.
M
 		matt.cohen author 3/28/2008

Hi,

to hide records with empty fields add where clause to your dropdown on the "Edit as" settings dialog.


Jane,
I think you have misunderstood.

I do not wish to hide the records as they are not completely empty. The appear blank if any information is missing. I would like it to show the information that is present in the records.

I first thought that it was not displaying because the field that it was linking to did not have a value. I then added another field and gave it a value for all records. I then found that if any one of the field used in the custom expression did not have a value the whole line, being all referenced values was displayed as blank.

To make it clear if four values are referenced and three have a value and one does not the whole line is blank.
Thanks in advance
Sorry if its a bit wordy
Sergey Kornilov admin 3/31/2008

Matt,
hard to tell what is wrong without seeing your application.
Post your project to Demo Account and send the URL to support@xlinesoft.com.
M
 		matt.cohen author 4/3/2008

Matt,

hard to tell what is wrong without seeing your application.
Post your project to Demo Account and send the URL to support@xlinesoft.com.


I have posted the project to a demo account which does not seem to work.

I have emailed support with no response as yet.

Can you please confirm that you have received it.
Sergey Kornilov admin 4/4/2008

Matt,
what's your email address?
M
 		matt.cohen author 4/4/2008

Matt,

what's your email address?


mathew@tavsa.com.au
J
 		Jane 4/4/2008

Matt,
if some fields used in the custom expression aren't filled in the lookup table linked value won't show (empty line).

There are two ways to avoid it:

  1. hide these values
  2. or select all fields in the custom expression and cut first 20 symbols.
M
 		matt.cohen author 4/4/2008

Matt,

if some fields used in the custom expression aren't filled in the lookup table linked value won't show (empty line).

There are two ways to avoid it:

  1. hide these values
  2. or select all fields in the custom expression and cut first 20 symbols.


By hiding the values do you mean using an IF in the expression?
What is the syntax for the second option please.
Thanks in advance
J
 		Jane 4/7/2008

Matt,
to hide records with empty fields use WHERE clause.
To cut value in the SQL query use corresponding SQL functions, for example Left() for MS ACCESS[/b] database.