Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Chicken or the Egg - Primary Key Creation


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: May 27, 2017 4:59 AM Last Post By: John MacDonald
John MacDonald

Posts: 179
Registered: 3/22/98
Chicken or the Egg - Primary Key Creation  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 20, 2017 5:18 AM
Hello everyone:

I thought I had this issue before, I hope I did not ask about this before.

I have migrated an entire database.
In some cases the primary key cannot be created because there are null values in the original field.

I'm trying to create values in the primary key. I can pick one record : based on other information.
Since the primary key does not exist yet, firedac just sits there.

There must be a way to correct this database?

--
JMAC out
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Chicken or the Egg - Primary Key Creation  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 27, 2017 4:59 AM   in response to: John MacDonald in response to: John MacDonald
There were not many records that were null.
I "manually" set the value to a digit and counted my way through.

Then once I have the primary keys set, I iterated through them and created the keys the way I wanted them.

John MacDonald wrote:
Hello everyone:

I thought I had this issue before, I hope I did not ask about this before.

I have migrated an entire database.
In some cases the primary key cannot be created because there are null values in the original field.

I'm trying to create values in the primary key. I can pick one record : based on other information.
Since the primary key does not exist yet, firedac just sits there.

There must be a way to correct this database?

--
JMAC out

--
JMAC out
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02