DataWindow This, DataWindow That...
Blah blah blah
You've heard it enough that you don't even want to comment on how many
....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! How to modify the sql select statement for a nested datawindow inside a composite datawindow?
How to modify the sql select statement for a nested datawindow inside a
Would the following work?
dw_nest.Object.DataWindow.Table.Select="select employee_id from ..."
GetChild () ???
"Jun Gan" <firstname.lastname@example.org> wrote in message
> How to modify the sql select statement for a nested datawindow inside a
> composite datawindow?
> Would the following work?
> dw_nest.Object.DataWindow.Table.Select="select e...Top Statement and INDEX= Statement in Datawindow SQL Painter
Is there any way to put TOP and INDEX statement into Sql definition in
Datawindow painter in graphical view.
I know that I can go to "Convert to Sytax" but I want to learn if there is
an option like "DISTINCT" in painter.
Select TOP 100 Name,Surname FROM Names (INDEX = INX_name)
Thanks for all
'Top 100' you can do by making the first item in the select list a computed
TOP 100 Name
I can't think of a way of doing Index.
I never use graphical mode for anything other than very simple queries (and
usually no...SQL statement in datawindow
In my Datawindow painter, I would like to use "LIKE" in the where clause of
my SQL SELECT STATEMENT, but it doesn't seem to show the correct results. I
want to show the results from the database where the input (a retireval
argument) matches anything that's entered close to that entry. I tried
something like this:
SELECT name, address, city, province, postal_code
WHERE name like '%(:name)%';
How can I use LIKE in the WHERE clause where string I am trying to match is
an input retrieval argument?
where name like '%' + :name + '%...How to share the datawindow to inner datawindow of nested datawindow
How to share the datawindow to inner datawindow of nested datawindow.
dw_1 is normal datawindow dw_nes is nested datawindow, both are placed
dw_nes contain dw_child datawindow
i want to share dw_1 and dw_child.
I have tried the below code, getting error
It's the dot notation. You will need to dw_nes.GetChild("dw_child", ldwc)
where ldwc is a _local_ datawindowchild.
<email@example.com> wrote in message
news:firstname.lastname@example.org...Export datawindow select statement form all datawindows
I have a large application with a lot of DWs.
DB is SQL Server 2000.
Some DW use " (double quotes) in the select statement (not '), and now, with
PB105 and oledb, this statements fails (MS native driver works)
I know that " isn't a valid character for delimiting strings in SQL, but
this large application was written by many people :)
How can I find all " in all select statements in all DW within my
application to do a replace.
I'm not sure wether some tool like PBL Peeper is capable...changing datawindow connection is breaking my datawindow SQL
I have had to move a number of datawindows from Oracle 9i running on a
windows 2003 to Oracle 9i on AIX 4.3.3 (which is also on a private network,
and requires a VPN to connect to).
In the datawindow designer, I have also had to change the database interface
from O90 Oracle 9i to an ODBC datasource (because I was not able to
connect). In doing so, I have had to graphically re-create all the DW SQL
again because I get this error:
Table "XYZ" has no columns, possible invalid table format. Do you want to
continue in graphic mode?
If I select "NO", the SQL is...Datawindows with child datawindows
I want to create a datawindow whose only data is three columns that will
themselves be drop-down data windows. These child datawindows will be
populated in PB script with dw_1.GetChild(). When I create that parent
datawindow (New | Datawindow | Freeform), what do I choose in the next
dialog box ("Which datasource would you like to use?") External?
That depends on how you want to populate and use the columns of the main DW.
The DDDW is an edit style that assists the user in selecting a value for the
column in the main DW. If you want to retrieve the values ...DataWindows and datawindow objects
Difference between Datawindow and datawindowobjects?
- datawindow is a control on a userobject or a window
- datawindowobject (DWObject) is a control within a datawindow, defined in
the dataobject of the datawindow.
You refer to it as <datawindow-instance>.Object.<datawindow object>
<Santhoshi> wrote in message news:email@example.com...
> Difference between Datawindow and datawindowobjects?
DW Control is a "container" that reserves real-estate on the surface of
a visual object.
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...modifiyin a datawindow in a datawindow
When I want to modify a datawindow, then it's just
But what do I have to do when I want to modify a datawindow
in a datwindow ?
I tried : dw1.dw2.modify() but that doesn't work.
Anyone can help me out with this ?
get the dw via getchild & apply modify
In article <firstname.lastname@example.org>, David says...
> When I want to modify a datawindow, then it's just
> But what do I have to do when I want to modify a datawindow
> in a datwindow ?
> I tried : dw...datawindows in composite datawindow used in datawindow.NET, are not sliding up
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
The height of blank white space is equal to the height of the datawindow art
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
Also s...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? ...How do I pass an SQL statement to a datawindow?
I am creating a custom query module for my application. In that module I
build the SQL statement (SELECT column1 FROM table1...), in my application,
based on the criteria the user selects. I now need to display the records
and I figured I could do that by passing the SQL to the datawindow and have
the datawindow do the retrieval and formatting of the columns but I couldn't
find any way to do that. Anyone have any ideas or suggestions?
Take a look at SyntaxFromSQL function. Look at example 2 specifically
Hope this helps