Thanks Kris and rueibin,
Thanks a lots. It works fine when using Delete_from statement.
Siva
Muthu krishnan <[EMAIL PROTECTED]> wrote:
Hi,
Try this...
EventInBox event;
;
delete_from event where<>;
This will help you....if you need condition then you can use where clause
otherwise if you want to delete all the record in a table just execute the
following..
delete_from event;
Note: This command will be execute mush faster than any other statements
because delete_from is used for executing bulk execution process.
Good luck;
Regards,
kris
rueibin88 <[EMAIL PROTECTED]> wrote:
Hi Siva:
You can write a SQL command within Query Analyzer like this.
Delete eventTable
where condition
.....
I believe it will be faster, but make sure you check the delete
action within Axapta before you delete these records in case there's
other tables that you need to delete as well.
Good luck.
Jeffery
--- In development-axapta@yahoogroups.com, Siva kumar <[EMAIL PROTECTED]>
wrote:
>
> Hi,
>
> I am having sround 9 lacs alerts in the eventInBox table. I
tried to delete it, It took 4 hrs to delete 10000 records. To
complete 9 lacs It will take an week. Is there any easy way to delete
quickly.
>
> Even I tried to delete the alert in manahe alert tule form. Same
thing happening.
>
> Thanks,
> Siva
>
>
> We Born to Win...
>
>
>
> ---------------------------------
> Be a better Heartthrob. Get better relationship answers from
someone who knows.
> Yahoo! Answers - Check it out.
>
> [Non-text portions of this message have been removed]
>
---------------------------------
Download prohibited? No problem. CHAT from any browser, without download.
[Non-text portions of this message have been removed]
We Born to Win...
---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.
[Non-text portions of this message have been removed]
