powerbuilder

How to keep variable value between function invocations in PowerScript?

In one of my function objects (a global function) I'd like to transport the value of a few variables from one invocation of the function to the next. In C or C++ I'd use the 'static' keyword here. I could be using global variables but that's quite ugly and it makes it hard to import this function into other PowerScript objects; I'd like...

How to use the OpenOffice spell checker in PB Application with OLE Object?

I am using OpenOffice in my system and already I tried about it, also i got the solution from the CodeExchange examples but i couldn't get the spell checker. ...

Reading for loop in PB 10.0

In winodw open event I have coded a script and I have used certain "for" loops.Now i have to create a button and when clicking the button all the for loops should be read or copied to a text file.. I am working in Powerbuilder 10.0 version Can u pls help me? ...

Getting the spid of a Powerbuilder database Connection?

I've been trying to find some manual information on this, but my search is fruitless. I'm trying to see if there is a way to find the unique spid (from sp_who) of a connection into a database from Powerbuilder. As in, a user logs in, and I can see their sp_who record, but I want to be able to obtain and manipulate this id in the applic...

How do you get a PowerSoft report to resolve a PowerBuilder global function.

I currently work in an environment where reports must be emailed to users as a PowerSoft file. There is a global PowerBuilder function which is used on a computed column my datawindow. This datawindow becomes the final psr report. In my testing the function is resolved fine, when run live. However, when the user runs the report, it se...

RTF Datawindow and RTF Control Content how to find the text by color, Font name?

i stored the RTF file format in my ASA database. How to select the content by using the color or Font name, Alignment. for ex: i have a content it has 100 lines with formatted text in between it contains the text which is in blue color, i need to select dynamically by giving the color "blue" is it possible? ...

Accessing Powerbuilder in ASP.NET

I have a Powerbuilder file (9.0) with reports (data windows) that i'd like to pass data to and print out of ASP.NET. Is this possible? If so, any guidance? (I don't know Powerbuilder.) I am currently duplicating the reports in Crystal Reports because it's something i know, but it's tedious to maintain these reports in two place to say t...

PowerBuilder 10.5 sample web services client application

I am trying to get the PowerBuilder 10.5.2 sample web services application running. I can open the workspace just fine, and I can see the objects and even run the app but I get a "bad runtime function reference" error when I try to invoke the service. I believe I have installed all the requisite parts: PB 10.5.2 .Net 2.0 SDK Web sea...

Integrating with Calendars - From database application

We develop a small business database application with PowerBuilder. Part of the functionality includes scheduling appointments (a secretary schedules an appointment for her doctor via our application). The scheduling appointment is stored as a database record and viewable/editable via our application. Pretty standard stuff. We would...

Going to jump into Powerbuilder. Any advice.

This might be a weird question. After all, most people want to jump OUT of PB not IN. However, after careful analysis, I feel that Powerbuilder can get things done so much more rapidly than C# in the sense its a 4GL. Now PB is becoming .NET enabled, I was thinking perhaps its a good tool. My main focus is developing enterprise applica...

Power builder DSN Creation

I am new to Powerbuilder. I want to retrive the data from an MSAccess tables and update it to curresponding SQL tables.I am not able to create a permanent DSN for MSAccess because i have to select different MSAccess files with same table informations.I can create a permanent DSn for SQL server. Please help me to create s DSN Dyanamical...

WPF: Analyse XamlParseException from UserControl in .dll

Hey guys, I have a custom WPF UserControl in a DLL file. I access the UserControl from PowerBuilder via OleObject (COM). I'm trying to create an instance of the UserControl (code in .NET dll). Everything works fine when I'm using it via COM from C++, but in PowerBuilder, I'm getting this error message: Error Message Can you help me to...

Powerbuilder beginner question

Hey Everyone, I'm working at a company as a entry-level developer. I'm having a hard time wrapping my head around the power builder concepts. Any good tutorials/advice? ...

PowerBuilder GUI to web application - best options?

Does anyone have any opinions on the best options for converting a PB GUI application that I sell to users to be a web app? (The web app would be run on my servers, not the clients' servers.) It seems there are a number of options. One is to use PB 11's ability to retarget an app as an ASP.NET WebForms app, but I really don't understand...

PowerBuilder: Determine a data windows primary key

I'm creating some events in a base object (class) in PowerBuilder, and the descendent's of this base datawindow need to know what the primary key of that table (or row) is. How would you determine the primary key in code? ...

Tool bars in PowerBuilder

I have created the tool bars, i can pick it as a separate frame bar (as a floating window) and also i can close it. But i couldn't bring this again. if it so i need to re execute the application then only it will show... otherwise how can i bring this frame bar again?. PB Version 10. Build 7516 Thanks in advance ...

Powerbuilder: Trying to set the currentitem for a menuCascade

Please clue this newb in. I've got a menu with it's object type set to menu cascade. I can reference the items in the menu just fine and I can even st the items to enabled or visible. But what I can't do is set the currentItem property of the menu. I have code like this in the open event of a screen. menu qq qq = this.menuid.item[3].it...

How do I get the PowerBuilder graphicobject for a given HWND handle?

In my (PowerBuilder) application, I'd like to be able to determine the graphicobject object which corresponds to a given window handle. Simply iterating over the Control[] array and comparing the value returned by the Handle() function for each of the child controls doesn't work, since not all objects in my application are children of t...

How to convert the enumerated value as a string value?

i am taking the property list of PBObjects/Controls. So i need to take the property. I got the property values throug variable definition. for ex vd_def = cd_def.variablelist[li_i] vd_def.name vd_def.initialvalue // if this initial value is enumerated, then how can i get this value please help me. Thanks in advance. ...

How to make PowerBuilder UI testing application?

Hi. I'm not familiar with PowerBuilder but I have a task to create Automatic UI Test Application for PB. We've decided to do it in Python with pywinauto and iaccesible libraries. The problem is that some UI elements like newly added lists record can not be accesed from it (even inspect32 can't get it). Any ideas how to reach this elemen...