Hi all
I have a column type text, in beforeupdate event it queries the table whether that ID already exist or not, if it does, it prompts and then move to the record else it allows a new entry. Column is not a primary or foreign key it's just a unique column.
Sometimes we get spaces in this column when we copy paste it from other sources, I am trying to remove them through a function, which I call afterupdate event, function is tested in other places, but it doesn't work in this particular column and gives runtime error, because of before update code mentioned above. Any help will be much appreciated.
Regards
Asad
I have a column type text, in beforeupdate event it queries the table whether that ID already exist or not, if it does, it prompts and then move to the record else it allows a new entry. Column is not a primary or foreign key it's just a unique column.
Sometimes we get spaces in this column when we copy paste it from other sources, I am trying to remove them through a function, which I call afterupdate event, function is tested in other places, but it doesn't work in this particular column and gives runtime error, because of before update code mentioned above. Any help will be much appreciated.
Regards
Asad