🚀 go-pugleaf

Magnus

Sorry, but I have not tried anything like that recently.. Remember these 
forums are primarily for the support of DataExpress, therefore more 
general JDBC/Driver support issues should be posted to the specific JDBC 
vendor's support forums.. (for the best answers..)

John..


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 ");


-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================