I'm importing a some data into my application. The way I do this is to
insert a the rows into a datawindow and then do an update() on the
If a row in the database allready exists with the same primary key as I have
inserted into the datawindow, what will happen then? Will then datawindow do
an update or will I get an error?
I'm doing this on a datastore object. How can I get an errormessage from the
datastore? I have tried the errormessages and codes from the transaction
object (sqlca.sqlerrtext and sqlca.sqlcode).
> If a row in the...Powerbuilder Datawindow
Can you do a Datawindow in VS 2005 without using
Datawindow.NET just by using common controls i.e DataGrid
What would you use the DataWindow for then? To retieve the datawindow
into a datastore and then attempt to use it to populate the DataGrid?
I've heard of people who want to have their cake and eat it too, but
it sounds like you want no cake but you want to eat it...
On 20 Feb 2007 23:42:31 -0800, Chris Ceniza wrote:
>Can you do a Datawindow in VS 2005 without using
>Datawindow.NET just by using common control...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...PowerBuilder V10.5.1.6565 datawindow bug
I am getting an odbc error when retrieving this datawindow. I simplified
the SQL as much as I could. This datawindow is working find in an older
version of PB 10.5.1 and in PowerBuilder V9.x. I am connecting to SQL
Anywhere V126.96.36.19920. I will write this up in case express.
------ sql causing problem ---------------
SELECT (SELECT SUM(0) FROM "dummy") as "min_amt_due",
(case :as_bill_stmt when 'B' THEN :ac_min_due_b when 'S' THEN
:ac_min_due_s ELSE :ac_min_due_s END) + 0.00 as "c_value2"
FROM "dummy"...powerbuilder 10 build 8075 datawindow dddw bug.
If the datawindow column type is money and has dddw, I get error message
"Expression is invalid".
If I replace dot with comma in regional settings, I can solve the problem.
I am using Turkish Charset.
We also get the same error message when we apply a filter that has a dash
'-' in the expression (using setFilter()). We went back to 8050.
"Murat Yelkovan" <email@example.com> wrote in message
> If the datawindow column type is money and has dddw, I get error message
> "Expressi...Powerbuilder 9.0.1 Build 7204 Datawindow Bug
After installing the latest patch, any of our dynamic
datawindows containing a timestamp have the timestamp field
overlapping other columns. I'm not sure if it is the
timestamp property itself or the specific column, but no
changes were made to the database and this error occurred as
soon as the 7204 patch was applied. This is a serious
Do anybody know similar problem occuring in PB9 or earlier version?
Any solution, is it a reported bug?
Thanks in Advance
What was the prior build that you used?
Reason is we are using 188.8.131.5251 and moving to 9.01.7204 t...PowerBuilder 7.0.3 Build 10108 Datawindow Update Properties Bug
When setting the Update Properties for a DataWindow Object, columns of
datatype 'datetime' are not listed under the 'Unique Key Columns' listbox.
We are connecting to a Microsoft SQL Server 7.0 database using a MSS 6.x
driver. Anyone experience this problem? Our only workaround is to export
the object to text, modify it manually, and then re-import the object.
We're concerned that this is too dangerous and could possibly corrupt the
object. Also, does anyone know where/how to obtain a native mode SQL 7.0
driver for PB 7?
Check the documentation...PowerBuilder down on opening a datawindow.
I'm using PowerBuilder 9.0.1 on Windows XP and Oracle9i.
Suddenly I cannot open any datawindow.
Each time I tried to open datawindow with datawindow
PowerBulider gets down.
Someone told me that changing default printer might help.
But it didn't help.
Please help me.
First make a backup of the datawindow to another .pbl (you may even want to
create a new .pbl just to hold the backup).
1) Try regenerating just the datawindow.
2) Try optimizing your .pbls then a full regeneration (back up all the .pbls
first, again just as a ...Powerbuilder Datawindow Retrieve
I would like to create a dynamic datawindow retrieve. I have a list of
datawindows with various types of retrieval arguments--some are arrays. I
would like to pass a program the parameter and parameter type and have it
dynamically build the retrieve. I've tried using the ANY variable type, but it
doesn't work when the argument is an array. Does any one know of a way to
"build" the retrieve statement on the fly, or something else to do?
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.d...Powerbuilder Datawindow Painter.
We have developed an application that allows user to create custom data
entry windows using
datawindow painter dw60.exe (PB 6.5.1). This works very well for our users
who are non IT
people. The problem we have is that dw60.exe is distributed with the
Powerbuilder but not sold
as a separate purchasable product. After discussions with Sybase
representatives we have each
user purchase a copy of Infomaker to make them 'legal'. We are not
totally happy with this
situation as we move forward to PB 8 also we are not sure if there is a
dw80.exe or whether this
will be supp...How to realize datawindow with PowerBuilder
I want to realize datawindow with PowerBuilder,thus client may develop
report themselves with the tool.I want some advice,or give me some URL of
I have a poor English,hehe.
thanks very much.
Sybase Adaptive Server Anywhere Professional Version 8
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments fo...PowerBuilder and Power++ Datawindows
We are still maintaining an old Power++ based application,
which makes quite extensive use of DataWindows. Since using
the DataWindows with a MS SQL Server 2005 (a customer
requirement), we are looking for a solution where we can use
the old Power++ SW with a more recent DataWindows
Is this possible at all with PowerBuilder? Are we able to
import or migrate the already existing *.pbl/*.pbd files?
Os is DataWindows.NET a more feasible solution?
> We are still maintaining an old Power++ based application,
> which makes quite exten...PowerBuilder DataWindow #2
I have a requirement to implement a master-detail sheet. That's ok.
However, based on the user-logged-in credential, the user may OR may
not be able to edit the details part.
Now I can easily implement this by adding a constraint while updating
the details' data.
if user_can_edit then
The problem is this:
If the user is not entitled to make changes, he is still able to put
focus to the details' form data and modify (of course I am not
updating it)...but the user can get a feeling "oh I am able to modify
Is it so...Printing a Datawindow in PowerBuilder
I have some problems properly printing a datawindow in PowerBuilder. When I
print a document the printer will print the top half of the ast line on the
third and bottom half of the line on the fourt page.
In my datawindow I only have aboout four fields but the last one is a SQL
Server "TEXT" field, so this field can store many pages of information.
In the PowerBuilder Data Window I have the field set to auto size height.
Another thing I have noticed that it prints differently on different
computers, meaning it may print fine on one computer and not on another.