powerbuilder快速开发研究-数据表，数据窗口快速生成的方法

研究目标：快速开发数据库软件，速度要快。

动态创建数据窗口的方法

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查询结果，快速生成数据窗口格式。