Searching for an empty/non-empty field

[Ruslan Zasukhin]

On 11/11/04 9:10 PM, "jda" <jda at his.com> wrote:

>> Jon, may be I have now understand, do you want
>> 
>>     WHERE fld IS NULL
>>     WHERE fld IS NOT NULL
>> 
>> ?
> 
> Yes, I think so (assuming NULL can be applied to any text field,
> indexed any way).

Yes of course

> 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.

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


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------