Re: Inserting a new PK into an existing table



David Newman wrote:

[...]
Then use update statements to populate the column. This is left as
an exercise to the reader.
[...]

I probably should have been more precise. I already know how to create
the new column and how to make it a primary key after it has been
filled, the only thing I have not found yet is how to populate it with
unique numbers.

Anyway, thanks for the reply.

Jens

.



Relevant Pages

  • Using statements swallowing exceptions
    ... If the command I use to populate the reader throws an exception, then that exception gets "swallowed" and never populates back up the callstack. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Act Blob table
    ... > I can actually open a connection to the table, but when I try to populate ... > the reader, I'm getting an Odbc exception and a system error. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: populate listbox
    ... use the IO class and a text reader, at each pass where there's a delimmiter ... "Mike" wrote in message ... > I create a list of files within a text file and I want to populate the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: "populate a list" [was: Re: To populate=to furnish with inhabitants]
    ... >momentarily mislead the reader. ... >reader first think of human inhabitants, ... >or she begins to understand the intended meaning. ... "Populate", with the meaning under discussion, cannot always be ...
    (alt.usage.english)
  • Update a table using a recordset
    ... I have a that I need to add a field to and populate. ... Sample_ID Reader Age ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)