Roy,

<< Any comment on the fact that it doesn't seem to be operating as described
(ie the unlocking bit)? >>

What part are you talking about - the lack of an exception ?  That's
intentional - it doesn't issue an exception if the record isn't locked and
you try to unlock it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>What part are you talking about - the lack of an exception ? That's
>intentional - it doesn't issue an exception if the record isn't locked and
>you try to unlock it.

RTFM hehehe

Use this method to unlock the current row. The current row must have been previously manually locked using
the LockCurrentRecord method or else an exception will be raised.

Roy Lambert

I've always wanted to say that to the developer of something <vbg>

Roy,

<< Use this method to unlock the current row. The current row must have been
previously manually locked using
the LockCurrentRecord method or else an exception will be raised. >>

I'll make sure that is corrected in the manual.  The behavior just changed
with the last build.

--
Tim Young
Elevate Software
www.elevatesoft.com

Terry


Is it all done yet?

Roy Lambert

Tim


>The manual locks are segreated per table cursor, so they are released when
>the table cursor is closed. They are *not* handled on a per *physical*
>table basis.

I've just been testing. Simple form with two tables lets say T1 & T2 both pointing at the same underlying table. Open both in OnCreate.

Four buttons
B1 does T1.LockCurrentRecord
B2 does T2.LockCurrentRecord
B3 does T1.Close
B4 does T2.Close

Start two copies of the app A1, A2

In A1 click B1
In A2 click B2 - error message - unable to lock - great
In A2 click B3
In A2 click B2 - still get error message - unable to lock
In A1 click B4
In A2 click B2 - it does the lock

So what is the definition of "table cursor" for future reference?

Roy Lambert

Roy,

> Is it all done yet?

I believe that I have it working correctly in my application, but need to
strip it down to something a bit more generic that others can use.    I'll
see if I can wrap this up in the next couple of days and post it to the
binaries group.

--

---------------------------------------
 Terry Swiers
 Millennium Software, LLC
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Terry


Super, but I'd suggest the extensions ng since it will be specific to elevatedb, or will it?

Roy Lambert

Roy,

<< Start two copies of the app A1, A2

In A1 click B1
In A2 click B2 - error message - unable to lock - great
In A2 click B3
In A2 click B2 - still get error message - unable to lock
In A1 click B4
In A2 click B2 - it does the lock >>

I'm not seeing this here.  Are you sure that the second-to-last step is not
B3 instead ?

<< So what is the definition of "table cursor" for future reference? >>

A table cursor is a "view" of a physical table that encapsulates the current
row pointer and position (including BOF and EOF), the current index order,
and any range or filters.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>I'm not seeing this here. Are you sure that the second-to-last step is not
>B3 instead ?

I went through this sequence about 5 times so I could report it correctly and I still got it wrong - sorry.

><< So what is the definition of "table cursor" for future reference? >>
>
>A table cursor is a "view" of a physical table that encapsulates the current
>row pointer and position (including BOF and EOF), the current index order,
>and any range or filters.

More education needed I'm afraid - how does that relate to tables and queries?

Roy Lambert

Roy,

<< More education needed I'm afraid - how does that relate to tables and
queries? >>

A TEDBTable represents a single table cursor, whereas a TEDBQuery,
TEDBScript, or TEDBStoredProc represent a single table cursor on the result
set, which is basically a temporary table in the case of an insensitive
result set, or the actual source table in the case of a sensitive result
set.

--
Tim Young
Elevate Software
www.elevatesoft.com