fmorais
23rd January 2003, 13:31
Hi,

Created a new type 3 session.
Has several fields, some are enum, some alphanumeric and some numeric (float).

When I use the query by form screen to select just a few records, it works ok for the alpha and enum fields but, for the numeric ones it does not work.
(example: fieldx > 0 or fieldx > 0.0 does not work).

This happens in the field tab and also on the sort tab. You can not sort the screen by a numeric field.

Has anyone heard of this before?

Thanks
Fred

fmorais
23rd January 2003, 19:40
Solved the Problem.

The numeric fields I was using were calculated online, and the query by form session was confused by it.

If you only use normal DB fields on the session, it works ok.

Thanks
Fred.