HTML for inserting the controls on a Web page
You include the controls on a Web page with an Object element
and associated Param elements. Then you write scripts that direct
the control to make database connections, retrieve and update data,
and respond to user actions.
The way the Object and Param elements look in a Web page are
described next. When you insert the controls and set their properties
using the Web Target user interface in PowerBuilder or PowerJ, these
elements are coded for you.
Object element
How it works
ActiveX controls use the Object element to specify the GUID
(a unique identifier) of the control as well as the space the control
takes on the page. The Object tag looks like this:
|
1 |
<OBJECT id=PSDWC1 height=357 classid="CLSID:AAAA1503-AAAA-1000-8000-080009AC61A9" width=343> |
|
1 |
</OBJECT> |
In a Web target, when you insert the Web ActiveX control by
dragging from the System Tree or by using the Insert>Component
menu item, the Object tag is written for you.
CODEBASE attribute
If your users need to download the controls, you can include
the CODEBASE attribute in the Object element to identify the file
to be downloaded. After the browser downloads the CAB file, it unpacks
it and registers the ActiveX controls in the user’s system
registry.
The value for CODEBASE has the format:
|
1 |
<i>url</i>#<i>version</i> |
A typical value for CODEBASE uses a relative URL:
|
1 |
CODEBASE="cabs/psdwc90.cab#9,0,0,3514" |
URL The URL is the location of the DataWindow control’s
CAB file on your Web server. It can be an absolute or relative URL.
Version The version is a set of four numbers, separated by commas.
The numbers must match the version of the CAB file. The version
number of the CAB file is the same as the version number for PowerBuilder.
To find out the 4-part version number in Windows:
-
Select the PowerBuilder executable or a
PowerBuilder DLL in Windows Explorer. -
Select File>Properties from the menu
bar. -
On the Version tab, look at File Version. A typical
number is 10.0.0.3514.
Example
The Object element with a CODEBASE attribute looks like this:
|
1 |
<OBJECT codeBase=<br />"http://www.domain.com/psdwc90.cab#Version=10,0,1,<br />3514" id=PSDWC1 height=357 classid="CLSID:AAAA1503-AAAA-1000-8000-080009AC61A9" width=343><br /></OBJECT> |
New versions
When you get new versions of the CAB file, you can change
the version numbers on the Web page and cause the browser to install
a new version of the control.
For more information about how to deploy new versions, see “Deploying the Web ActiveX”.
Putting the Object tag in a separate file
If the Cumulative Security Update for Internet Explorer (912812)
or a subsequent update is installed on the computer where the Web
ActiveX control is running, a browser refresh does not refresh the
control correctly. This update is described in Microsoft Security
Bulletin MS06-013, published in April 2006.
To work around this issue, put the <OBJECT> tag
in a separate JavaScript file instead of the main HTML file, as
shown in this example:
|
1 |
// HTML file<br /><HTML><br /><HEAD><br /> <TITLE>test</TITLE><br /></HEAD><br /><BODY bgColor="white" PSPARAMS=""><br /><P>Put your data here </P><br /><P>&nbsp;</P><br /><P><br /> <div id="DivID"><br /> <script src="createElement.js"></script><br /> </div><br /></BODY><br /></HTML> |
The createElement.js JavaScript file
contains the Object tag:
|
1 |
// createElement.js file<br />var d = document.getElementById("DivID");<br />d.innerHTML = <br />'<OBJECT id="OBJECT1" style="WIDTH: 627px; HEIGHT: 320px" codeBase="psdwc100.cab" classid="CLSID:AAAA1503-AAAA-1000-8000-080009AC61A9">'<br />+'<PARAM NAME="_Version" VALUE="65536"></PARAM>'<br />+'<PARAM NAME="_ExtentX" VALUE="16589"></PARAM>'<br />+'<PARAM NAME="_ExtentY" VALUE="8467"></PARAM>'<br />+'<PARAM NAME="_StockProps" VALUE="2"></PARAM>'<br />+'<PARAM NAME="Caption" VALUE=""></PARAM>'<br />+'<PARAM NAME="SourceFileName" VALUE="test.psr"></PARAM>'<br />+'<PARAM NAME="DataWindowObject" VALUE="test.psr"></PARAM>'<br />+'<PARAM NAME="LogId" VALUE=""></PARAM>'<br />+'<PARAM NAME="LogPass" VALUE=""></PARAM>'<br />+'<PARAM NAME="dbParm" VALUE=""></PARAM>'<br />+'<PARAM NAME="SuppressEvents" VALUE="0"></PARAM>'<br />+'<PARAM NAME="VScrollBar" VALUE="0"></PARAM>'<br />+'<PARAM NAME="HScrollBar" VALUE="0"></PARAM>'<br />+'<PARAM NAME="HSplitScroll" VALUE="0"></PARAM>'<br />+'<PARAM NAME="LiveScroll" VALUE="0"></PARAM>'<br />+'</OBJECT>'; |
Properties and Param elements
How they work
The Web ActiveX and the Transaction Object control have several
properties that specify connection information. The Web ActiveX
also has properties that specify a DataWindow object or a PSR. You
provide values for the properties with Param elements, which are
enclosed in the Object element.
When you insert the controls in a Web target, Param elements
are automatically added to the Web page. You can provide values
for the Param elements using the control property sheets. You can
also write scripts that set or change property values.
The inserted Param elements are grouped in an order that corresponds
to pages in the control property sheets. The first group of Param
elements contains standard ActiveX properties. You can assign values
for the standard ActiveX properties in the ActiveX OBJECTn Properties
dialog box, where n is the order in which the
object is placed on the page.
The Web ActiveX also inserts Param elements for custom properties.
You set these custom properties from the Sybase DataWindow Web Control
Properties dialog box. To open this dialog box, you can click the
Control Properties button on the ActiveX page of the ActiveX OBJECTn Properties
dialog box for the Web ActiveX control.
The Sybase DataWindow Web Control Properties dialog box has
four tab pages where you can set custom properties: General, Scrolling,
Transaction, and Trans User. The Transaction Object control has
only two custom property pages: Transaction and Trans User.
Standard ActiveX properties
|
1 |
<PARAM VALUE=65536 NAME="_Version"></PARAM> |
|
1 |
<PARAM VALUE=9280 NAME="_ExtentX"></PARAM> |
|
1 |
<PARAM VALUE=5155 NAME="_ExtentY"></PARAM> |
|
1 |
<PARAM VALUE=2 NAME="_StockProps"></PARAM> |
|
1 |
<PARAM VALUE="" NAME=Caption></PARAM> |
Properties on General page
|
1 |
<PARAM VALUE="javadwtest.pbl" NAME=SourceFileName> </PARAM> |
|
1 |
<PARAM VALUE="d_emp" NAME=DataWindowObject></PARAM> |
|
1 |
<PARAM VALUE=0 NAME=SuppressEvents></PARAM> |
Properties on Scrolling page
|
1 |
<PARAM VALUE=0 NAME=VScrollBar></PARAM> |
|
1 |
<PARAM VALUE=0 NAME=HScrollBar></PARAM> |
|
1 |
<PARAM VALUE=0 NAME=HSplitScroll></PARAM> |
|
1 |
<PARAM VALUE=0 NAME=LiveScroll></PARAM> |
Properties on Transaction page
|
1 |
<PARAM VALUE="Driver='com.sybase.jdbc2.jdbc.SybDriver', URL='jdbc:sybase:Tds:localhost:2638'" NAME=dbParm> </PARAM> |
Properties on Trans User page
|
1 |
<PARAM VALUE=dba NAME=LogId></PARAM> |
|
1 |
<PARAM VALUE=sql NAME=LogPass></PARAM> |