🚀 go-pugleaf

Magnus wrote:
> Hi,
> 
> I use the below stmt to do a "lock" on the table.
> It works great on JDS and MySQL but I get the following error on MS SQL 
> Server 2000:
> 
> e:com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE 
> clause allowed only for DECLARE CURSOR.
> 
> Can anyone point me in the right direction here?
> 
> TIA
> 
> 
> ---
> rs = stmt.executeQuery("select path from location " +
>                        "where compid = \'" + compId + "\' " +
>                        "and location = \'" + location + "\' " +
>                        "FOR UPDATE ");
I managed to get it to work using 2 statements:

stmt.executeUpdate("DECLARE cursor_name CURSOR FOR " +
                    "select path from location " +
                    "where compid = \'" + compId + "\' " +
                    "and location = \'" + location + "\' " +
                    "FOR UPDATE ");

rs = stmt.executeQuery("select path from location " +
                        "where compid = \'" + compId + "\' " +
                        "and location = \'" + location + "\' ");

I don't know if this will lock the rows though.

After I'm done, as part of cleaning up, I "DEALLOCATE cursor_name" to 
release everything. Otherwise I got an error the second time I went to 
the same setup screen and tried to insert more values ...