Recent content by rjoshi2

Her are some of my computed fields: 1. sum(if( main_record_status = 'A' , 1, 0 ) for group 2) 2. count(itd_no for group 1) 3. count(itd_no for all ) Should I expect any problem with these? Any help would be appreciated. Thank You, rjoshi2

Thank you for you help it was situation 2 so I just change the name of the dblink and it is working now. - rjoshi2

question am I getting this error because I have not changed the tnsnames.ora on the database server: CREATE PUBLIC DATABASE LINK "GMLINK" CONNECT TO "DEMO" IDENTIFIED BY "sysadmin" USING 'DEMODB' ; select REPORT_TYPE from report_picture@GMLINK...

I have two database demo and cns. In cns I have a procedure cmtest. In this procedure I want execute a function, which belongs to a package in my demo db. How do I set up the dblink to do this? How to do I call the function? Any help would be appreciated. Thank You, rjoshi2

The problem that I am having is that I am getting different result when run by project in powerbuilder and run it from an exe. I am trying to retrieve a psr from my oracle database (blob). Save it to local hard drive and then display it. It works fine when I run the project in powerbuilder I see...

The reports that I trying to view that have been generated by a powerbuilder (6.5) mini application that save the report as a psr then inserted into a table (as blob on a oracle 8i db). The problem is when the mini application save the reports as psr the computed objects looses the data. I only...

The problem that I am having is when I save my report as a psr I am loosing the data of my computed objects. For example I have a computed object that is 7000 in my report. I save the report as a psr. When I open the psr the 7000 is now a 0. Any help in fixing this problem would be appreciated...

My question is how could I execute an oracle stored procedure in powerbuilder? My stored procedure requires two input variable. I am using oracle 8i and powerbuilder 6.5. Any help would be appreciated. Thank You, rjohsi2 My oracle procedure: CREATE OR REPLACE PROCEDURE insert_photo...

(1) I have tried to set a transaction object so I can retrieve and display a blob in a data window. I am not sure what is going wrong with my code. Could some please tell me what I am doing wrong. The program keeps crashing at line 2: SQLCB.DBMS="ODBC" //Error: empty sting (2) Do I...

Is it possible to write code that will change the driver that we are using to connect to our oracle 8i database? The reason I am asking is I am trying to retrieve blob in my powerbuilder 6.5 application but the Microsoft drivers do not support blob. I would like to switch to the oracle driver to...

PowerObject, I have you inserted the PSR file itself into the dB. I have been successful in viewing the psr report. My question is how could you insert the image of the PSR file? Could you post an oracle/powerbuilder procedure/function that will insert the image of the psr? Thank You, rjoshi2

(1) My question is how do I display (in a datawindow) the report once it has been written to the file and then read by powerbuilder? (2) Do you have to use the oracle driver (ODBC) to use the BLOB data type? Any help would be appreciated. Thank You, rjoshi2 My Code: blob b_file_pic, b...

PowerObject, Could you please tell me what you mean by var (variable)? What type of variable do I retrieve the blob into? Thank You, rjoshi2

I have inserted a psr report as a blob in my database (oracle8i). I have not been able to view this report in powerbuilder. I have been able to view other formats (wmf, gif) that I have that I inserted as blob. Is it possible for powerbuilder 6.5 to display psr reports (how)? Thank You, rjoshi2

Dan, If possible could you post an example? How long would it take the application to retrieve the “file” (blob) from the database? Thank You, rjoshi2