select shows deleted records

[Ruslan Zasukhin]

On 9/25/06 3:53 PM, "Pierre Rossel" <prossel2 at myrealbox.com> wrote:

> Hello,
> 
> I have a database with 1 table MediaFolder with 2 fields ('name':
> VarChar[128]:I, 'mediaTypes': VarChar[128]:I:N)
> 
> Insert 3 records (execute 3 times):
> 
>   insert into MediaFolder (name) values ('new folder')
> 
> Delete record 2:
> 
>   delete from MediaFolder where recID = 2
> 
> 
> This query correctly returns record 1 and 3:
> 
>   SELECT RecID, * FROM MediaFolder
> 
> 
> BUT this query returns record 2 as well even though it has been deleted:
> 
>   SELECT RecID, * FROM MediaFolder WHERE mediaTypes is NULL
> 
> If there is nothing wrong with my query, I will add this to mantis with the
> sample database.

Yes looks like a bug.




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