Hi All, I am getting a datatype mismatch erro when I am connecting and creating a fk from a pk from another table.Each and every confirguation is same for both the columns except the following: PK column is default none with auto increment FK column is default null Can you please guide me on what mismatch I am missing as this is a usual case and easily implementable.

Known Participant

Question

Foreign Key Implementation Error Because of DataType Mismatch

Forum|Forum|3 years ago
June 21, 2023
4 replies
0 views

Hi All, I am getting a datatype mismatch erro when I am connecting and creating a fk from a pk from another table.
Each and every confirguation is same for both the columns except the following:

PK column is default none with auto increment
FK column is default null

Can you please guide me on what mismatch I am missing as this is a usual case and easily implementable.

stefanhelzle0001

Brainy

Did you try to find an answer outside of Appian as this is not an Appian issue?

S

sanchitg0002

Please check that you haven't given same foreign key name to multiple relations, if yes then make it unique. Also check that the data types are same in both tables.

saifalik8679Author

Known Participant

You got the right answer sanchit. Thanks for the directions.

S

sanchitg0002

Please consider marking the answer as correct so that anyone else having the same issue in future can find this working solution.

Sign up

Login with SSO

Login to the community

Login with SSO