topic Re: select--endselect in Application Development and Automation Discussions

select--endselect

Former Member — Wed, 15 Nov 2006 00:30:15 GMT

HI All,

Is there any limit for doing database updation...using SELECT...ENDSELECT..

I have to change only one field from database....

Please advise .

Thanks ...

Former Member — Wed, 15 Nov 2006 00:37:37 GMT

Hi,

Please explain your requirement in detail.

Thanks,

Naren

Former Member — Wed, 15 Nov 2006 03:25:50 GMT

If you are doing a large number of updates, you may have to do a commit every so often. But it would be quicker to use an internal table.

Rob

Former Member — Wed, 15 Nov 2006 04:09:16 GMT

i don't think there is any limit.ya but performance wise it is not gud in try to avoid select endselect( for lot of data it give time out error)

sreekanthgo — Wed, 15 Nov 2006 04:57:08 GMT

Hi,

There is no limitation for updating records in SELECT...ENDSELECT...

You can do n number of updations..

It is not advised to perform the same.. Performance will not be good if you update records in that way.

Thanks,

Sreekanth