Hi,

I have created a module using flexgrid. It's column names are:
Sno Name Address

After doing this, I have programmed every part using this as standard columns. Now, i have got into a trouble of adding an extra column in the middle of Name and Address.

Eg: msflexgrid.textmatrix(i,0),msflexgrid.textmatrix(i ,1),msflexgrid.textmatrix(i,2)

Is there any possibility to avoid such circumstances afterwards. What is the correct method of adding data in grid and manipulating using that.


A.D.Ramkumar

A.D.Ramkumar

__________________
Ramkumar A D

Dear Ramkumar,

The following may not be a solution to your problem. But When I had a similar situation, I did it in this way.

I created a public subroutine in a module (subFillGrid). To this routine, I pass the name of a flexgrid, a query, an array of column headings, an array of corresponding field names, database connection string. The subroutine will run the query and fill the grid in the order of columns I gave in the array. If a new column is to be inserted, I need only change the query and column array lists.

You may try this.

There are other class based solutions for this. You can create a class to handle all these types of reporting requirements. But, I am not clear about this. May be somebody else can give a smarter solution based on classes.

Never hard code numbers is you code, use constants instead:

private const cColSno = 0
private const cColName = 1
private const cColAddress = 2

And use them like

.textmatrix(i,cColName) = "Marco"

If another column needs to be inserted, just modify the list of constants, and the code will remain unchanged.

Marco