I have a Dataset:acctfield

Caption Column: acct

My question is how do I populate two columns in the Caption Column if possible?

 

 

Duke,
Although it is not possible to display more than one field, there is a simple workaround if the dataset was created by a SQL query:
in the SELECT statement you can create a new combined field to be used as caption in the dialog selection.
Sample below where I create a "caption" field from two DB fields in the SELECT


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="foldr">c:\temp</AMVARIABLE> <AMVARIABLE NAME="MyCSV">4;C;0.40 5;D;0.50 2;X;1.25 </AMVARIABLE> <AMFILEWRITE FILE="%foldr%\MyCSV.csv" APPEND="NO">%MyCSV%</AMFILEWRITE> <AMVARIABLE NAME="MySchema">[MyCSV.csv] ColNameHeader=False Format=Delimited(;)</AMVARIABLE> <AMFILEWRITE FILE="%foldr%\schema.ini" APPEND="NO">%MySchema%</AMFILEWRITE> <AMSQLQUERY CONNECTIONSTRING="AM2a0nLdIkXqrJSSd10gxeusgZJ9HSPF7+ySUnWdJUXs7JdSc10yBeWsl5JzXTIF5Oyd0n8dKIXnrIVSY10yBfssgBJ/XSHF6iyWkmZdLUXs7JOSct0hRe5sgZJnHSAF7OyV0nddJQX+bIASfx0nheosl5J13SCF7myX0mZdLYXrrJUScl0gxeusk9J0HSDF6+yBkmbdJIXubJDSc103ReUsn9J63TbF4WyXknKdN0XmrJ2Se102xeYsl5J1XSPF7GyUknNdIMXuLIZSYJ0the5sklJynSPF6+yT0mZdLUXubJYScx0lBe1sk9JwHTGF5WyVUnfdIkX4bJ9Sdh0ihevsl5JuXTmF9ywaME" RESULTDATASET="DS">Select *, (f1&' '&f2) as caption from MyCSV.csv</AMSQLQUERY> <AMVARIABLE NAME="res"></AMVARIABLE> <AMSHOWDIALOG ACTIVITY="select" RESULTVARIABLE="res" LISTTYPE="list" DATASET="DS" COLUMN="caption" COLUMNVALUE="F1" WINDOWTITLE="Please select an item" />

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4