Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
RecordID in Combined primary Index |
Mon, Jan 17 2011 9:48 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent 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] |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |