From the beginning, the DataWindow has been a powerful client/server control.
What has set it apart from competing products is its ability to create SQL.
In reality, the DataWindow is a SQL-generating machine. By keeping track of
row and column statuses, the DataWindow is able to generate the correct SQL
statement to UPDATE, DELETE, or INSERT rows into a database. In most
instances, the developer is oblivious to the SQL generation; all that's
needed to unleash all this functionality is to issue a simple update
function. However, DataWindows can take SQL only so far, as their use of SQL
has its limitations, for example:
In certain instances, a SELECT statement, DataWindow result sets, or
retrieval arguments can't be changed easily. A DataWindow cannot issue DDL
commands... (more)
Objects can be added to your DataWindow programmatically via a Modify
statement. In my opinion, the dynamic creation of objects within a DataWindow
has been a highly underused feature.
Dynamically creating (or destroying) objects within a DataWindow has many
advantages such as:
Dynamically changing the content If a printed DataWindow varies in appearance
from its visual presentation
The ... (more)
JBuilder Data Express controls enable JBuilder developers to use prebuilt
objects to provide the user with an interface in which to view and manipulate
data. For the most part, the use of Data Express components simplifies our
task of programming data access functionality into our applets/applications.
One drawback of using these components is that you're restricted to using
only functio... (more)
In Parts 1 and 2 of this article (JDJ, Vol. 6, issues 1 and 7) I discussed
how to use a JTable with a table model and showed how much work is involved
getting a JTable to work with data. This is quite a departure for veterans of
other fourth-generation languages who may be used to developing in Visual
Basic or PowerBuilder.
Both these languages have intelligent controls that keep track of... (more)
Aileron is a business-quality mobile messaging solution for Palm-powered
handheld devices. Its intuitive design helps mobile professionals to
completely manage corporate and personal communications from anywhere.
Aileron enables users to manage entire conversations from one window,
allowing them to easily send and receive e-mails with attachments, and even
faxes. Users of convergent devi... (more)
Bob Hendry is a PowerBuilder instructor for Envision Software Systems and a frequent speaker at national and international PowerBuilder conferences. He specializes in PFC development and has written two books on the subject, including Programming with the PFC 6.0.
Alf Pilgrim
Per Sjofors
Kirsten Lytsen
Data Recovery Services
Colin Armitage
