Hi,
i am doing a lookup to insert new records when the lookup has failed.
this works perfectly normally. however when my recordset has a name-column of type string with width 5 and my lookup-table has a name-column of char(20) the lookup will always fail and henc always inserting new records although the name "foo" should match.
is there a workaround for this, or do the compare-columns always have to be of the same type/length ?
I would say it is always a good practice to have matching datatypes. I was not aware that lookup transform treated this situation as error; but it does not surprise me.
You can add a Data conversion before the lookup to assure matching data types
No comments:
Post a Comment