Insert and Update

[Anonymous]

So im using insert and update and I have a file that is presenting some problems. the hash im using does not seem to be working and is staying identical even though I am changing cell values. I cant figure out whats causing this except for that it doesn't like all zero value but it is working on another table that had all zero values.

[sunny_talwar]

Would you be able to share a sample where we can see the issue? One thing to check would be to look out for nulls may be... but other than that, I would have assumed the hash to have changed the values

[Anonymous]

Would the original values all being zero make a difference ?

[sunny_talwar]

I would think not, but not 100% sure

[Anonymous]

I tried rewriting the whole thing and it didn't work. Unfortunately I cant share a sample.

[sunny_talwar]

Okay

[Anonymous]

I finally had to add in rowno() into the hash to get it to work. The rowno() is not in the corresponding hash to update it, not perfect but workable