- Local time
- Today, 11:29
- Joined
- Feb 19, 2002
- Messages
- 43,305
I hope you didn't get hurt by flying debris
Giving you this particular answer is like putting the bullet in the gun for you. But, since it is something you will run into in the future if you forget to remove the "helpful" 0 default for numeric fields, I thought you needed to know. Now that I've loaded the gun for you, please do not fire it. You should NOT fix the problem by simply removing the 0 default from the FK, you should fix the problem by fixing the schema. That is what is wrong.
Pat, you broke the bank.
thank you!
Giving you this particular answer is like putting the bullet in the gun for you. But, since it is something you will run into in the future if you forget to remove the "helpful" 0 default for numeric fields, I thought you needed to know. Now that I've loaded the gun for you, please do not fire it. You should NOT fix the problem by simply removing the 0 default from the FK, you should fix the problem by fixing the schema. That is what is wrong.