研究目标:快速开发数据库软件,速度要快。
动态创建数据窗口的方法
1.使用create函数,动态生成数据窗口,可以利于这个功能从语法模板中生成数据窗口,方便程序的开发。
2.使用SyntaxFromSQL函数,可以动态生成默认的数据窗口,这时可以取得每列的数据,以便重新按自己的格式进行组织窗口格式
Powerbuilder 数据窗口中的column属性
Properties for Column controls in DataWindow objects
Property for a Column M S Description
Accelerator x (exp) The accelerator key for the column.
Alignment x (exp) The alignment of the column's text.
Attributes A list of the properties of the column.
Background.property x x (exp) Background settings for the column.
Band The band containing the column.
BitmapName Whether the column's contents names a picture that will be displayed instead of the text.
Border x x (exp) The type of border around the column.
CheckBox.property x Settings for CheckBox edit style.
Color x x (exp) The text color.
ColType The column's data type.
Criteria.property x Settings for column in Prompt for Criteria dialog box.
dbName x The name of the database column.
dddw.property x Settings for DropDownDataWindow edit style.
ddlb.property x Settings for DropDownListBox edit style.
Edit.property x x Settings for Edit edit style.
EditMask.property x Settings for EditMask edit style.
Font.property x x (exp) Font settings for the column text.
Format x (exp) The column's display format.
Height x (exp) The height of the column.
Height.AutoSize x Whether column height is adjusted to fit the data.
HideSnaked x Whether the control appears once per page when printing newspaper columns.
HTML.property x (exp) Settings for creating hyperlinks for column data.
Identity x Whether the DBMS sets the column's value.
ID The number of the column.
Initial x The initial value in the column for a new row.
Key x Whether column is part of the table's primary key.
LineRemove x Whether to remove line of text when the column is not visible.
Moveable x Whether the user can move the column.
Multiline x Whether the column can be multiline.
Name The name of the column.
Pointer x (exp) The pointer's image when it is over column.
Protect x (exp) Whether column is protected from changes.
RadioButtons.property x Settings for RadioButton edit style.
Resizeable x Whether the user can resize the column.
SlideLeft x (exp) Whether column moves left to fill in space.
SlideUp x (exp) How the column moves up to fill in space.
TabSequence x The position of the column in the tab order.
Tag x (exp) The tag text for the column.
Type The control's type, which is Column.
Update x Whether the column is updatable.
Validation x (exp) The validation expression for the column.
ValidationMsg x (exp) The message displayed when validation fails.
Values (for columns) x The values in the column's code table.
Visible x (exp) Whether the column control is visible.
Width x (exp) The width of the column.
Width.Autosize x Whether width adjusts to the data.
X x (exp) The x coordinate of the column.
Y x (exp) The y coordinate of the column.
要实现的理想功能:
1、指定字段的中文,将中文放在SQLSERVER的备注属性中,一键生成SQL表格
2.根据SQL查询结果,快速生成数据窗口格式。