我一直在Vb上工作,但是我切换到了PowerBuilder 12.5 Classic,我发现了自己的方法。我需要知道等效的PowerBuilder脚本;
I have been working on Vb but i switched to PowerBuilder 12.5 Classic, I am finding my way around. I need to know the equivalent PowerBuilder script;
While dr.Read ComboBox1.Items.Add(dr("itemname")) end while
推荐答案
string ls_sql, ls_syntax, ls_errors ls_sql = "select name from users" ls_syntax = sqlca.SyntaxFromSql(ls_sql, "", ls_errors) if len(ls_errors) > 0 then return datastore ds ds = create datastore ds.create(ls_syntax, ls_errors) if len(ls_errors) = 0 then ds.SetTransObject(sqlca) ds.Retrieve() long ll_row,ll_rows string ls_val ll_rows = ds.RowCount() for ll_row = 1 to ll_rows ls_val = ds.GetItemString(ll_row, "name") Combobox1.AddItem(ls_val) next end if destroy ds
编辑 :正如Terry在回答中所说,Datawindow和DataStore是Powerbuilder的关键控件。将DataStore视为VB记录集,而DW是一种可视记录集(可以以表格,网格等形式显示数据)。
Edit some comments: as Terry says in its answer, the Datawindow and the DataStore are the key controls of Powerbuilder. Consider the DataStore as a VB recordset and the DW is a kind of visual recordset (that can show the data in the way of a form, a grid, ...).
我通过使用DS来检索数据并轻松对其进行迭代(比游标更容易操作)来回答了您的问题,我翻译了组合框。但是正如Terry所说,您应该研究如何使用功能更强大,更先进的DropDownDataWindow。
I answered you question by using a DS to retrieve the data and to easily iterate on it (it is easier to manipulate than a cursor) and I translated the filling of the combobox. But as Terry said, you should study how to use a DropDownDataWindow that is way more powerful and evolutive.
更多推荐
从PowerBuilder Classic 12.5中的SQL表填充dropdownlistbox项
发布评论