powerbuilder

Migrating from Powerbuilder 6.5 to 10.5

Hi, We have an application that is built using PFC. I am facing a strange problem. When I define a workspace and open only the PFC librares, I can migrate and do a full Build. However, when I include this in my application library, it will not build, and gives me an error stating C0001: Illegal datatype s_printsetupattrib. This error ...

Is there any powerbuilder function which is equivalent to PHP's "explode" function

I think the title itself is pretty self-explanatory. Is there any function in powerbuilder which is equivalent to PHP's "explode" function? For PHP's "explode", see the following link : PHP explode ...

PowerBuilder Related Error

I am getting an error while updating data in the data window,which says,Row changed between retrieve and update.What is the soltuion? ...

Tool to find PowerBuilder objects that are not in source control

I work on a large PowerBuilder project with code spread over 58 PBLs. As you can imagine, it's a pain to go through all of the libraries to check the source control status. Our VC tool, Serena VM /TrackerLink doesn't remove objects from the PBL when they're deleted from source control. They're usually harmless, but they come up in search...

Powerbuilder : what does this computed field formatter mean

Hi, I have a computed field, whose format is specified as follows - #,##0.00;[RED](#,##0.00);# By format, I meant the format value that we can set from the property of the computed field(in the format tab). What does this format mean? ...

Can't insert newline in msword form field using Powebuilder OLE

Hi, I have an application written in Powerbuilder 11.5 that automatically fills in form fields of a Word document (MS Word 2003). The Word document is protected so only the form fields can be altered. In the code below you can see I use char(10) + char(13) to insert a newline, however in the saved document all I see is 2 little squar...

Powerbuilder : How to write validation expression for a field

Hi, I have a datawindow containing multiple fields. I want to write a validation expression for a field named amount. I have another two fields named debit and credit. If the sum of debit and credit is greater than amount, then I want to show a validation message to the user. How can I write the required validation expression in the Co...

Datawindow field : accept only positive numbers

I want to make a datawindow field accept only positive numbers. How can I do that? Edit I know I can validate the column using column specification's validation expression system. But is there any format available which I can put into the Format property and be done with it? ...

Powerbuilder PFC : Where to start learning

Ok, I am an absolute beginner in powerbuilder. Currently I am working in a company where powerbuilder is being used to develop an application. This application heavily uses PFC. Now I had no prior powerbuilder training when I joined this company, but I learned a few things while working in this application, e.g., datawindow, powerscript...

Migrating powerbuilder 6 program to powerbuilder 10.5

Hey, I was just wondering if anyone knows a good way to go about taking a program made in powerbuilder 6 and converting it to powerbuilder 10.5 Any suggestions? ...

powerbuilder: itemchanged event doesn't trigger while changing focus

I have a master-detail window. In the detail window when I change a field and click on the master window, the focus changes but the itemchanged event of the detail datawindow isn't fired. Now I want to fire the itemchanged event when the focus changes from one datawindow to another datawindow. P.S.: The itemchanged event is only firing ...

Is there a way to connect to an ASA database with Powerbuilder without deploying the ODBC or OLEDB drivers?

What I want is a Powerbuilder application that runs on Windows that runs from a CD (or some other external disk) that can read from an ASA database whose file is located on the same disk. But I want to do so without deploying the ODBC or OLEDB drivers. That is, I do not want to have to copy the driver files to the client's hard disk or...

Does Adaptive Server Anywhere not support subqueries in the FROM clause?

I am trying to execute an SQL query on an Adaptive Server Anywhere database. Here it is: SELECT count(*) AS s FROM ( SELECT column1, count(*) AS n FROM table1 GROUP BY column1 HAVING n > 1 ) In the subquery, I want to get all the rows that are duplicates and in the outer query I want a count of the rows that are dupli...

PowerBuilder and Visual Studio files in same StarTeam project?

We have a system that is largely written in PowerBuilder 11.5 and we are using a single StarTeam project to hold the source code. Now we are wanting to add some related websites developed in ASP.NET with Visual Studio 2010 to source control as well. We would like them to be able to share the same set of Change Requests as the PowerBuil...

Add event to dynamically declared control

This is a PowerBuilder question. I'm using PowerBuilder 12 Classic. I have a window in which most of the controls are declared dynamically in code using OpenUserObject. When one of these controls is clicked, a panel should open in the container window. However, I'm not sure how to trigger an event from a dynamically declared control....

PowerBuilder 12 vs Visual Studio - Designer support

I have control designed for VS2008 and VS2010. Will it work in Power Builder 12 designer as well? or Would I need to create any design.dll ...

Creating Pdf file in Powerbuilder

Hi Friends, I am new to powerbuilder. I got a assigement Create PDF file using Powerbuilder. ...

Pass timestamp between Powerbuilder datawindow and SQLServer insert/update stored procedure

Hi, can anyone help me out. By implementing countermeasures in solving the concurrency problem I got troubled with passing timestamps (rowversion) between Powerbuilder 7 datawindow and SQLServer 2008 (both ways) using insert and update stored procedures. The connection is serviced by ODBC, not native. Most of my attempts result in cas...

Powerbuilder: How can I specify current date as initial value for a datawindow field

Hi, I have a datawindow where I have a date field. I want to specify an initial value into that date field when a row is retrieved from the database. From the Column Specification, I want to set the initial date value of that field to current date. Is there any keyword or function which I can write in the Initial Value field? ...

Does DataWindow .NET use connection pooling?

Does or can DataWindow .NET take advantage of connection pooling? ...