Re: ODBC

are you saying you are putting a lock on a back end oracle table when you
use a remote view?

What if you turn off the 'update' tick in the view designer ?

Regards [Bill]

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"MarcF" <MarcF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B5722B7B-46D7-4501-8A31-82112F5ECCFB@xxxxxxxxxxxxxxxx
Hi guys...

I am doing an application that questions a SQL database with PSQL ODBC.
It is working find but it open the views exclusively, noboby else can use
it
at the same time.
Is there a way to use these views in multi-users?

Marc F


.

Relevant Pages

  • Re: speed of light
    ... but for some reason that is being affected by the round trip ... Have multiple threads of execution, ... Have the remote database as an NFS mount so that Oracle thinks ...
    (comp.databases.oracle.server)
  • Re: Lock-free databases
    ... > lock, latch, enqueue, or other name is a lock for the purpose of this ... Database concurrency control. ... be it Oracle or SQL Server ...
    (comp.databases.theory)
  • Re: Informix beats Oracle
    ... What's the difference between that and this new feature? ... similar to the Oracle implementation, and was not available in other products. ... Using this, you won't block when trying to read a row that has a lock. ... I'm "tired" of explaining the locking issues to developers that were trained only in Oracle... ...
    (comp.databases.informix)
  • Re: Deadlock - advice needed
    ... Lock table order_release_bp in share mode; ... Resource Name process session holds waits process session holds waits ... After reading about the Oracle locking, my guess is the the stored ... "Unindexed foreign keys cause DML on the primary key to get a share row ...
    (comp.databases.oracle.server)
  • Re: Locking question when using Select clause with For Update and Skip locked
    ... This is working fine in SQL Server and multiple session can get the ... But in Oracle the first session only return 1 row but locks all the ... It looks like both the session got the ROW-X lock but one session is ...
    (comp.databases.oracle.server)