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

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

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

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

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

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

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]

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