hi
I had a little test that gets one row from the table then adds that record back to the table, had not thought to check what value was in the table its null and thats was why it was failing Doa!
thanks for that
Stuart