topic Problem in DATABASE updation ? in Application Development and Automation Discussions

Problem in DATABASE updation ?

Former Member — Fri, 24 Apr 2009 14:42:59 GMT

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

Re: Problem in DATABASE updation ?

Pawan_Kesari — Fri, 24 Apr 2009 14:50:18 GMT

Insert new records with new value in F1 and delete old records..

Re: Problem in DATABASE updation ?

Former Member — Fri, 24 Apr 2009 14:51:08 GMT

dear dharma,

i'm sorry, but as far as i'm concerned. you have to do an insert with filled f1 and an deleteion of the entry where the f1 field is empty.

modify/update won't work, because obviously there is no entry to update. What you want to do, is creating an new entry an delete the old one. so you have to choose these commands.

robert

Re: Problem in DATABASE updation ?

Former Member — Fri, 24 Apr 2009 14:54:36 GMT

Hi Dharama,

read the table first with old entries ..

then update primary with new field by varying the F2,f3 and other fields.

Regards,

Prabhudas