Re: WHERE CURRENT OF and dynamic SQL

I am using 'for update of' with dynamic sql in proc programs and have no problems. It's on a cursor select

I don't know it this is truely locking the row - I've never check while the program is running but the program works as written....  

"Scott D. DeWitt" wrote:
>
> All:
>
> I just read that you cannot use the CURRENT OF clause when using dynamic
> SQL. Also, the documentation says you cannot have a FOR UPDATE OF
> without a CURRENT OF, so I assume that neither of these clauses can be
> used when doing dynamic SQL. This means that we are not able to open a
> cursor for update of some columns in the select statement, scan through
> each, modify and replace them using the CURRENT OF in dynamic SQL. Is
> there some other dynamic SQL to support this process? I can't imagine
> that there is no support for this as it seems an awfully common thing to
> do. I have thought about implementing my own sort of cursor, which
> doesn't seem terribly hard. However, if you leave off the FOR UPDATE,
> then the rows don't get locked.
>
> Anyone know of a way to do this type of procedure using dynamic SQL?
>
> Thanks in advance,
> Scott DeWitt
  Received on Wed Dec 08 1999 - 00:00:00 CET