从PowerBuilder Classic 12.5中的SQL表填充dropdownlistbox项 [英] Populate dropdownlistbox items from SQL table in PowerBuilder Classic 12.5

问题描述

我一直在Vb.net上工作，但是我切换到了PowerBuilder 12.5 Classic，我发现了自己的方法。我需要知道等效的PowerBuilder脚本；

I have been working on Vb.net but i switched to PowerBuilder 12.5 Classic, I am finding my way around. I need to know the equivalent PowerBuilder script;

1. 清除控件 textbox1.clear（）


2. 聚焦 textbox1.focus（）


3. 将SQL数据库项目插入到下拉列表框中

    While dr.Read
       ComboBox1.Items.Add(dr("itemname"))
    end while

推荐答案

1. textbox1.Reset（）


2. textbox1.SetFocus（）


3. 示例（未经测试，但显示出了想法）：

    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项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！