OK fixed it by reversing the where & select SELECT ; .t. as choose , ; natno, ; ninoconfirm , ; surname ; FROM calcpay!employee ; WHERE EMPTY(natno) OR ninoconfirm = .f.; ORDER BY refn DESC ; INTO CURSOR Empinfo READWRITE
I take it that the SELECT does the WHERE first to see if it needs to include the data. Kind regards Andrew Stirling 01250 874580 [email protected] http://www.calcpay.co.uk HMRC Accredited UK payroll program On 12/02/2012 12:26, Andrew Stirling wrote: > Hi > I have a select with > IIF(EMPTY(natno) OR ninoconfirm = .f.,.t.,.F.) as choose , ; > which is fine > but when I try to restrict the output via > WHERE choose = .t. ; > it errors with > 'Operator/operand type mismatch' > What am I doing wrong? > Thanks _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
