🚀 go-pugleaf

Ken,

Thanks for the response:

>How about just comparing one field with <= or >=

These give the same error.

>Are you sure you're referencing the correct rowset?

Yes.

>What is the SQL statement for the query?

select * from '<table>'

>Are you sure the variables have values? Try assigning the expression to a 
>separate variable, and display that variable before assigning to filter.

Yes, all this has been done, tested.

>Try another character field with a similar comparison.

Done, same results.

There is no question that the '>' or '<' is the culprit. If I take it
out of any of the statements tried, the statements work. For example,
if I do this:

pcValue = 'SMITH'

form.rowset.filter := "Last_name = " + ['] + pcValue + [']

the statement works. But as soon as I change the '=' to '>=' the error
'Operation not applicable' comes up. Or if I change the '=' to '>' the
same error occurs.

Any other ideas? Are you getting a '>=' or '>' alone to work in
similar statements?

Ned