Re Arranging SQL columns
Posted on 2004-04-21
I have a window with selection criteria dw and resultset dw. When user enters some values in selection criteria dw fields, then i am forming the where clause in retrieve button clicked event, and setting the same to the resultset dw and then retreiving the result set.
Now the user requirement is...
If he enters City and Birthdate fileds in selection criteria then, these columns should come first in the resultset and rest should follows . I.e City BirthDate Name Phone State ....
If he enters state and phone then the resultset should be State Phone City Birthdate Name Etc...
I have all these columns in the resultset, i need to rearrange these columns as per selection criteria fields.
Thanks in Advance