How to create dynamic columns in the Datawindow Using powerbuilder

Can any one let me know How to create dynamic columns in the data window 
using modified method.

Thanks in Advance

3/14/2005 9:14:16 PM
sybase.powerbuilder.general 62418 articles. 18 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 1

Please refer "Datawindow Syntax" tool provided by sybase for
generating the syntax to create dynamic columns.

/*************Dynamic column Syntax
<DW Control Name>.Modify(&
"create  column( id=<an integer> tabsequence=<an integer>
accelerator='<a single letter>' moveable=<0 - False, 1 -
True> resizeable=<0 - False, 1 - True> pointer='<Arrow!,
Cross!, HourGlass!, IBeam!, Icon!, Size!, SizeNESW!,
SizeNS!, SizeNWSE!, SizeWE!, UpArrow!, or cursor filename
(with path)>' band=<Detail, Footer, Header, Header.<group
#>, Summary, Trailer.<group #>, Background, Foreground>"  + 
" x='<an integer>' y='<an integer>' bitmapname=<Yes or No>
criteria.dialog=<Yes or No> criteria.override_edit=<Yes or
No> format='<constant string containing display format
(i.e., [general]) for col (can also be an expression)>'
alignment='<0 - Left, 1 - Right, 2 - Center>'
criteria.required=<Yes or No> height.autosize=<Yes or No>
border='<0 - None, 1- Shadow, 2 - Box, 3 - Resize, 4 -
Underline, 5 - 3D Lowered, 6 - 3D Raised>' color='<a long>'
height='<an integer>' width='<an integer>' name=<string>
" background.mode='<0 - Opaque, 1 - Transparent>'
background.color='<a long>' font.face='<name of type face
(i.e., SYSTEM, COURIER)>' font.height='<negative number for
points, positive number for PBUs (i.e., -10 = 10 points, 10
= 10 PBUs>' font.weight='<400 - Normal, 700 - Bold>''<0 - AnyFont, 1 - Roman, 2 - Swiss, 3 - Modern,
4 - Script, 5 - Decorative>' font.pitch='<0 - default, 1 -
Fixed, 2 - Variable>' font.charset='<0 - Ansi, 1 - default,
2 - Symbol, 128 - Shift JIS, 255 - OEM>' font.italic='<0 -
False, 1 - True>' font.strikethrough='<0 - False, 1 - True>'
font.underline='<0 - False, 1 - True>''<URL (with
or without parameters) that is used to generate a link for
each row of the particular column>' html.linktarget='<Target
frame or window that is used to as part of the generated
link for each row of the particular column>'
html.linkargs='<argName>='<expr>' [<argName>='<expr>']
"  edit.validatecode=<Yes or No> edit.focusrectangle=<Yes or
No> edit.format=<constant string containing display format
(i.e., [general]) for col (can also be an expression)>
edit.nilisnull=<Yes or No> edit.password=<Yes or No>
edit.required=<Yes or No> edit.hscrollbar=<Yes or No>
edit.limit=<max number of chars the user can type (0 -
32767)> edit.codetable=<Yes or No> edit.displayonly=<Yes or
No> edit.autovscroll=<Yes or No><Any, Upper or
Lower> edit.autohscroll=<Yes or No> edit.autoselect=<Yes or
No> edit.vscrollbar=<Yes or No>'<repository style
name, if any>') ")

> Hi,
> Can any one let me know How to create dynamic columns in
> the data window  using modified method.
> Thanks in Advance
> Rami
3/15/2005 10:44:56 AM

Similar Artilces:

Can datawindows created in Powerbuilder be used?
Hi all, does anyone know if datawindows created in older versions of Powerbuilder can be used in If they can, which version of Powerbuilder can the datawindows be created in? Could I for instance take an existing datawindow created in Powerbuilder 7 and use it in a .net app without any modification? Thanks for any help you can give. Steve. Yes they can. They need to be migrated to the version of DataWindow ..NET that you are using, but the DataWindow Designer that comes with the product will do that for you. Note: OLE and Rich Text DataWindows are not sup...

Use PowerBuilder DLL in PowerBuilder
We use PB6.5. We would want to use a DLL create from PB in a PB application. We compiled an a PBL as DLL. After we tried to use DLL in a user object external, but without success. How can we do to use DLL create from PB or use in a new PB application some object (visual and no) before compiled with PB? Any help will be appreciated. Thanks When you create a DLL from a PB library it is not really a standard Windows DLL. I'm not sure what the difference is. If you are making calls from PB then just use the standard PB calling syntax the ...

creating dynamic datawindow using create...
I am using the create statement to create a dynamic datawindow that will be of type Group. When a datawindow is created of type Group the title(if added to the create statement)/date/ and page numbering are automatically added. The only downfall is that the items automatically added have no names associated to them. Unfortunately I need a name to represent the line of datawindow code so that I can change x/y coordinates and other properties of the object. If you have any idea as to how i can add a name to already created datawindow syntax objects such as Text, and Computed fields ...

Creating DLLs using Visual Objects for use in PowerBuilder
Hi All, Has anybody created a DLL with visual objects in Power++ ? < ---- Part of this post contains text (modified) from an earlier post of mine ---- > I have run into the following problem on this. 1. I open a new project 2. I add a new DLL target (and delete the EXE) 3. I add a plain form Form1 (since the default Form1 is deleted by deleting the EXE) 4. I add a new File test.cpp to the target, and in that the only statements I add is #include "form1.hpp" I Run->Build File at this stage and I get the following compile error in Form1....

Version of PowerBuilder (ref: Creating database for PowerBuilder)
I'm using PowerBuilder v8.0 and would like to create a notification system for my practiculum project. I'd like to use Access to create the database. Please enlighten me on what should I create (e.g. tables, queries) for the usage of it. Thank You. Regards, Yang Ashra Don't double post, it's bad etiquette. Unless you have a very good reason to do so, we recommend you don't use Access. Use SQL Anywhere instead - it's more stable - and a far better database in my opinion. PowerBuilder (enterprise) supports just about every database out there, so if you...

Dynamically creating columns in a datawindow
Hi all, I am trying to dynamically add columns to a datawindow and I am running into some problems. The columns that I am creating are NOT database columns but instead are part of a manual result set. Essentially, I am trying to use the datawindow like a spreadsheet, but I do not know up front how may columns I will need. I use the datawindow painter to create an object with a small number of columns. I then delete those columns in the datawindow painter and use the modify() function with the create syntax to start adding in the columns that I want. All goes well until I add one...

how to dynamic create a column in datawindow?
As subject Thanks Use Modify (...) function, with CREATE control syntax. See more in PowerBuilder help for Modify function. "Ivan Lai" <> wrote in message > As subject > > Thanks > > > but the error is occur when I change the ID values to greater than 1. Why? Thanks "Wendell Rios" <> ���g��l�� > Use Modify (...) function, with CREATE control syntax. See more in > PowerBuil...

how to dynamic create a column in the datawindow?
why i cant create a column in the dw using this script "Create column(band=detail id=57 alignment='0' tabsequence=30 border='0' color= '0' x='700' y='10' height='96' width='58' format='[general]' name=call_notes edit.limit=0 edit.focusrectangle=no edit.autoselect=yes font.face='MS Sans Serif' font.height='-8' font.weight='400''2' font.pitch='2' font.charset='0' background.mode='2' background.color='16777215')" return err...

Error trying to use a datawindow created using CREATE
Should it be possible to do the following in 5.0.04: u_dw ldw integer li_Result ldw = create u_dw ldw.dataobject = "dw_test" li_Result = ldw.of_SetTransObject( SQLCA ) li_Result = ldw.retrieve() destroy ldw The of_SetTransobject fails with a -1. The following also fails: datawindow ldw integer li_Result ldw = create datawindow ldw.dataobject = "dw_test" li_Result = ldw.SetTransObject( SQLCA ) li_Result = ldw.retrieve() destroy ldw The following works: n_dw lds integer li_Result lds= create n_dw lds.dataobject = "dw_test" li_...

creating new columns in a datawindow dynamically
Hello, I got the following problem. I want to create a new column in a datawindow at runtime. I have copied the syntax to create the new column from an exported dw: dw_1.Modify('create column(band=detail id=2 alignment="2" tabsequence=10 border="5" color="0" x="216" y="3" height="54" width="194" format="[general]" name=spalte2 visible="1~t0" edit.limit=0 edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.fami...

Powerbuilder crashes when opening or creating datawindow
Powerbuilder crashes when I try to open or create a new datawindow in Pb9.0 I get this error AppName: pb90.exe AppVer: ModName: pbdev90.dll ModVer: Offset: 0002d23c Please help! Delete the registry key [HKEY_CURRENT_USER\Software\Sybase\PowerBuilder\9.0\Layout\Default] "Datawindow"="" PB will automatically recreate it. -- Terry Dykstra (TeamSybase) product enhancement requests: <kith> wrote in mes...

dynamically creating a datawindow using syntaxfromsql
i'm dynamically creating a datawindow using syntaxfromsql to create a datawindow object. i then import data into the datawindow that will be saved as an excel spreadsheet. my code looks something like this: ---------------------------------------------------------------------------- ----------------------------------------------- string ls_SQL, ls_Errors datawindow ldw_Excel ls_SQL = "SELECT '' as "headername1", '' as "headername2", ect. FROM sometable ls_SQL = SQLCA.SyntaxFromSQL(ls_SQL, '', ls_Errors) ldw_Excel = CREATE...

Could not add datawindow using powerbuilder 7
I have selected a new datawindow but was not added. Even tried to add objects but was failed to do so. There were no errors generated. I was able to add object or datawiindows before but after I have re- installed my powerbuilder this problem occurs. Please help. Thanks... ...

Column Attributes in dynamically created datawindow?
I have a data window control which is populated "on the fly" from a query which will return varying numbers of columns. I would like to be able to set column attributes such as alignment and font for each of the columns. Can anyone tell me how to do this? I have tried: For I = 1 to NumberofColumns dw_8.object.#I.Alignment = 2 Next but it always chokes. Thanks, Dan Bray Dan, What do you mean by "chokes"? Do you get the error accessing property error? Alternatively, you can do: ls_objects = dw_8.Object.DataWindow.Objects to get a li...

Web resources about - How to create dynamic columns in the Datawindow Using powerbuilder - sybase.powerbuilder.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 12/11/2015 8:49:46 PM