First of all, I’m so sorry about my english. I hope somebody could understand what I am talking about.
Here is my question : how can do a field-sorting in the word instead of DB?
for example:
I have a table named test_sort in database, all of its columns are :
id varchar(32) pk,
username varchar(32),
age int(4),
birthday timestamp,
company_name varchar(32).
I want to display all records of table test_sort in Microsoft Word and sort them order by increasing.
We could use sql script:
select username,
age,
birthday,
company_name
from test_sort
order by username,
age,
birthday,
company_name asc
But some other day, boss need me to display these records order by username increasing, age increasing and birthday decreasing, company_name decreasing.
So I have to change these sql script like:
select username,
age,
birthday,
company_name
from test_sort
order by username asc,
age asc,
birthday desc,
company_name desc
And another day, boss has new requirement, and I have to change these sql script agian and agian.
So I think whether I could do the sort in Microsoft Word indtead of database, just like add or edit a mail merge field?