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