Author: Andrew Stirling
Posted: 2012-02-12 at 11:07:25
Good to hear from you Jean.
Yes, I can see the logic in that, but it then means I only need to put
.t. as choose , ;
instead of
IIF(EMPTY(natno) OR ninoconfirm = .f.,.t.,.F.) as choose, ;
in the field selection.
Working Sunday, HMRC has decided that the information in EVERY payrun
has to be sent to them, before they just got the totals at the year end.
So to stay with the big boys, I have to put in the hours!
Kind regards
Andrew Stirling
01250 874580
support@calcpay.co.uk
HMRC Accredited UK payroll program
On 12/02/2012 14:29, Jean MAURICE wrote:
> Andrew, I don not thonk that a where clause can work on a calculated field. So
> the correct query is somthing like :
>
>
> SELECT ;
> IIF(EMPTY(natno) OR ninoconfirm = .f.,.t.,.F.) as choose, ;
> natno, ;
> ninoconfirm , ;
> surname ;
> FROM calcpay!employee ;
> WHERE EMPTY(natno) OR ninoconfirm = .f.;
> ORDER BY refn DESC ;
> INTO CURSOR Empinfo READWRITE
>
>
> Working on sunday ??!!!
>
> Best regards
> The Foxil
>
_______________________________________________
Post Messages to: ProFox@leafe.com
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/4F37E3BD.7090204@calcpay.co.uk
** 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.