Announcement

Collapse
No announcement yet.

8.1.012: DateTime Field not work in lookup.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 8.1.012: DateTime Field not work in lookup.

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

    Code:
    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:
    Code:
    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.

    Comment

    Working...
    X