Can you append these datatypes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am appending 18 fields from 4 tables and the select query works fine. i
also have 3 expressions built to convert Y/N datatypes to Text types. However
I did find that one of my fields in a table (source) is going to the target
table that has a "Number" datatype. Do you think this could be the problem
why I am getting a Key Violation error. I have looked at everything possible
for two days and cant find anything! Please help!
 
Putting text into a number field is certainly like trying to pound a square
peg into a smaller round hole. If you don't convert it to text, the 0 and -1
from a Yes/No field should fit.

However I doubt if that has anything to do with a key violation. It probably
hasn't gotten that far yet. Usually a key violation means that you are trying
to put a duplicate value into a primary key or unique index field. It could
also mean that you have a relationship set up with Referiential Integrity on
and are attempting to append to a child table without matching data in the
parent table.
 
Back
Top