Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 11 total
Thread V1.09 build 1 Tedbtable.Recno seems to return 0, always
Wed, Apr 23 2008 10:30 AMPermanent Link

QuickAndDirty
Hallo,
V1.09 build 1  Tedbtable.Recno seems to return 0, always...
I don't know why but ist seems i recno always returns 0.

Is there somebody who has the same issue or is it more a problem of my code?
Wed, Apr 23 2008 10:52 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate



From EDB manual:
-----------------------------------
RecNo   
This property no longer returns a logical record number as it did in
DBISAM. It returns zero (0) at all times under ElevateDB. However, you
can still assign a value to the property in order to navigate to a
specific logical row in the dataset.
------------------------------------


--
Fernando Dias
[Team Elevate]
Wed, Apr 23 2008 11:22 AMPermanent Link

QuickAndDirty
How bad.
I realy need the Actual recno to syncronise with another TDataset descendent after
TEDBtable.Findkey.

Any Idea?
If not I have to build my own Findkey and that wouldn't be so optimized.

I thougt is something that Recno belongs to a Table.
Wed, Apr 23 2008 11:46 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< I realy need the Actual recno to syncronise with another TDataset
descendent after TEDBtable.Findkey. >>

Is the other TDataSet a TEDBTable component ?  If so, then use GotoCurrent:

http://www.elevatesoft.com/manual?action=mancompmethod&id=edb1&product=d&version=7&comp=TEDBTable&method=GotoCurrent

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Apr 23 2008 11:52 AMPermanent Link

QuickAndDirty
Hello again,
I see code in the GetRecNo Method,...will recno return some day or are you going to
replace it with result := 0 in the future?

I think, it would help me if you tell me the reason why you want TEDBtable.getrecno to
behave like a TQuery.
Wed, Apr 23 2008 12:03 PMPermanent Link

QuickAndDirty
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:


<< I realy need the Actual recno to syncronise with another TDataset
descendent after TEDBtable.Findkey. >>

Is the other TDataSet a TEDBTable component ?  If so, then use GotoCurrent:

http://www.elevatesoft.com/manual?action=mancompmethod&id=edb1&product=d&version=7&comp=TEDBTable&method=GotoCurrent

--
Tim Young
Elevate Software
www.elevatesoft.com

No it is not Another TEdbtable. I let do Tedbtable do all the work in a DLL as the source
of information for my own DS descendat. That works with some Tables (all tables I testet)
except of TedbTable.
We are doing this be able to switch between Databases by writing an DLL/BPL(both  works) only.
Wed, Apr 23 2008 12:32 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate


> I see code in the GetRecNo Method,...will recno return some day or are

I don't believe RecNo is going to return...
Calculating the relative position of a record (RecNo) is an expensive
operation, so EDB dropped RecNo in favor of better performance.
Since RecNo is the relative position of a row in the active index, each
insert/update/delete operation in a table requires the update of all
statistics, for all indexes of that table. As you can imagine, this can
cause a significant slow down, specially with big tables.

--
Fernando Dias
[Team Elevate]
Wed, Apr 23 2008 3:22 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< I see code in the GetRecNo Method >>

That code simply returns what is in the record info for the buffer, which is
always 0.

<< ...will recno return some day or are you going to replace it with result
:= 0 in the future? >>

No, the record numbers won't be returning.

<< I think, it would help me if you tell me the reason why you want
TEDBtable.getrecno to behave like a TQuery. >>

See Fernando's response - calculating a logical record number is an
expensive operation and requires a very large amount of code and overhead
for something that can be calculated by yourself, if you need it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Apr 24 2008 3:47 AMPermanent Link

QuickAndDirty
<<See Fernando's response - calculating a logical record number is an
expensive operation and requires a very large amount of code and overhead
for something that can be calculated by yourself, if you need it.>>

Yes I understand that it is hard to get this recno.
Maybe I find another Solution that works without recno...well then the Tdbgrids of Delphie
won't Scroll that nice...

Thanks for asking all that questions.
Mon, Apr 28 2008 2:27 PMPermanent Link

"Royke"
"QuickAndDirty" <aramalhao@adc-elektronik.de> wrote in message
news:B4CBDA5C-3805-49AF-9C48-BA36322EECCF@news.elevatesoft.com...
> Hallo,
> V1.09 build 1  Tedbtable.Recno seems to return 0, always...
> I don't know why but ist seems i recno always returns 0.
>
> Is there somebody who has the same issue or is it more a problem of my
> code?

This was a topic of discussion quite a while ago. When moving from some BDE
application it caused us a huge amount of extra work. And I still don't like
it that the scrollbars of grids stopped working ...

Is it not technically possible to re-introduce a working RecNo as a somehow
switchable option?

RJ

Page 1 of 2Next Page »
Jump to Page:  1 2
Image