Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread EMPTY and DROP
Wed, Nov 25 2009 10:56 PMPermanent Link

Phil Read
HI simple question, I've seen the 11013 error before and know it can be
a permission based problem...

But I'm getting a 11013 when trying to EMPTY or DROP a table (a memory
table in this case). Question is... How comes I can write to the table
but can't EMPTY it?
Thu, Nov 26 2009 1:24 AMPermanent Link

"Raul"
Phil,

Empty requires an exclusive access so if another session has table open you
would receive 11013 error.
Similarly for delete (drop) the table must be closed (and active=false) so
make sure you don't have table open somewhere else.

In both cases regular record level insert/edit/delete operation would work
just fine.

Raul



"Phil Read" <phil@vizualweb.com> wrote in message
news:6D853137-5DD9-42F1-BDDE-4BBA4E197A02@news.elevatesoft.com...
> HI simple question, I've seen the 11013 error before and know it can be a
> permission based problem...
>
> But I'm getting a 11013 when trying to EMPTY or DROP a table (a memory
> table in this case). Question is... How comes I can write to the table but
> can't EMPTY it?
>



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4637 (20091125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


Thu, Nov 26 2009 4:40 PMPermanent Link

Phil Read
Thanks Raul! Wink


Raul wrote:
> Phil,
>
> Empty requires an exclusive access so if another session has table open
> you would receive 11013 error.
> Similarly for delete (drop) the table must be closed (and active=false)
> so make sure you don't have table open somewhere else.
>
> In both cases regular record level insert/edit/delete operation would
> work just fine.
>
> Raul
>
>
>
> "Phil Read" <phil@vizualweb.com> wrote in message
> news:6D853137-5DD9-42F1-BDDE-4BBA4E197A02@news.elevatesoft.com...
>> HI simple question, I've seen the 11013 error before and know it can
>> be a permission based problem...
>>
>> But I'm getting a 11013 when trying to EMPTY or DROP a table (a memory
>> table in this case). Question is... How comes I can write to the table
>> but can't EMPTY it?
>>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4637 (20091125) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
Image