Skip to Content
0
Apr 21, 2008 at 09:20 AM

update......... only few fields.

51 Views

hi!

say i have 150 fields............... 100 fields are modiafable..........

i want to change 10 fields among these 100.

what should i use : modify or update??

i dont want to enter remaining 90 fields.....they remain blank in the display screen.....

i only enter these 10 random modifying fields..........

I used - UPDATE <db TABLE> FROM <TABLE>.

Now... i need to enter all fields.......... if i give all fields "optional" in Export parameter then only non optional fields ned to be given. but all other optional fields which were not given input become blank in the datadict.

what should i do to change only few fields and the fields which i do not enter remain with the old values.???

thank u in advance.

regards.