2007-09-10

SQL Server 安装:以前的某个程序安装已在安装计算机上创建挂起的文件操作

安装MS SQL Server遇到错误提示:

以前的某个程序安装已在安装计算机上创建挂起的文件操作。运行安装程序之前必须重新启动计算机。

解决:
删除

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations

项目。

摘自:张光见博客
http://www.proxyserve.net/index.php?q=aHR0cDovL3d3dy5jbmJsb2dzLmNvbS93aWxscG93ZXIvYXJ0aWNsZXMvNjExODUuaHRtbA%3D%3D

2007-09-07

Access data values from composite datawindow

We may need to access certain values at run-time. To access values in the normal datawindow object, we use the following dot notation syntax:

datawindowControl.Object.columnname[row]


In order to access nested object values of composite datawindow, we can use:

datawindowControl.Object.Reportname.Object.value[row]


Sometimes, we need to modify nested report object properties. we may use Getchild() function to get nested report handle, and then manipulate it as if the neasted report is a datawindow control. Here is an example:


//There is a composite datawindow control named dw_product_info
//A composite datawindow has dw_master and dw_detail neasted report.
//We need to sort the rows of dw_detail by the first column

datawindowchild ldwc_detail
dw_product_info.getchild("dw_detail",ldwc_detail)
ldwc_detail.setsort("#1 A")
ldwc_detail.sort()

2007-09-06

Evaluating the display value of a DropDownDataWindow

This example uses Describe’s Evaluate function to find the display value in a
DropDownDataWindow column called state_code. You must execute the code after the ItemChanged event, so that the value the user selected has become the item value in the buffer. This code is the script of a custom user event called getdisplayvalue:

string rownumber, displayvalue
rownumber = String(dw_1.GetRow())
displayvalue = dw_1.Describe("Evaluate('LookUpDisplay(state_code) ', " &
+ rownumber + ")")


This code, as part of the ItemChanged event’s script, posts the getdisplayvalue
event:

dw_1.PostEvent("getdisplayvalue")


Quoted from PowerBuilder 10.5 DataWindow Reference