Re: PFCSIG Choose the columns before retrieve...

[Daniel Coppersmith]

Title: Choose the columns before retrieve...

You can use the datawindow services to get the columns (of_getObjects I believe).  You can populate this in a list for them to choose from.  Then you have two options...   You can either set the visible property of the column ( and header text ) to 0 for columns they don't want to see.  This is the easiest approach.   The other approach is to modify the SQL of the datawindow prior to retrieval.  For this you'll need to do describes to get the database column name (.dbname) and alter the SQL and also change the presentation of the datawindow.  This is a lot more work but it reduces the amount of data needed to be retrieved from the database and sent over the network.   D ----- Original Message ----- From: Vachon, Francois To: PB PFC Distribution List (E-mail) Sent: Friday, February 11, 2000 3:56 PM Subject: PFCSIG Choose the columns before retrieve... Hi, Before to retrieve a datawindow with many columns, can I ask to the user to choose which columns he want in the report, and hide the others columns. Example : My dw contain all these columns : id      name        phonefax 1       Franc     4564        1321 1       Jack      3212        1321 And the user want to see only the name and the phone. Can I hide the "id" and "fax" columns to have : name    phone Franc   4564 Jack    3212 Thanks for answer.... Fran�ois Vachon Programmeur / Computer programmer ____________________ Garaga Inc. (  (418) 227-2828 8  [EMAIL PROTECTED]