datagrid column order

[bsouthuk]

Hi

Is it possible to change the order of the columns in a datagrid with a couple of lines of code or would it be a case of a loop formula and then setting the dgText of datagrid to ****

Cheers

Daniel

[Klaus]

Hi Daniel,

sorry, no idea, but you could try to -> set the dgprops["columns"] of grp "your datagrid here" to XXX
to the new ordered list of column names and see what happens


Best

Klaus

[bsouthuk]

Thank you Klaus, I have tried

Code: Select all

 set the dgprops["columns"] of grp "Usage" to "TARIFF", "NETWORK", "MOBILE"

But this doesn't seem all the text just goes into the one column. I am having trouble separating them!

Any ideas?

[bsouthuk]

ITS OK I FORGET THE.. replace comma with return in *****

[bsouthuk]

OK so the issue I now have here is that the data that was stored in the Datagrid all disappears accept the first column...

Why on earth does this happen?

[Klaus]

Obviously this is not the way to go...

But you tried this with a copy of your data, right?

[bsouthuk]

Hi Klaus

I did yes, my datagrid was full of data, I used the following code:

Code: Select all

   put "CALL DATE, TARIFF, NETWORK" into tColumnTitles
   replace comma with return in tColumnTitles
   set the dgprops["columns"] of grp "Usage" to tColumnTitles

The column names changed correctly, but the only data within the Datagrid that remained for the first columns data.

[Klaus]

As I said, this obviously does not work as exspected.

But make sure to remove unwanted spaces:
...
## put "CALL DATE, TARIFF, NETWORK" into tColumnTitles
put "CALL DATE,TARIFF,NETWORK" into tColumnTitles
...
See the difference? They might go into the new column names!
Not that this helps you with your problem.

[bsouthuk]

SORTED! Works perfectly, thank you for you help Klaus its very much appreciated.

[Klaus]

So it DOES in fact work as exspected with the correct column names?
Cool!

[quailcreek]

I got caught up in something similar awhile ago. Just for reference, here's another way of stating the same thing.

Code: Select all

put ("CALL DATE", "TARIFF", "NETWORK") into tColumnTitle