One problem with Client/Server is mixing languages!
>I find no reference to a function named EXISTS. Is that your UDF or what is it? Youa re trying to pass the return from an SELECT to a UDF is what it looks like. I would suggest doing it this way;
>
>SELECT ... FROM ... WHERE ... INTO CURSOR Result
>IF _TALLY > 0
I was thinking of the EXISTS function that I so often use in SQL Server stored procedures. I discovered, upon perusing online docs, that there is no such fcn in FP. I used RowCount to get a solution. I will investigate the _TALLY that you mentioned to see if it is more elegant. (I like elegant code!)
Thanks for your reply.
David Moreau