![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 8 of 8 total |
![]() |
Fri, Feb 5 2010 7:00 AM | Permanent Link |
Peter | Tim
I am researching the most appropriate method for my generated fields, and I can find scant details. You said in one post from '08 that the user should "(see my message about BY DEFAULT vs. ALWAYS)." How do I search the newsgroups for that message? If I paste the quoted text into the search edit box, it looks for (or appears to look for) default*, and always*, but not the quoted phrase. Regards & TIA Peter |
Mon, Feb 8 2010 10:08 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Peter,
<< I am researching the most appropriate method for my generated fields, and I can find scant details. You said in one post from '08 that the user should "(see my message about BY DEFAULT vs. ALWAYS)." How do I search the newsgroups for that message? If I paste the quoted text into the search edit box, it looks for (or appears to look for) default*, and always*, but not the quoted phrase. >> Currently the search does not allow for quoted phrase searching, so for now you just have to use the keywords. Are you talking about generated expression columns, or generated identity columns ? -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Feb 8 2010 6:32 PM | Permanent Link |
Peter | Tim
Generated identity columns, and I found a thread where I asked the question once before, and it appeared that BY DEFAULT was necessary when I am migrating from DBISAM. This is mainly because the table may have many non-contiguous ID records, where a record has been archived or similarly removed, and BY DEFAULT retains the existing values (which is critical) whereas ALWAYS does not. I use the following statements to change the field to an IDENTITY field... GETMAX = 'SELECT MAX(%s) MaxID FROM "%s";'; ALTERCOL = 'ALTER TABLE "%s" ALTER COLUMN %s AS INTEGER GENERATED BY DEFAULT'+ ' AS IDENTITY (START WITH 0, INCREMENT BY 1);'; RESETNUM = 'ALTER TABLE "%s" ALTER COLUMN %s RESTART WITH %d;'; and run through a list of tables, running each statement in turn. But I would still like a link to the discussion you had on the matter, as I can't the thread. Regards Peter |
Mon, Feb 8 2010 6:37 PM | Permanent Link |
Peter | Tim
I should have added that I have no Autoinc columns in the DBISAM database; all the columns that I am changing are integers, and are the primary key field. I obtained the next ID value from a single row, single column table for each. Regards Peter |
Tue, Feb 9 2010 11:48 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Peter,
<< Generated identity columns, and I found a thread where I asked the question once before, and it appeared that BY DEFAULT was necessary when I am migrating from DBISAM. This is mainly because the table may have many non-contiguous ID records, where a record has been archived or similarly removed, and BY DEFAULT retains the existing values (which is critical) whereas ALWAYS does not. >> Correct. << But I would still like a link to the discussion you had on the matter, as I can't the thread. >> Unfortunately I can't find the discussion that you're referring to. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 9 2010 8:19 PM | Permanent Link |
Peter | Tim
<<Unfortunately I can't find the discussion that you're referring to.>> Hee hee, that was my point about searching. In the thread http://www.elevatesoft.com/newsgrp? action=searchopenmsg&group=17&msg=2242&keywords=DEFAULT*%20vs*%20ALWAYS*#msg2242 you suggested we "(see my message about BY DEFAULT vs. ALWAYS).", but that is the problem - I can't find it. ![]() Have you a better appreciation of how to winkle that thread out? Regards Peter |
Wed, Feb 10 2010 4:40 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Peter
The best way is to use TMaN as an offline reader and have the whole shebang local. The only message I can find that looks like its relevant is ID: AE4A9B31-19DD-4320-ABB6-568E840954F0@news.elevatesoft.com Sub ject: Re: Managing ID fields / Identities Date 19/09/2008 in this newsgroup There is nothing that matches the phrase quoted either in subject or body. Roy Lambert [Team Elevate] |
Wed, Feb 10 2010 11:04 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Peter,
<< Hee hee, that was my point about searching. >> The new web site design has a better search implementation for the forums, and we'll also be updating all old links in messages so that they point to the new URLs. The new web site should be ready by mid-March. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |