Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more


Datawindow column change after database change

Posted on 2004-08-18
Medium Priority
Last Modified: 2013-12-26
I have Powerbuilder 5.0 using a database in PostgreSQL. I have a datawindow column whose field width I set to 15 during creation. Now, I want to change it to 100. I can make this change on the database side, but the datawindow does not get updated with this. I tried to 'regenerate' the datawindow, but the change still does not take place. I also have the setting 'Retain Data to Design' checked on in the DataWindow options.
When I try to set the field value to something containing more than 15 characters, for the first time, it adds it. But when I try to add a second such value, it gives me the error that says 'Error Number 6. Error text = Invalid DataWindow row/column specified.' and it gives me the name of the object, function and line in script where it has a problem.
Is it even possible to make the field length change without creating a new datawindow? Incidentally, this works fine, without problem when a Oracle database is used.

Thanks in advance.
Question by:pcasxd0
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Assisted Solution

Vikas_Dixit earned 500 total points
ID: 11835732
You can export the dw and do the change in the .srw file and import it back.
Please remember to take backup of your pbl before trying this.
LVL 18

Accepted Solution

diasroshan earned 500 total points
ID: 11838405
the solution is kinda crude/funny but it always works and the problem u've posted is very common....

open ur datawindow and go to the sql view of the datawindow(SQL syntax)....
now u can see the sql statement of ur datawindow....
remove any comma and would give an error of incorrect add the comma and return to ur datawindow the datawindow...ur problem is solved!!!

check the column specification of ur it should show 100 in the 'type'...

do ask if u need more assistance...


Author Comment

ID: 11843543
Hi VikasDixit,
Thanks for the answer. I'll try and do that.

Hi Rosh,
Thanks for the answer. The problem with PostgreSQL is that it does not open the SQL view in the PB datawindow. When we click on the SQL icon in the toolbar, it simply hangs. I don't know why this is. When the database is Oracle, the SQL Editor gets opened without problems.  Your solution does sound interesting, though! Thanks.

I'll try this out and grade pretty soon.
LVL 18

Expert Comment

ID: 11849404

the problem stated by u is a bug in PB5...
"The problem with PostgreSQL is that it does not open the SQL view in the PB datawindow. When we click on the SQL icon in the toolbar, it simply hangs"

DONT live with it... its a bug and many other such bugs which can be solved by applying the relevant patches...

go to

---> go to the download option
---> in the download page there is a link EBFs/Maintenance
---> u will be asked to register once u go to that link....
---> register onto sybase(this will help in future)...its free
---> there will be a selection of time 'all'
---> now when u search u will find 'PowerBuilder - PowerBuilder 5.0.04 EBF#3
'---> Download it
Install this patch and many of ur errors will be solved...

do ask for more assistance...


Author Comment

ID: 11856752
Vow, really, that's a great tip. You might have guessed by now that I'm a total newbie here. I will certainly do that download. I thought that there was no way around it.
VikasDixit: Since I like both answers, I'm going to split the points.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.
Suggested Courses

648 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question