Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread RecordID in Combined primary Index
Mon, Jan 17 2011 9:48 AMPermanent Link

Petter Topp

Hi.

I have a table with 300 records.
I have replaced the "RecordID" field with a new "RecNo" field in the Index.
"RecNo" is AutoInc.
It seems that the new RecNo field automatically gets its values from the
RecordID since nothing has changed with the sorting of the data.

When opening and scrolling the table things are now veeery slow as oposed to
using RecordID.
Is this to be expected?
Mon, Jan 17 2011 9:53 AMPermanent Link

Petter Topp

This might be useful......

Scrolling and opening the table is performed with dbsys, not any
application.

Petter Topp
Dbisam 4

"Petter Topp"  skrev i nyhetsmeldingen:
C7B4AA21-6B4D-471C-A2F7-CCB9EF1938AF@news.elevatesoft.com ...

Hi.

I have a table with 300 records.
I have replaced the "RecordID" field with a new "RecNo" field in the Index.
"RecNo" is AutoInc.
It seems that the new RecNo field automatically gets its values from the
RecordID since nothing has changed with the sorting of the data.

When opening and scrolling the table things are now veeery slow as oposed to
using RecordID.
Is this to be expected?
Mon, Jan 17 2011 10:12 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Petter

Firstly I would expect an autoinc to be the same as RecordID at least to start with - they may diverge later I'm not sure.


Secondly I think you may have a clash with a system name looking in my old (ie 4.25) documentation RecNo is inherited from TDataSet so strange things may be going on. Try changing the name and see if that does any good.

Roy Lambert [Team Elevate]
Tue, Jan 18 2011 3:28 AMPermanent Link

Petter Topp

Hi Roy.

That must have been the problem.
Changed the name to RecNr and now the table hadles as expected...

Petter

"Roy Lambert"  skrev i nyhetsmeldingen:
9A5C5237-4BF7-43F8-AE41-7CF196EE3743@news.elevatesoft.com ...

Petter

Firstly I would expect an autoinc to be the same as RecordID at least to
start with - they may diverge later I'm not sure.


Secondly I think you may have a clash with a system name looking in my old
(ie 4.25) documentation RecNo is inherited from TDataSet so strange things
may be going on. Try changing the name and see if that does any good.

Roy Lambert [Team Elevate]
Image