powerbuilder

How *does* Powerbuilder POST work?

Unfortunately searching for 'Sybase Post' doesn't get me the answers I'm looking for. I want to know what the actual function is of POST As in .. procedure lala POST procedure1() procedure2() I'm guessing in the above code, procedure2 would be executed before procedure1, that's fine. But when is it processed? After everything else ...

Two questions about the itemchanged and itemerror events

Within PB6.5.1 and PB9.0: Question 1: In itemchanged event: return 1 In itemerror event: return 3 At runtime,the sequence of events fired is: itemchanged-->itemerror-->itemchanged-->itemerror Why is each event fired twice? Question 2: In itemchanged event: return 1 In itemerror event: return 2 At runtime,the ...

.NET dll from PowerBuilder (10 or 11.5)

If I am looking to reference a .NET dll from PowerBuilder (10 or 11.5), which of the following is the best practice? 1) Register the dll as a COM Object, and use the COM Object via an OleObject 2) Upgrade to 11.5, and convert to PB.NET so that I can actually have blocks of C# in the PowerBuilder code 3) Another method What are some ...

Anyone has a good PowerBuilder Enterprise 10.x book to recommend?

I have been trying to find a good reference book with good hands on example projects to learn from but I can't seem to find any PB10 books out there- On amazon, it looks like it goes up to 9x whilst the newest sybase version is 11 with .NET I'm trying to pick up Powerbuilder as fast as possible and would like to find a good book to lea...

Powerbuilder WebApp Access on my website

I'm running PB11.5. I just upoaded my webapp to my website. Cannot seem to run it from website, but I can run it from my PC. I'm using a MS Access DB. ...

.NET dll in PowerBuilder (as COM) problem with Lists

All, I am trying to access a .NET dll registered as a COM Object with PowerBuilder 10. I keep running into problems where .NET objects return lists. I have built out a very simple class for a proof of concept, and to better explain what I am encountering. See below: .NET: public class ListsArrays { public int[] GetArray() { ...

PowerBuilder 11.5 .NET DLL pbl

I have converted a PowerBuilder application to 11.5 .NET. When it builds, it compiles into a DLL, an EXE and a bunch of “netmodule” files. Are the netmodules necessary for deployment, or just part of some intermediate step? Is there any way to get the compiler to build me one DLL for each pbl (PowerBuilder library)? ...

Telling if a transaction has uncommitted updates

In our application, there's a database update that is committed only after a consequent update is being executed (both using the same transaction, of course). However, we've discovered a rare flow in which the user exits the application before the second update, causing the first to be discarded. I'm looking for a way to recognize this u...

How to count the datawindow computed fields dynamically?

Dynamically how to count the datawindow computed fields and DDDW Fields? is there any functions in PowerBuilder? otherwise we need to take DW Syntax? then parsing... ...

How do I add 2 years to a date in powerbuilder and account for the leap year correctly?

How do I add 2 years to a date in powerbuilder and account for the leap year correctly? We have a medical license application where the user would like the date to go expire two years. Current license date is 7/10/2010 and expire date should be 7/2/2012 I used relative date and added 729 if not a leap year and 730 if it was but that i...

Powerbuilder language documentation

Where can I find documentation for the actual PowerBuilder language. I am referring to the kind of code you get when you select "Edit Source" from a right-click menu on the library painter. Not the kind of code you normally write. ...

Full Build, Incremental Build and Deploy within Powerbuilder

What is the difference between a Full Build, an Incremental Build and Deploy within Powerbuilder? The only difference I can see is that Deploy allows you to update the PBDs for, well, deployment. ...

COM - Controls for PowerBuilder

how to use the com controls in PowerBuilder ? If it is used in an application.. how can i identify it? Please help me Thanks in advance ...

Acquire images from scanners from Powerbuilder

I am using EZTWAIN from a powerbuilder application to acquire images from an HP scanner. Recently I tried a Kodak model (i1120) and it seems that it is not supported. Specifically the application freezes during the scanning process (perhaps the problem has to do with duplex scanning). Can you recommend another library that you have use...

Is it possible to use Column Properties in Expressions in Powerbuilder?

Say I have a field on a datawindow that is the value of a database column ("Insert > Column). It has conditions in which it needs to be protected (Properties>General>Protect). I want to have the field background grey when it's protect. At the moment, the only way I can work out how to do this is to copy the protect conditional, no matte...

Powerbuilder V11.2 Memory Leak with Toolbar Items

If a user action is required for a function in my app then the associated icon on the toolbar is made to blink. This blinking is achieved by swapping the toolbar icon for another controlled by a timer event etc. Every time the icon is swapped the memory usage increases by 4K so eventually the app crashes depending on the user's availabl...

PowerBuilder crashes in debug mode by errors inside try/catch blocks

When in debug mode, powerbuilder (ver 10.5) throws application execution error and terminates the application, for errors raised by statements put inside try/catch blocks? For example line 3 below throws, an "array boundary exceeded" error and the application is terminated. How can I overcome this (handled) error and debug the rest of t...

Column names in dynamically generated datawindows

When I dynamically create a datastore using SyntaxFromSQL (in order to generate datastore source code, based on a SQL SELECT statement), with syntax like this string ERRORS, sql_syntax, dwsyntax_str, presentation_str dwsyntax_str = trans_object.SyntaxFromSQL ( sql_syntax, presentation_str, ERRORS) ds_1.Create( dwsyntax_str, ERRORS) ho...

Is there a free diff tool for PowerBuilder?

I do know of a couple of PowerBuilder diff tools that are shareware. But are there any that are freeware or open source? ...

Stored procedure, activerecord, and alternatives?

In a PowerBuilder-based project, there are overs three hundred stored procedures on a Microsoft SQL Server. It's a client-server application which relies a lot on PB's DataWindow. Now, there is an feature request from the users which will most likely add several web-based screens to interface with the system. We are evaluating Rails (f...