While you are on the subject... I am a big fan of:
$tSQL:="SELECT * FROM "+$tTableName+" INTO : "+$tLBox Because it creates dynamic Listbox columns automatically. 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:) -- Jim Dorrance [email protected] [email protected] www.4d.dorrance.eu PS: If you know of anyone that needs an experienced 4D programmer to add energy and experience to their team, please let me know. I have experience in many areas. Reasonable rates. Remote or Paris only. ********************************************************************** 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] **********************************************************************
