I solved it by removing the unique index from the field and then just creating a new field with the same value (obviously different column name) and making it unique so my REPLACE INTO will still do what I want. The code won't help and there were no errors. Just never fell into the dtmi-in. Removing the unique index and it all worked. Just seemed strange. Thanks for responding. Allen Chris Withers wrote:
Allen wrote:
BTW, the value is like SP12345 or KG34321 so its not that it is an integer and I was assuming it a string...or something like that. I thought a string was a string was a string...
Can someone enlighten me on this? Seems odd to me..
Show us you code, and full errors (type, value, traceback) and we may be able to help...
Chris