I accidentally discovered something yesterday using SELECT ... INTO LISTBOX. I had 2 listboxes filled with SELECT ... INTO LISTBOX and 4D gave both identical names to columns and headers (sql_column1..sql_columnN, sql_header1..sql_headerN), resulting in duplicated object names in the same form. To turn around this, I did this (shortly):
for(i;1;number of columns) c_p := pointer on column i h_p := pointer on header i listbox insert column (*;lbName;number of columns+i;newColumnName;c_p->;newHeaderName;h_p->) listbox delete column (*;lbName;1) end for I've always thought a listbox obtained with INTO LISTBOX could not have more columns that the number of fields in the SELECT, but the code above gave me the idea to use this "column cloning" to add my own columns: clone, put the data you want, use… until now it seems to be working fine. As this is new to me, i'm wondering if it's reliable: some experience? -- Arnaud de Montard ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
