Querying empty records doesn't seem to work with revolution

[Ruslan Zasukhin]

On 2/16/09 3:18 AM, "Antuan Johnson" <amjohnson09 at gmail.com> wrote:

Hi Antuan,

May be  that records have NULLs ?
Then search is 

    WHERE Writer IS NULL

> When I apply this select statement in Visual Studio it seems to work well and
> retrieves rows that don't have a specific value, but when I try in revolution
> it doesn't work.
> SELECT Act FROM Artists WHERE Writer = ''
> 
> 
>  put VDataBase_SQLSelectRecords(mData, "SELECT Act FROM Artists WHERE Writer =
> '' ","kServerSide", "kReadWrite", "kRandom",1,10,tab,CR) into curs

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]