Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

AdsMgGetLockOwner and TADSQuery

4 posts in Delphi Last posting was on 2012-06-20 15:10:00.0Z
Günter Kieninger Posted on 2012-06-20 09:06:41.0Z
Date: Wed, 20 Jun 2012 11:06:41 +0200
Newsgroups: Advantage.Delphi
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Newsreader: Virtual Access Open Source http://www.virtual-access.org/
Organization: My Company
Message-ID: <VA.00000088.005f3322@mgm.at>
Subject: AdsMgGetLockOwner and TADSQuery
From: Günter Kieninger <g.kieninger@mgm.at>
NNTP-Posting-Host: 62.99.177.218
X-Trace: 20 Jun 2012 02:05:41 -0700, 62.99.177.218
Lines: 10
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25812
Article PK: 1109391

Hi!

When I get the error 5035 (requested lock could not be granted) I would
like to see who has locked the record. This works fine with TADSTable
but with TADSQuery I have no 'Tablename' and so AdsMgGetLockOwner
doesn't work. How can this be done with a TADSQuery?

Thank you
Günter


Joachim Duerr (ADS) Posted on 2012-06-20 13:16:11.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: AdsMgGetLockOwner and TADSQuery
Newsgroups: Advantage.Delphi
References: <VA.00000088.005f3322@mgm.at>
Date: Wed, 20 Jun 2012 15:16:11 +0200
User-Agent: XanaNews/1.19.1.320
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 79.234.243.94
Message-ID: <4fe1cce3$1@solutions.advantagedatabase.com>
X-Trace: 20 Jun 2012 06:15:15 -0700, 79.234.243.94
Lines: 16
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25813
Article PK: 1109390


Günter Kieninger wrote:

>When I get the error 5035 (requested lock could not be granted) I
>would like to see who has locked the record. This works fine with
>TADSTable but with TADSQuery I have no 'Tablename' and so
>AdsMgGetLockOwner doesn't work. How can this be done with a TADSQuery?

do you have my TAdsTableEx component? I'll usually provide it at
conferences and trainings for interetsted attendees. The unit also
contains TAdsQueryEx with the functionality you require.


--
Joachim Duerr, Advantage Presales
*** NEW *** Advantage Pocket Guide released *** NEW ***
http://pocketguide.jd-engineering.de


Günter Kieninger Posted on 2012-06-20 14:45:53.0Z
Date: Wed, 20 Jun 2012 16:45:53 +0200
Newsgroups: Advantage.Delphi
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Newsreader: Virtual Access Open Source http://www.virtual-access.org/
Organization: My Company
Message-ID: <VA.00000089.0195bffc@mgm.at>
Subject: Re: AdsMgGetLockOwner and TADSQuery
From: Günter Kieninger <g.kieninger@mgm.at>
References: <VA.00000088.005f3322@mgm.at> <4fe1cce3$1@solutions.advantagedatabase.com>
NNTP-Posting-Host: 62.99.177.218
X-Trace: 20 Jun 2012 07:44:53 -0700, 62.99.177.218
Lines: 22
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25814
Article PK: 1109392

Hi Joachim!

In article <4fe1cce3$1@solutions.advantagedatabase.com>, Joachim Duerr

(ADS) wrote:
> Günter Kieninger wrote:
>
> >When I get the error 5035 (requested lock could not be granted) I
> >would like to see who has locked the record. This works fine with
> >TADSTable but with TADSQuery I have no 'Tablename' and so
> >AdsMgGetLockOwner doesn't work. How can this be done with a TADSQuery?
>
> do you have my TAdsTableEx component? I'll usually provide it at
> conferences and trainings for interetsted attendees. The unit also
> contains TAdsQueryEx with the functionality you require.

No, I don't have this Components. Maybe you can send it me, you know my
email :)

Thanks
Günter


Joachim Duerr (ADS) Posted on 2012-06-20 15:10:00.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: AdsMgGetLockOwner and TADSQuery
Newsgroups: Advantage.Delphi
References: <VA.00000088.005f3322@mgm.at> <4fe1cce3$1@solutions.advantagedatabase.com> <VA.00000089.0195bffc@mgm.at>
Date: Wed, 20 Jun 2012 17:10:00 +0200
User-Agent: XanaNews/1.19.1.320
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 79.234.243.94
Message-ID: <4fe1e7a3$1@solutions.advantagedatabase.com>
X-Trace: 20 Jun 2012 08:09:23 -0700, 79.234.243.94
Lines: 12
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25815
Article PK: 1109394


Günter Kieninger wrote:

>No, I don't have this Components. Maybe you can send it me, you know
>my email :)

I'll be back in office soon ... could you drop me an email so that I
don't forget to send it?

--
Joachim Duerr, Advantage Presales
*** NEW *** Advantage Pocket Guide released *** NEW ***
http://pocketguide.jd-engineering.de