Searching for an empty/non-empty field

[jda]

>
>
>>  I tried using NULL with V2 and got one of those
>>  weird SQL error windows that you can't dismiss!
>
>You mean new window which show some error?
>
>Aha, I need disable it. This is console actually.
>I do not know why REALbasic show it in such way.

Yes, it is annoying, isn't it?

>
>So our parser say you have error on SQL.
>Check error.
>And show us your SQL
>

I tried this three times just now, each time it crashed:

1. Make a new db
2. SELECT * from thereferences WHERE title = NULL

Crash log:

Thread 0 Crashed:
0   Kernel_Carbon_Debug.shlb      	0x0206ffb8 
CastValueType__Q23fbl9Field_ImpCFQ23fbl26smart_ptr<CQ23fbl7I_Value> + 
0x48
1   Kernel_Carbon_Debug.shlb      	0x02069584 
Find__Q23fbl9Field_ImpCFQ23fbl26smart_ptr<CQ23fbl7I_Value>Q23fbl25smart_ptr<CQ23fbl6BitSet> 
+ 0x40
2   Kernel_Carbon_Debug.shlb      	0x02369a58 
Execute__Q23fbl17PNode_Field_ValueFQ23fbl24smart_ptr<Q23fbl6BitSet> + 
0x58
3   Kernel_Carbon_Debug.shlb      	0x0228434c 
Execute__Q23fbl4PlanFv + 0x4c
4   Kernel_Carbon_Debug.shlb      	0x02215c10 
Execute__Q23fbl5QueryFv + 0x7c
5   Kernel_Carbon_Debug.shlb      	0x0227b234 
Refresh__Q23fbl14Table_IndirectFv + 0x1d0
6   Kernel_Carbon_Debug.shlb      	0x0227af78 
put_Where__Q23fbl14Table_IndirectFQ23fbl25smart_ptr<Q23fbl7I_ENode> +
...


Jon