Scribd
Upload
10 views2 pages

PowerBuilder Interview Questions Guide

The document provides answers to several PowerBuilder interview questions, including how to run a stored procedure from a PB app using a DW or DataStore, how to count the number of controls in a window at runtime using the control array, and how to create a dynamic datawindow using the getSQLSelect and setSQLSelect functions along with the create function.

Uploaded by

SANTOSH
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
10 views2 pages

PowerBuilder Interview Questions Guide

The document provides answers to several PowerBuilder interview questions, including how to run a stored procedure from a PB app using a DW or DataStore, how to count the number of controls in a window at runtime using the control array, and how to create a dynamic datawindow using the getSQLSelect and setSQLSelect functions along with the create function.

Uploaded by

SANTOSH
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

More PB Interview questions

1-PB
How do you run stored procedure from a PB app ?
2-Oracle
How do you see people connected to Oracle ?
3-sql Server
What is equivalent of Oracle decode ?

Answers:
1-
It depends wether you want to get a result or not.
If you do not want any result set, you can inherit from
transaction object, declare local external function, and
declare with rpcfunc syntax.

If you want a result set, you can use a DW or a DataStore.

2-
Use dynamic view v$session

3-
Case...When

PB
1.
How can you count the no of controls in a window at
runtime
Ans. PB maintains a control array which contais all
the objects pasted on window. you can access their
properity from there

2.
how can multiple inheritence possible in pb i.e. can
you create a scenario where a descendent have more
than one ancestors.
Ans. Directly not possible, but a trick can do it.
Steps :
a) create a user objects inherited from some other
user object (uo_2 inherited from uo_1)
b) paste this userobject in a window (w_win_1)
c) now inherit another window w_win_2 from w_win_1.

So now you have w_win_2 which is descendent of


uo_1,uo_2,w_win_1

3.
how can you create dynamic datawindow
Ans. See help for getSQLSelect setSQLselect and create
functions

More ll be followed.
You would do well to cover topics such as your last 2 projects,
DW Buffers, Presentation Styles, Get/SetItemStatus(), DW events -
ItemChanged!/ItemError!, the 4-step DW Validation process,
Transaction object, Pipeline, Project painter options,
GROUP-BY/UNION-ALL, Function Overloading/Overriding, differences
between Events and Functions, Variable-scopes/Access-level
modifiers (PROTECTED/PRIVATEWRITE...), some PFC services
such as Linkage, Security, AppManager, RowManager...

You might also like