Hi ,
I have a custom table with fields say , F2 , F3 , F4 , F5 where F2 , F3 are key fields . Now added one more key field , F1 , in the begining ( Now the primary key is F1 , F2 , F3 ) .
Since this table is having data for all the fields before F1 additon , Now I want to fill the F1 where ever it is blank with a default one programmatically .
But DATABASE "UPDATE" statements is not working as it is searching for similar key values in DATABASE table , Whcih is not the case because F1 is blank .
INSERT and MODIFY are actually inserting another row , instead of updating the same row.
So , Please advise me how to advise on this .
Thanks in advance ,
Dharma