Recent content by akenty

The following can be used to accomplish what you need. You can also combine this with the timer event in order to display the window you are using as a flyover. ls_object = this.GetObjectAtPointer() ls_row = Right(ls_object, Len(ls_object) - (Pos(ls_object,'~t'))) ls_column = LEFT(ls_object...

Hi, having problems receiving an HL7 transmission from a third party through a socket transmission. Listening port connects fine, can receive the first transmission and process fine, but the second one is held up. Here is the code: public void run() { DateFormat dateFormat...

To correct the problem, I used the available() method. It seems that the read() could not detect the end of the file, but the available() was able to see that there were no more bytes to be read. Just speculating that is what is happening, I'm a little green to java. while (nextByte...

Hi All, I've tried a number of different ways to read an inputstream and cannot get the -1 for the end of file to trip. Stepped through the code and got to the final carriage return in the stream, but when the next read() is performed, the code goes into neverland. Does not produce an error and...

Hi All, I'm having problems copying rows from a datawindow to a datastore using the RowsCopy function in PB 10.5 (was working fine in PB8). Error is an unhandled win32 exception. Both the DW and the DS use the same dataobject. I do dynamically add columns to both the DW & DS in the application...

Hi All, wondering if anyone has had problems running the application through PB 10.5. Have no problem starting it the first time, but when I go and make changes to anything in the app and then go to run it again, PB 10.5 shuts down. No error message, just closes PB completely. Open up PB and can...

Hi All, Brand new to Oracle. Installed XE and can log into two different schemas where I have defined the same table. Now I would like to set up replication between the two DBs. Is this even possible? Looked high & low for documentation but could not find anytyhing related to XE & replication...

If you are using the PFC, there is a progressbar in there that you can use.

Hi All, Using SHBrowseForFolderA as an external function to allow the user to browse to a directory. What I would like to do is start from a specific directory instead of from the default (currently starts off at My Computer). Any help would be appreciated. Thanks in advance.

Hi there. Do not know of a way to use the word spellcheck without having word pop up, but we are using a third party product to incorporate into our PB app. We are using TE Editor from SubSystems Inc where you drop the OLE object onto your window and can do whatever you want to the...

Hi there, Since loading java 1.5.0_03, I cannot get DbisqlG to run. It looks like it is firing up and is present in the list of processes in the task manager, but it does not run. No problems running DbisqlC. Would anybody know how to set up my path so that I can get DbisqlG to run again? Thanks...

If you can open up the DB in DBISQLC or DBISQLG, all you have to do is: SELECT * FROM table_name; OUTPUT TO 'c:\file_name.txt' FORMAT ASCII; Then open up the text file in Excel and you should be good to go. Hope this helped.

I was able to truncate a table in a stored procedure using the following: EXECUTE IMMEDIATE 'TRUNCATE TABLE tablename ';';

Found a work around for the problem (developing in Powerbuilder) by excluding the final select from the stored procedure. I set up a dummy DW (in this case, the columns had to be defined as strings) where I modified the select to a SELECT * from the newly created temp table. The table name is...

Hi All, I am dynamically creating a temp table and it's columns and loading a file into it using a stored procedure. Everything is working swimmingly until I do the final select for my result set where I receive an "Illegal cursor operation attempt". Here is the sql for the stored procedure...