> Le 22 janv. 2018 à 18:48, Jim Dorrance via 4D_Tech <[email protected] > <mailto:[email protected]>> a écrit : > > [...]Is there a clever way to select nothing into a Listbox so that an > empty listbox with all the columns defined? I could then fill the > listbox "manually". What I do now is > > $tSQL:="SELECT * FROM "+$tTableName+" WHERE "+$tFieldName+" = "+ > MYNon-ExistantValue+" INTO : "+$tLBox > > Not very elegant:)
Hi Jim, see here: <http://forums.4d.com/Post/FR/19537969/1/19537970#19537970 <http://forums.4d.com/Post/FR/19537969/1/19537970#19537970>> As far I as understand, when there is no data found, all columns are here but all of the text type. I have to turn around (quite heavily). Something's missing in "into listbox" :-( To fill "manually", see here, the last paragraph: <http://forums.4d.com/Post/FR/19409974/1/19413742#19413742 <http://forums.4d.com/Post/FR/19409974/1/19413742#19413742>> Briefly, after SQL into listbox, duplicate one column, do what you want with that new column. -- 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] **********************************************************************
