M
MSP03 Field Data changes ?
have a quick question regarding one of the field data.
The thing is right now we need to populate the following data i.e., from
“msp_projects.proj_prop_title†into “msp_text_fields.text_value†with the
following condition.
***************************
eg :-
UPDATE msp_text_fields
SET msp_text_fields.text_value =
(SELECT msp_projects.proj_prop_title
FROM msp_projects,msp_text_fields
WHERE msp_projects.proj_id = msp_text_fields.proj_id
AND msp_text_fields.text_field_id = '188744729')
***************************
This we need to do because of some of the requirements from our users.
Actually at present this is one time update to “msp_text_fields.text_valueâ€
and we need to automate this process of updating in future with the same
condition as shown above.
· I want to know is their any feature in the application so that we
can customize to populate the above changes to data.
· If it’s not their how to achieve this?
The thing is right now we need to populate the following data i.e., from
“msp_projects.proj_prop_title†into “msp_text_fields.text_value†with the
following condition.
***************************
eg :-
UPDATE msp_text_fields
SET msp_text_fields.text_value =
(SELECT msp_projects.proj_prop_title
FROM msp_projects,msp_text_fields
WHERE msp_projects.proj_id = msp_text_fields.proj_id
AND msp_text_fields.text_field_id = '188744729')
***************************
This we need to do because of some of the requirements from our users.
Actually at present this is one time update to “msp_text_fields.text_valueâ€
and we need to automate this process of updating in future with the same
condition as shown above.
· I want to know is their any feature in the application so that we
can customize to populate the above changes to data.
· If it’s not their how to achieve this?