hey guys
i have a large form and an export grid with it. Most of the table fields have spaces. It works all fine but now a customer asked to use xml export and spaces do not work for xml.
i realize that there is no mapping between database field names and SC fields. It is a serious problem. If you rename a field in the database you loose the form field connected to it and have to add the new renamed fields to your form again. If the form fields had an editable setting like the source field name i could solve my problem.
how about this in your sql?
//current
select
apple,
bag,
cat
from
tbl_box
//new
select
new_apple as apple,
new_bag as bag,
new_cat as cat
from
tbl_box