Bool missing creates error

[Ruegen]

I'm trying to locate why a function gets an error in a table

There is a related table that attaches to a show (trading company)

If the show isn't attached to a trading company it can't get the BOOL value

Since I don't know what past trading companies went with what shows - I get neither a yes nor no bool value

my function tries to pass (I'm guessing here) a bool that it can't pull from since the show doesn't have a trading company and thus the field value true or false

is there a function to detect when it is missing?



Cheers

[ranman256]

You need an outer join to show all trading companies, existing or not. THEN you can get a BOOL.

[Ruegen]

I found I had to pass the parameter as a variant (not as bool) else the ismissing() wouldn't work - sorted.

[ranman256]

I don't think you use ISMISSING here. Params still work with outer joins.