Skip to Content
0
Former Member
Apr 24, 2009 at 02:42 PM

Problem in DATABASE updation ?

28 Views

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