Top Solutions

sorry, my inglish is very poor. I Speak Spanish

Well

The problem is :

I have a DataWindow with any columns,  second column is the name and I want
find any name in the DataWindow.  I put the Single Line Edit and the Modify
Event Write...

I am getting the following error message in PB 9.0
It does not occur consistently, so it's difficult for me to debug and find out why it's happening.

Powerbuilder Application Execution Error (R0002)
Application Terminated.
Error: Null...

The Executable(exe) along with all the PBD's is created using the Project build option in PB6.5,When the exe is run it gives the following error.
Application Terminated
Unresolvable External (object) when linking reference at line...

Hi,
I have a problem with "run" function.
When I use this function to call an external program, it runs the external program, but does not wait external program to end.

Is there any solution for this problem.
Best regards.

I'm using PowerBuilder to write send email script using SMTP(Outlook 2007). But, the problem is when I try to execute the script, the error like  'Error accessing external object property server' were appeared at this sintax : o1.Server =...

Dear All,

First of all, sorry if my english is bad.

I am a new user in PowerBuilder.

Currently I am using Power Builder Ver. 9

I've fiew questions about saving a data window in PDF Format :

1. Can u give me a brief and clear...

Hi,
I would like to convert a string into a date (or datetime actually) using a given format.

My problem is actually the following:
I'm developing an application which reads the content of log files produced by other applications.
The...

Hi All,

I got this error message suddenly this morning:
error loading library.
please check whether PowerBuilder accessibility library can be located in the path

I'm not sure what to do since i always left my workstation on all the time...

Can anyone get me link to free eBOOK for Power Builder and good sites for PB resources. Its kind of urgent.

I have 2 versions of PowerBuilder on my System.  V. 7.03 and Version 9.03 (I beleive..its build 8511).

I have an application that works fine in 7.03 and upgraded to 9.03.  Things were going swimmingly for a bit but now there is an issue with...

Hi everyone and thanks for your help to date!!

I have a right click event on a datawindow that is supposed to open a new window with a list of available resources.  I thought it was working fine.  Then I tried it at home and it seems to be...

Experts,

I have a small problme that I am trying to fix. This is the scenario. I have several tab pages. When I click on say tab 2, I want the tab page to open up, with the cursor on the first field of the tab page. Also, note that there is a...

I have written the following code :


string ls_xx_id, ls_yy_id
blob emp_pic, lb_blob
//The below will be OLE_FileName
String ls_filename
integer i,li_FileNum
long  ll_max
//DataStore ds_blob
n_ds ds_test
ds_test = Create n_ds ...

I have a database in Sybase Adaptive Server. I want to change my database to case-insensitive option. I went through the below steps to change the database to case-insensitive option.
(1) Go to Server Config Editor of Sybase
(2) Click...

i want to create a function let call it pic9 which will do the following action
 - it will have two integer values as argument (lets call it  numb, size)
 - it will return a string which will have length=size and it will contain numb right...

Hi,

i have an ole object i_ole_ie connect on Webbrowser Internet Explorer.

By clicking on a row of a datawindow i executed the folow script:

if i_ole_ie.isalive() then
      i_ole_ie.quit()
      DESTROY i_ole_ie
end if
i_ole_ie = CREATE...

Hi.

I need som help building a function retrieving values from different sequences (oracle)

//as_sequence is a string parameter f.ex FV_SP_MSG_MSG_STATE

ls_sql = "select " +  as_sequence + ".nextval into :ll_id from dual"

EXECUTE...

I am running PowerBuilder 10.5 and the files are on a different drive (D:) than the location on which they resided on the machine where they were originally built.   Selectling "Library list" in the target shows the correct location for each of...

Hi Here is logic in detail
--------
ini file entries

[CLV]
;DBMS=MSS
DBMS = ODBC
DataBase=GFS
ServerName=HQDBDEV1
DSN=Dev1
-------------------
I created DSN with following steps

1) From Control Panel odbc icon is clicked.
2) I...

Hi,
PB 10.5

I have a datawindow on a window that gets populated based on criteria that a user chooses.  I need some way of letting the user select certain rows that need to be deleted. I was trying to put a checkbox on the datawindow so that...

My company uses an old ERP system that is no longer in active development.  It uses a SQL backend and does a fairly good job for the need of my company.

Years before my employment my company used some consultants to mod the ERP package.  One...

How would I go through a list of Nodes to parse out the values using SelectNodes or SelectSingleNode? We're using PB 10.5 and I dont mind using PBDOM or using the Microsoft version as in my example here, just need to loop through the nodes.

In...

Hi,
     I have PBD and EXE of the application,we are using 6.5 version of powerbuilder.and database as SQL SERVER2000.Is it possible to get the PBL from PBD'S and application exe.


Thanks & Regards
Sanika

Hi

In employee table I am saving employee's pictures in the table.

While using updateblob and selectblob it is working fine.

Now I want to display the list of employees in the datawindow and want to display the pictures comming from blob...

How to do date arithmetic in powerbuilder ?.

i wanna subtract and add with a given date ?

Version PB 9.0.1

i have a datawindow grid with about 90 columnsthat retrieves records and when a user clicks on a row it should highlight.
i have the following in my clicked() event for the dw:

      dw_report.selectrow( 0, FALSE)
      dw_report.selectrow( row,...

I need a small soap client pb app the example file did not work for me I also have a wsdl file please help and I have powerbuilder 11.5 classic

Hi,

Top of the morning to you.

Ok I've got a powerbuilder app that sits on a sybase database. What I've got is 2 datawindows in a parent/child relationship. When changes to the child are written back to the database, a trigger runs that...

Hi there.
I want a way to retrieve a list of all the files in a chosen directory or folder.

Pretty much any format will do, although something like an array of filenames and metadata such as dates would probably be the best.

The overall...

Hi

I want to get the row sequence against the group in datawindow.

I am using getrow() datawindow function but it returns the total rows in sequece.

Thanks

I use Powerbuilder 10.5 and I want to create/open PDF File from Powerbuilder. PDF File is saved in database in a blob.
It is possible to open this PDF File directly in a window in PB ? saveAs or print of the document?
I can use ActiveX?
Thanks

Looking for a method to import an excel file into a Datawindow.

Essentially there is a file with a dynamic number of records on a daily basis placed on the server.

I need to be able to open the excel file within a datawindow and save it...

Hello all:

I need to use ASCII character 0 as a spacer in a file becuase of the program that uses the file. I tried to use this code:

public subroutine f_writeFixedNumericField (integer outputfilehandle, String text, integer length);
      int...

Hi,
It is me again, still trying to learn all the ins and outs of Powerbuilder.  Really could use an experts help.  I modified a data window but when I go to execute the application, I get a series of errors.  What do I need to do?  Here is a...

HI....
We have a PowerBuilder 10 applications which connects to an oracle 11g database on windows 2003 server, we want enduser to use applications in their PC by shortcuts for application via alocal network (I did the shortcut alredy), their PC...

Thought this was a no-brainer but... I cant seem to open an existing text file.  I can use the Run() command and open notepad.exe but when I try to use the foo.txt file, it wont open.  actually the run returns a -1 .  The goal is to display the...

In my itemchanged event of a datawindow I'm calculating the time difference between two date fields for display purposes.  
Right now it's calculating the time difference and returns the time in hours. For instance, if datetime fields say start ...

Hi,
PB 10.5
I'm getting Powerbuilder Application Execution Error (R0006). Error; Invalid Datawindow row/column specified at line 80 in itemchanged event of object dw_ucc of w_scan_items.

Attached is the code where this error is being thrown....

I am using PB6.5 and oracle 9i (client 7.3)
I create one datawindow with the below SQL
SELECT OBJECT_TYPE,
            (SELECT COUNT (1) FROM USER_OBJECTS
             WHERE OBJECT_TYPE = UO.OBJECT_TYPE AND TRIM(STATUS) = 'INVALID' ) NO_OF_INVALID_OBJ,
        ...

Is it possible to use the windows file open dialog box from a powerbuilder application (like used in Word, Excel, Outlook)?  I know that I can use DirList() and DirSelect() from Powerbuilder to accomplish this but I'd prefer not to build it if I...

Hi

I'm getting this

Creating an instance of the COM component with CLSID {} from the IClassFactory failed due to the following error: ffffdf8f.


runtime error when I try to create a new instance of an class in a dll I have added as a...

I have a user that is occasionally getting a 'Sybase, Inc. Product File has encountered an error and needs to close' message.  We are running PowerBuilder build 11.2.0.8669.   Other users running the same application do not get the error, so it...

Hi All,

I would be grateful for suggestions on the following scenario.

We have a dynamically created datawindow, which is used as a data entry form.
We only ever want one row in this datawindow, but each time the user tabs off
the last...

Hi,

I have a powerbuilder datawindow which generates a report. This report(datawindow) doesn't display anything in the detail band. I have a group defined and I have some columns and computed objects in the group header band.

In the report...

Hello Everyone,

I am trying to create a new column in a datawindow, but it doesn't seem to work.

There are no errors (that I see).

Here is my code:

*****
//dw_1.Modify("create column(1)")
dw_1.Modify("create column(band=detail id=1...

Hi Experts.

In Lotus Notes you can right click a document and from the popup menu choose "copy as link"
This information is stored in the clipboard and can be seen with ClipBookViewer (start - run - clipbrd)

It looks like this:
AKJ - Why...

Hi good people,

Can anybody, please, provide me with a detailed example on how to use PostURL() & GetURL() functions in powerbuilder? The help in PB7 is not clear and I can't get the code to run,

Thanks

I need to use SQL "IN" operator in powerbuilder script. I am storing all the values in an string array.

ex: DECARE cur1 cursor for SELECT empname from emp where deptno IN (:ls_array[]) ;

This above statement is giving compilation error.
...

I am using the Outlook Redemption dll for my email application.  When I try to connect via the ConnectToNewObject("Outlook.Application"), I get a -3 return code.  I guess that this means that the object could not be created.  The code that I am...

I want to open window dynamacially. for the below scenario

I create three child window like w_x, w_y, w_z

in the parent window i hv one dropdown list. its contains values like x, y, z.

If the user select the value x den i want to open...

I am using PB9. In our application one dw have three column "x" "y" "z" and two pict object "P_add" and "p_del". now If I click p_add pict obj then its inserting one row. If i click the p_del pict obj then its deleting current row. I achive this...

i am using powerbuilder 11.5 and crystal report XI  Release 2 with rdc now i want to upgrade to
crystal report 2011. can somebody help me with code example to embade it in powerbuilder application

At some point in my code, I want to programatically trigger a MouseMove event. The parms for X and Y I can get using XPointer() and YPointer() functions. The dwObject is another story. This code could be running for any datawindow. I don't know...

I am using PB6.0, I want to save my report into excel or word in the same form as what I see in the report. Can anyone throw some light on this?

Is there any utility available that converts PSR into Excel / Word formats

Hello,
My Powerbuider application will receive an XML string from another application. This string will contain variety of information which i need to use in my application.But first i need to parse the XML string.
My Question is - How can...

Recently upgraded Oracle 9i on backend.  Testing the PB application we have which is version 6.5.  When trying to do log in on client machine I am getting a ora-06502 error before I even get to username and password.............

Help.. where...

I have a window (w_maint_tables_ext) which is inherits from another window (w_maint_tables).  w_maint_tables contains a datawindow user control (u_dw) from the PowerBuilding Foundation Classes (PFC).  Therefore, there are some additional layers...

Hi,

this is urgent, please

i am trying to connect to the oracle 9i server from my pb application. but i am getting an error DBMS not supported in your current installation. what is the reason for this error?.

i am able to connect the...

I am using PowerBuilder 6.5.  My question has 2 parts. The goal is to create a dropdowndatawindow at run time for one of the columns in a datawindow.

Part 1:
How can I set the dddw for a particular row within the column, while leaving the...

I'm getting an error I have never seen before.

Datawindow error

Select Error: Column lists do not match

I've not seen this error before.

The DW in question had its Owner changed (from DBO), was a Sybase DB, and now is an Oracle 8i...

I am  getting following error message when i trying to connect a remote database server i am trying to connect through Jaguar Manager

Error Message :

Ping of EASDemo ODBC Connection Cache failed: The Ping operation did not complete...

Here is an example of code that I am using to send mail via outlook redemption in my application.  This is tested / working code.  My question is how is it that I may add an attachment to this email?  My initial thoughts were:...

PB 11.2 Build 8616
Windows XP Professional Version 2002 - SP 3

I have 2 datawindows, dw_1 and dw_2, on a tab page. Under normal circumstances a user starts in first column of dw_1 and tabs/enters data. Tabbing off the last column will go to...

Hi!

I need to create a datawindow with several pagebreaks. The number of pagebreaks is not known beforehand.

I understand that for getting a new page I should have multiple reports in the datawindow with enabled newpage. So, the question is...

I want to convert English to Arabic and display in a datawindow report . How is it posible. I am using oracle as database. field is varchar2. In powerbuilder i gave feild font as arial (unicode ms). still i am getting a question mark symbol...

Dear Friends,

Is it possible to pass command line arguments to PowerBuilder Application? If yes how to do it? If no is there any work around for it?

Assume my PowerBuilder Application is "Trial.exe"

if i run it with parameter 1 ->...

I am trying to use Adobe Distiller to convert postscript files to PDFs using OLE automation. My sample script (attached) works fine for a single file using the FileToPdf function in Distiller. However, I will be running this in  a multi-threaded...

Hi,

Created a new exe from source code adopted from 3rd party (& cannot ask questions).  The deployment completes ok but when d-clicking on the exe the following message appears:

Null object reference at line 8 in open event of object mcf
...

Greetings,

I am trying to implement some code I found on this site and I am getting an error.  When I run the code the messagebox displays the contents of the first cell where i=1 and j=1 (This is a merged cell that runs across the top of the...

I need to import the excel file into SQL Database using powerbuilder.
here is what I have so far

OLEObject myoleobject
myoleobject = CREATE OLEObject
result = myoleobject.ConnectToObject( is_filename)


l_row_count =...

I am trying to capture the Current URL in an IEFrame and have so far come up with this code:

ls_window has my current IE window name stored.

Constant Long WM_GETTEXT = 13

L_handle = FindWindowA(0, ls_windowname)

If L_handle > 0 Then ...

Hi all,
I need sample code for using sockets with power builder.

Thanks

Hi,

Iam getting the below error while i used to connect PB6.5 to SYBASE 12.5 through PB
kindly give the solution to slove this problem,

ct_connect(): directory service layer: onternal directory control layer error: Requested Server name...

I am an all microsoft shop but a vlient broght in an old app that has a borland bde database. Is there any delpphi or borland utility or shareware or odbc driver i can download to take a peek at the database?

In this app, I have a hardware device that is sending a byte in through the serial port, I have to "listen" and determine when that byte comes in, grab the data and send a request back.  I would like to know how I can code to determine that data...

Facing an issue when string array is passed as an array to stored procedure (oracle 10g, client oracle 9i) from PB 11.5. After investigation found that it is adding one extra character (NULL) to the end of each element of array. Attached sample...

Hi all,

I need help converting the existing sample VB code to PB.
There is an ActiveX object with type exe (not dll or ocx)
called TestServer.exe

Currently, when this VB program runs, it kicks off this
Activex object (TestServer.exe) and...

I have Created DLL using VB 6.0 which return the name string. Contains 1 parameter, which query and return the name. i have defined in PB as.

FUNCTION STRING GetName(STRING userid ) LIBRARY "Dbinterface.dll"

In VB it works fine.

im...

Hi

I need a Delay function that works in fractions of seconds, may be miliseconds. I've got my own delay function, but only works in seconds.

time ahora

ahora = now()

do
loop until now() >= relativetime(ahora, tiempo)

where...

could you please help me to write a function to generate a barcode with powerbuilder application..

Why IsDate("Jan 1, 95") returns False?

Hi,

how can you send a formated e-mail from powerbuilder  can some one give me an example


thanks
Gajender

Hi everyone,

I know this has been done before, but I can't seem to get the syntax right.

I have a datawindow grid that I created.  I had to pick at least one column to create the datawindow.  I then deleted the first column.  Basically, I...

I have a SQL Server procedure which accepts three params and output is an integer. How do I call (I mean syntax) this from powerbuilder, I want the integer value to be available in powerbuilder into a varaiable. I would like to script it without...

Hi,
I have a datawindow that has a chil dropdown datawindow. In this child dropdown datawindow, I have assigned a Retrieval Argument. I have designed to displaye this child DDW only when the user clicks on a particular column on any row of the...

Dear experts,

I am trying to control MS Outlook using ole automation with Powerbuilder 10 and I would like to
ask for an expert advice regarding ole error handling in general.

I have read the documentation and tried to use the...

I am working on a pair of datawindows that are visible on a window. The upper datawindow has a scroll bar, while the bottom datawindow does not. Both datawindows are using the same datawindow dataobject. The datawindow being used has a header...

Just in the title! HOVER BUTTON!

Dear all
I am newbie to PowerBuilder . I am exploring an existing application so please let me know
What is Datastore Object ?
How it get data from database ?
How i can edit that Datastore object ?
thank you in advance
regards

Hi All,

"A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this?"
I am getting this annoying message when try to send an email.
Is there anyway to get rid of this annoying outllook message?
...

Dear Friends,

I have a problem with Windows Authenticating in my PB 12 classic (not PB 12.Net) application.

What I need is a function, to get the list of AD groups, which are associated with the Windows user.

OR

a function which...

I have a distributed application that appends a file to a file on an AS/400.  Currently, the application builds and executes a batch file that calls Windows 2000 FTP.  I need a solution that will allow me to do the FTP from within my application...

i am trying to execute the following lines of code

        declare  ws_get_arithm  procedure for dbo.sp_get_arithm
        execute ws_get_arithm  
              @scr_flag = '01',
              @scr_etos=2009,
              @scr_seira='01',
              @scr_parast='01',
          ...

How do I change the button option text to "carflowertoy!" instead of default "yesnocancel!" ???

li_rtn = messagebox('Info','Which one do you like ?', question!, yesnocancel!, 1)

Thank you very much !!!

I have a PB 11.5 app that needs to send a certified XML using a webservice. This XML must be validated and I couldn't figure out how to use RSA-SHA1 to fill the SignatureValue.
I tried MSXML, but since I'm new to this, I came to a dead end.
...

Dear Experts

Is it possible to execute Sql Statements(Insert, Update, select) withput login to a database ? using a connection string . I am trying to log all failed / successful logins from a powerbuilder application. I tried the Connect &...

Can anyone please advise if there is a utility available or a simple way of counting lines of code in Powerbuilder applications. We have several applications which we would like count.

Cheers,

Michael

Can anyone guide me to all the sqldbcode values returned from the Sybase server? I need to code for those values in pfc - dberror event - so that I can display some meaningful errors to the users.