Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Homer Simpson coding puzzle
Message
From
26/02/2001 09:38:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00479329
Message ID:
00479489
Views:
27
>Cetin,
>
>But if a bear falls off a tree in the woods and no one is around, does it make a sound when it hits the ground?
>
>>>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
>>
>>John,
>>What would the answer be if (assuming preceding lines were never exposed):
>>
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
< bg >
>>
>>I don't remember the exact numbers but this question was asked in our highschool physics exam :
>>
>>A bear sits on top of tree that's 44m high. The bear falls and it takes 3 secs for it to hit ground. What's the color of bear ?
>>
>>We were all stumped at first but there was a solution (wish I remembered the numbers right).
>>x=1/2gt^2 and result g was only possible for a polar bear :)
>>Cetin

Perhaps this thread should be moved to chatter?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform