flip one grid or combine few grids or else...

[pondi]

Hello all,

I'm developping a site using a SQLS DB, i'd like to catch my data in one grid. But i've to modify the results of my queries. So I'd like to know if it's possible to flip a grid, or to combine 2 grids in one.

The trouble is I can catch all my data in one row but I want to split it in few rows... Maybe textarea is a solution, but for the moment i can't get with it..

Thanks!!

 

[crystalized]

I am not sure I understand the problem could you provide more detail, perhaps an example of what you mean. Crystal
crystalized_s@yahoo.com

--------------------------------------------------

Experience is one thing you can't get for nothing.

-Oscar Wilde

 

[pondi]

My problem is ok i just had the grid:
Elt1 S0 45
Elt1 S1 54
Elt2 S0 87
Elt2 S1 51
And with a new query i can now have the following grid:
SO S1
Elt1 45 54
Elt2 87 51
This step is done, but i've got a new trouble now

I'd like to sort this grid against S1 or S0, i know I could make a query with ORDER BY for S0 and another one for S1.
But i have 20 criterias and do not want to make 20 stored procedures.
So i'd like to know if i could sort my grid from Interdev. Maybe I should use a VB array between recordset and grid, sort it, and send sorted data to my grid...
What do yu think??

 

[MerlinB]

I have responded to your other question about sorting. I hope it is what you wanted!

It is also possible to place one grid inside another! Assuming that you have Interdev Service Pack 3 or higher, then you can plonk one grid in the cell of an outer grid.
(See thread117-87230, which steps near the subject matter)
However, you will have fun pumping data into the inner grid!

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)