Adding columns to table frame

[hcts]

Hi again,

I messed with this maybe three/five years ago. New project and want to do the same thing. I have a table frame for estimates. It shows multiple columns, IE: Labor, Material, Subcontract, ect.) Some bids call for all and some don't. I am looking for a way to delete the unnecessary columns from the table frame. Know there is a way, any ideas or examples out there?

Thanks in advance

James D. Howard

 

[Kliot]

James,

I assume you are referring to a table frame in a form, to delete columns simply click on the grayed out part of the column (the part of the column below the header and field). Sometimes it takes a few clicks to step down to the column, then column will highlight when you have it selected and to delete it simply hit the delete key, to insert a new column press the insert key instead. You can also use the right mouse click once the column is selected.

Perrin

 

[hcts]

Sorry for the incomplete post Perrin. I know how to add and remove columns in design mode. I want my users to be able to do this interactivly. So they can choose from a form what columns they want to show on the form, in runtime mode. I'm visioning a control form that has the name of the columns and a check box next to them for visible.

 

[Kliot]

Ahhh, I thought that was an overly simple question. What you are trying to do is a tad more difficult, I have never tried doing it but I'm sure it's possible. You can easily add, remove, resize columns at runtime, do a search for "columns" in objectpal help.

eg:

tblframe.insertColumn = 2,
tblframe.deleteColumn = 2

 

[Kliot]

I should have added when you insert a column you will need to asign a field name to it.

#field.tableName = ":alias:tablename"
#field.fieldName = "fieldName"

Good Luck and let us know how it works out.