RE: SET LOCK MODE TO WAIT <nseconds>

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET

Sebastien Brun — Fri, 3 Mar 2000 09:36:32 -0700 — source: Informix-list mailing list archive (1991-1998)

Dim qrySetLockMode As rdoQuery Set qrySetLockMode = cn.CreateQuery("qrySetLockModeConnect", "") qrySetLockMode.SQL = "SET LOCK MODE TO WAIT 10" <===if you want to wait 10 sec cn.begintrans qrySetLockMode.Execute qrySetLockMode.Close cn.committrans HTH, Lord Brett Sinclair -----Original Message----- From: Tornado [mailto:kurtravnsfanklub@hotmail.com] Sent: Friday, March 03, 2000 6:48 AM To: informix-list@iiug.org Subject: SET LOCK MODE TO WAIT <nseconds> Hi everybody, Ahem... How do one manage to subj. via VB5.0 and RDO ? My connecting goes on as follows: Set rdoCon = New rdoConnection ConnectStr = "uid=" & login_m & ";pwd=" & PassWd_m & ";dsn=db1" rdoCon.Connect = ConnectStr rdoCon.CursorDriver = rdUseServer rdoCon.EstablishConnection rdDriverNoPrompt, False How do I manage to set the LOCK MODE ? Regards Ebbe Hoeg Jensen, Denmark