datawindow vs. embedded sql
I would like to update a table, but have found using
datawindows to be very slow especially when performing a lot
of dw_1.SetItem statements. Instead, I'm using embedded sql
insert statements for each row. Could someone please
explain the disadvantages of using embedded sql?
Embedded SQL is useful for several things.
What are you planning on doing with it?
If you put it in a loop and send one insert/update...
at a time to the server than wait for the reply and
then send the next one... Too slow... Also you will
have to do something with the transa...Embedded SQL Vs DataWindow Update...
I have often heard a debate on the processing speeds of embedded SQLs.
I have heard an argument stating that "Embedded SQL takes more time to
execute than the update of a DataWindow that is defined with a SQL
similar to the embedded SQL".
Does anyone have any clue about the authenticity of the above argument?
Which of these is a better approach?
Thanks in advance.
I have no way of confirming this and can only offer reasoning as the
justification for my opinion.
I think Embedded SQL should be faster than similar SQL generated by a
DW. The SQL...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...Embedded SQL vs datawindow object in PB7
I'm trying to run a Select statement against an Informix database with
PowerBuilder 7 and using the Intersolv Informix 9 driver.
I've created a dw object that I can retrieve 3 rows from the Informix
database. I've created the same SQL statement and embedded it in a
window function. When I run the window, the statement seems to run ok,
but I get no rows from it. I've connected to the database, set the
trans object and retrieved all in consecutive lines, but it still
doesn't return anything.
I've even tried creating a test window that has a dw control on it...embedding a datawindow within a datawindow
Below is a sample of the format for a report I need to
create. The report will display courses that may or may not
be part of group, because the people running the courses can
choose from all the courses available to create their own
"group" of courses. Since a course may or may not be part
of a group would using an embedded datawindow for the group
info work? How? Can anyone point me in the right
direction? The data is coming from two tables.
CourseID CourseTitle CourseTopic EnrollMax EnrollCurrent
100145A "Sample" "Sample"...Html-datawindow vs web-datawindow
We have mede some pages using datawindowbuilder.
There we used html-datawindows.
Now we have upgraded to PB8 and here it is called web-datawindow.
What is the differense?
40% of the pages arnt working after we migrated to PB8. It seems like there
have been some changes?
What errors are you seeing with the problem pages?
> We have mede some pages using datawindowbuilder.
> There we used html-datawindows.
> Now we have upgraded to PB8 and here it is called web-datawindow.
> What is the differense?
>...SQL vs Datawindow
I was wondering if there were reasons for utilizing SQL and not a
Datawindow or a Datastore when performing an update or insert?
Is there a preferable way. Which is better?
The preferable way is whatever works, Sorry had to say it ;-). This is a
subject where you are going to get a lot of different opinions. In my
opinion I like to use a datawindow or datastore for any updates or inserts
where there is more then one record affected. For the times when there is
only one record affected I create a function on a userobject and do it from
there. One of the thing...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.
<firstname.lastname@example.org> wrote in message
news:email@example.com...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...Embedded DataWindow within the new HTML DataWindow
Does the new HTML datawindow support embedded HTML datawindows? Thanks.
In a word, no. Here's an extract from an upcoming article I wrote for PBDJ
on the HTMLDW and the presentation styles it supports:
Presentation Style Report (non-updateable) Form (updateable)
================== ======================= =================
Composite No (HTMLDW not supported) No (HTMLDW not supported)
Cross-tab Yes No (cannot set tab order)
Freeform Yes Yes
Graph ...HTML Datawindow DTC vs. Datawindow DTC
Can anyone tell me if the HTML Datawindow DTC provides an 'easy' way to make
columns sortable like you can in the Datawindow DTC?
To do this you can code the following:
This code could be tied to a drop down list box or a set of radio
buttons that contains the column names to be sorted.
Dan van Leeuwen
On Wed, 12 May 1999 16:48:40 -0500, "Noah Pruzek"
>Can anyone tell me if the HTML Datawindow DTC provides an...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...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 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