PowerBuilder Datawindow Bug

Folks,

I just wanted to follow up with the work-arround I did on a PowerBuilder
8.0.3.9704 and SQL Server 2000 (latest patch) bug.  The bug lies in the MSS
database driver.

Basically PowerBuilder truncates any string comprosed entirely of spaces to
the empty string as it retrieves from the database to the datawindow.

The solution for me was to wrap any candidate column with this scenario with
a non-blank string (I used the string '##'), and then after datawindow
retrieve, loop through datawindow, and remove the string from each side of
the queried columns.  Tons of overhead, and incredibly slow, but hey, its a
work around.

Anyone who has the ins with Sybase can pass along this bug, if you would be
so kind.

Thanks.


Phil


0
Phil
11/7/2002 8:43:53 PM
sybase.powerbuilder.datawindow 28057 articles. 5 followers. Follow

1 Replies
1064 Views

Similar Articles

[PageSpeed] 4
Get it on Google Play
Get it on Apple App Store

Phil
If you feel this is a bug please report it to Sybase using the case 
express feature on their website.  It is free.  And they can follow up 
with you if they have any questions.

Michael Walker
Cascadia Software



Phil Kaufman wrote:

> Folks,
> 
> I just wanted to follow up with the work-arround I did on a PowerBuilder
> 8.0.3.9704 and SQL Server 2000 (latest patch) bug.  The bug lies in the MSS
> database driver.
> 
> Basically PowerBuilder truncates any string comprosed entirely of spaces to
> the empty string as it retrieves from the database to the datawindow.
> 
> The solution for me was to wrap any candidate column with this scenario with
> a non-blank string (I used the string '##'), and then after datawindow
> retrieve, loop through datawindow, and remove the string from each side of
> the queried columns.  Tons of overhead, and incredibly slow, but hey, its a
> work around.
> 
> Anyone who has the ins with Sybase can pass along this bug, if you would be
> so kind.
> 
> Thanks.
> 
> 
> Phil
> 
> 
> 

0
Michael
11/7/2002 9:55:35 PM
Reply:

Similar Artilces:

Powerbuilder datawindow
Hi! 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 datawindow. 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). Jan Erik > If a row in the...

Powerbuilder Datawindow
Hello, Can you do a Datawindow in VS 2005 without using Datawindow.NET just by using common controls i.e DataGrid etc. Thanks Chris 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: >Hello, > >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 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...

PowerBuilder V10.5.1.6565 datawindow bug
Dear Jim, 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 V9.0.2.3420. 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. thanks 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. Larry "Murat Yelkovan" <muratyelkovan@yahoo.com> wrote in message news:43181629$1@forums-2-dub... > 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 error. Do anybody know similar problem occuring in PB9 or earlier version? Any solution, is it a reported bug? Thanks in Advance VSV John, What was the prior build that you used? Reason is we are using 9.0.1.7151 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? Thanks, 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 painter, PowerBulider gets down. Someone told me that changing default printer might help. But it didn't help. Please help me. Thanks. Several suggestions: 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? Thanks JBachman jbachman@worldnet.att.net -----== 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
Hello group! 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 similar sample. I have a poor English,hehe. thanks very much. Infomaker? -- Chris Keating 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 implementation. 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? TIA, Oliver Oliver wrote... > We are still maintaining an old Power++ based application, > which makes quite exten...

PowerBuilder DataWindow #2
Hi all, 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 update end if 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 the data". 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. S...

Web resources about - PowerBuilder Datawindow Bug - sybase.powerbuilder.datawindow

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 11/30/2015 8:00:46 AM