DataWindow This, DataWindow That...
Blah blah blah You've heard it enough that you don't even want to comment on how many times... The DataWindow. ....but it can't be enough anymore...can it? This from one of our colleagues (and yes my apologies for taking it out of context)... "...PB covers all you need to do that in ONE Tool. This includes Windowprogramming ( meaning the interface to the user: Windows, Sheets, diallougeboxes, etc.), Database operability AND Reporting! Well, I see als well as many other PB users that some of the implementations and features PB offers are improvable. But thi...

Help!!! Assign Datawindow into Datawindow object
Usually I used to assign a datawindow (dw_train) in a datawindow object (dw_1) in a window is go to propertise of datawindow object and browse for datawindow. My Question:- How to this action into pb script? If you want to assign datawindow 'd_my_dw' to a dw control dw_1 in your script, you would say dw_1.DataObject = 'd_my_dw' If you are going to make an executable, do not forget to include d_my_dw in your resource file. On Fri, 04 Dec 1998 07:34:37 -0500, in powersoft.public.powerbuilder.powerscript CKS21 <cks21@tm.net.my> wrote: >Usually I used to...

database in datawindow builder
hello, i have created a database in datawindow builder with one table. Now i want modify field in my table. For example, i want replace integer by char. But the fields are blocked and i cannot make changes. Can you help me ? thanks in advance Alexandre LEDET IMPULSOR alexandre.ledet@impulsor.fr Are you trying to modify/alter the table definition (i.e. changing a column type from integer to char, or are you simply trying to modify the data in a column. If latter, Datawindow Builder requires that you define a primary key for your table before it will let you modify dat...

How to share the datawindow to inner datawindow of nested datawindow
How to share the datawindow to inner datawindow of nested datawindow. Ex -------- dw_1 is normal datawindow dw_nes is nested datawindow, both are placed one window dw_nes contain dw_child datawindow Question ---------------- i want to share dw_1 and dw_child. I have tried the below code, getting error dw_1.sharedata( dw_nes.object.dw_child) It's the dot notation. You will need to dw_nes.GetChild("dw_child", ldwc) where ldwc is a _local_ datawindowchild. <kzganesan@gmail.com> wrote in message news:4c64c402-bac5-4ee0-83aa-4ac08ffe43e5@r66g2000hsg.go...

Help, Help, Help
Hello, I'm new to PB and using a ver. 7. All I wanted to do for the moment is to set my DataWindow to some of my SQL select statement.... That is, if I click the "Connect" the SQL select statement "new_select" will be viewed into the DataWindow "dw_CACHE". I tried lots of experiment and still failed! Below is a short code that I was doing. Kindly advice.... Regards, John ********************************************************************** string new_select // Set the default Transaction object properties (TestBed) SQLCA.DBMS = &...

Help, Help, Help !!!
Hello, I'm new to PB and using a ver. 7. All I wanted to do for the moment is to set my DataWindow to some of my SQL select statement.... That is, if I click the "Connect" the SQL select statement "new_select" will be viewed into the DataWindow "dw_CACHE". I tried lots of experiment and still failed! Below is a short code that I was doing. Kindly advice.... Regards, John ********************************************************************** string new_select // Set the default Transaction object properties (TestBed) SQLCA.DBMS = &...

datawindow works in PowrJ,fails in datawindow Builder
Hello. I am using a stored procedure inside a datawindow to update one table. when I ran my datawindow inside DataWindow Builder, I got an error message said: "Row Changed Between Retrieve and Update, No change made to database." When I used the same datawindow inside PowerJ3.5, i got the same error message, but the stored procedure was called successfully. The database was updated even though the error message from datawindow said it didn't. I don't understand why the stored procedure inside my datawindow worked in PowerJ but not in dataWindow Builder, and i don...

Deploying datawindow reports using HTML Datawindow.
Hi all, we are trying to put some of our datawindow reports from the current PowerBuilder application on to the Web. Most of the datawindows include nested reports and N-Up presentation styles. With the help of manuals and other documents, we set up the EAServer environment and tried to implement a few reports, but so far, only simple tabular and grid datawindows come up fine but not others. There was one N-Up style datawindow, which had all the rows overlapped and the header information not displaying correctly. In case of Nested reports, a document says that they are not suppor...

Re: Nested Datawindow Report (Datawindow Printing)
Does anyone know if this problem has been corrected in PB 8 or 9? Please advise. I am currently using PB 7. Problem: In case of large text fields, PowerBuilder not printing the Data correctly. Lines are cut in half and also not printing last few lines . This is happening on nested datawindow. Here is the link to the original documentation: http://info.sybase.com/resolution/detail.stm?id_number=10938800 Original documentation :-) states that this is not a bug but expected behaviour, so what kind of "correction" do you expect? pbm_thisusuallydoesnothelp:-)) Philip ...

Reference a datawindow object (nested report) in a datawindow
Is it possible to reference a datawindow object in a datawindow? My scenario : I have a datawindow (composite) which holds another datawindow (nested report). This child datawindow has a OLE ActiveX object which I am trying to access from the window which holds the composite datawindow. The reason for this is because I need to access the ActiveX properties/functions after the composite datawindow have been retrieved. I've tried to get a reference to the child datawindow : //DataWindowChild dwc_activex dw1.getchild("dw_activex", dwc_activex) But as datawi...

datawindows in composite datawindow used in datawindow.NET, are not sliding up
Hi, Problem: datawindows in composite datawindow used in "datawindow.NET", are not sliding up , if one dw is not visible or did not retrieve data. Resulting in unwanted spaces. The height of blank white space is equal to the height of the datawindow art design time. When I looked at the generated JavaScript, I noticed there is "div" for the datawindow with height 0.00in which is supposed to be not visible. Tried different options with html/xhtml/xml same result. But slides up ok when exported to pdf(using saveas) on web and in PB10.5 application. Also s...

datawindow
Add direct setting and getting capability for the datawindow where clause. This would have to be a string array in case of unions. Return ONLY the where clause(s) in the main select (in case of sub-selects, ignore the where clause or somehow list it as a subselect in the where or a subselect in the select). It would be great if I could just get and set this as a value and have the datawindow automatically change (or add) the where clause as specified. This is for setting the where clause dynamically at run time. Currently have to parse through the datawindow.table.select looking f...

DataWindow Within DataWindow
How Can I access/modify object/control from a Datawindow within Datawindow. When i access/modify object/control from a Datawindow i used dw_1.modify("name.text = 'new val'") but within another datawindow or child datawindow it doesnt work. Your description is difficult to understand due to the terminology. First, a datawindow is assigned to a control - either a datawindow control or a datastore. Second, the Modify function can only be called within a script. With that as a basis, can you rephrase the question and describe more precisely what you want to do? ...