8.1.012: DateTime Field not work in lookup.

Scriptcase 8 Bugs
#1

Hi
i have a select field “controller” and a date field “validfrom”. The field “controller” has a lookup with this query:

SELECT controllername from tblcontroller where validto < {validfrom}

The SQL generated by scriptcase says: "SELECT controllername from tblcontroller where validto < " and gives an error.

With any other field except datetime fields, the lookup query is generated correct from scriptcase, for example:

SELECT controllername from tblcontroller where validto < tblcontrollerid

works and the where clause is “validto < 1”. So seems to be a problem only with datetime field not parsed correct by scriptcase. Please fix that.

Thank’s and best regards
Steve

#2

More infos about that

I can give more information about that… the {validto} field is for the query only available, if it is AFTER the field i make the lookup… means:

If i have the order:
{controller}
{validto}

then i can user the {validto} in the lookup of the controller. If i change the field order to
{validto}
{controller}

so the evaluation of {validto} is empty string.