Search results for query: *

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

...IDENTIFIED BY "sysadmin" USING 'DEMODB' ; select REPORT_TYPE from report_picture@GMLINK; select REPORT_TYPE from report_picture@GMLINK * ERROR at line 1: ORA-02085: database link GMLINK.US.ORACLE.COM connects to DEMODB.US.ORACLE.COM

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

...+ 1 END IF ELSE loops = 1 END IF // Write the file new_pos = 1 FOR i = 1 to loops b_file_pic_temp = BlobMid(b_file_pic, ((32765 * i) - 32765 + 1), 32765) bytes_write = FileWrite(li_FileNum, b_file_pic_temp) NEXT DISCONNECT USING SQLCB; end if //This example reads a file...

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...

...dbms_lob.loadfromfile(b_photo,f_photo, dbms_lob.getlength(f_photo)); -- close the photo's pointer. dbms_lob.fileclose(f_photo); -- Save the loaded photo record. COMMIT; EXCEPTION -- Check for your error messages WHEN others THEN dbms_output.put_line('*** ERROR *** Check you procedure.'); END;

(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

How can I insert a file as a blob?

More info: I am trying to store powerbuilder reports (.psr file) in the database (as blob). That can be retrieved by a powerbuilder application. Thank You, rjoshi2

Could some please post an example of creating a table with a column that is a BLOB? Also post a sample of how insert a BLOB into that table? Thank You, rjoshi2

My question is how can you trim the data in array? Any help would be appreciated. rjoshi2 Sample: Trim the values in ls_code any ls_code[] string ls_flag int li_count li_count = 1 ls_code[] = dw_flags.object.code_value.data.selected ls_flag = ls_code[li_count]

This seems to work: DateTime ldt_date Date ltd_sys_date ldt_date = DateTime( Date("Dec-31-2099") , Now()) ltd_sys_date = Date("Dec-31-2099") if year (date(ldt_date)) = year (date(ltd_sys_date)) then UPDATE MAIN SET YTD_NO = nvl( YTD_NO , 0 ) + 1, YTD_AMT = nvl(...