>Hey all. Simple test of the "doh!" principle here: The question is 'What will end up being printed on the screen?' .. Yes, I know the answer - just testing y'all :-)
>
>And, no, it's not the GenPrimary() UDF
>
>

>OPEN DATA foomeister
>CREATE TABLE foo (pk C(30) PRIMARY KEY,amount N(10,2),quantity N(4,0))
>INSERT INTO foo (pk,amount,quantity) VALUES (GenPrimary(),100.15,1)
>SELECT * FROM foo WHERE amount > 200 INTO CURSOR foobaby
>SELECT foobaby
>DO CASE
>CASE foobaby.amount = 0.00
>  ?"No Sale"
>CASE RECCOUNT('foobaby') = 0
>  ?"No records"
>CASE foobaby.amount <= 200
>  ?"Small spender"
>ENDCASE

"No Sale"