Tim

Is there a possibility that IN could return FALSE when the condition between the brackets is empty rather then generating an error?

I have a number of  statements like

 Contacts.Filter := '_ID IN (' + Restrict.FieldByName(_ContactList).AsString + ')';

I'm wrapping them in a test to see if there's anything there.

Failing that could we have a more explicit error message please? Maybe Empty IN test rather than

ElevateDB Error #700 An error was found in the statement at line 6 and column 9 (Expected expression but instead found ))


Roy Lambert

Roy,

<< Is there a possibility that IN could return FALSE when the condition
between the brackets is empty rather then generating an error? >>

Sure, I can throw that in there.

Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< Is there a possibility that IN could return FALSE when the condition
>between the brackets is empty rather then generating an error? >>
>
>Sure, I can throw that in there.

Brill, as long as it isn't going to break ooodles of code.

Roy Lambert

Roy,

<< Brill, as long as it isn't going to break ooodles of code. >>

Nah, simple fix.

Tim Young
Elevate Software
www.elevatesoft.com