select--endselect

[Former Member]

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]

Hi,

Please explain your requirement in detail.

Thanks,

Naren

[Former Member]

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]

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]

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