Re: what will a count return when ...

That's what I figured from past experience, but am currently doing my initial testing, and don't shoot me, in Microsoft Access. We can't afford licensing for a developement Oracle server anymore, so I do basic application design with Access, and then do the production stuff thru Oracle. Quite a pain, but what can you do.

If access returns nothing, guess I'm feeling the pain of the differences between a good DB and something that I guess isn't really even a DB.

Steve

On Wed, 27 Sep 2000 14:39:21 -0700, "Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote:

>I hope you haven't been sitting there patiently waiting for someone to
>answer this question:
>
>
>SQL> create table test (dummy number);
>
>Table created.
>
>SQL> select count(*) from test;
>
> COUNT(*)
>---------
> 0
>
>SQL> drop table test;
>
>Table dropped.
>
>SQL>
>
>
>
>"Steve ." <syarbrou_at_nospam.enteract.com> wrote in message
>news:onp4tsgs057me2135dcfh8qdlnbslvudch_at_4ax.com...
>> Will a count(*) always return a value of some sort, even if it doesn't
>> find anything? In other words, if the sql statement returns nothing,
>> will the count be 0 or NULL or what? Thanks.
>>
>> Steve
>
Received on Wed Sep 27 2000 - 17:39:53 CDT