Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rjoshi2
  • Order by date
  1. rjoshi2

    Computed objects/psr

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

    dblink

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

    dblink

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

    dblink

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

    Run/exe problem with psr computed objects

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

    Computed objects/psr

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

    Computed objects/psr

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

    Oracle stored procedure

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

    BLOB/Driver Question ????

    (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...
  10. rjoshi2

    BLOB/Driver Question ????

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

    psr help ??

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

    psr help ??

    (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...
  13. rjoshi2

    psr help ??

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

    psr help ??

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

    BLOB HELP ???

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

    BLOB HELP ???

    How can I insert a file as a blob?
  17. rjoshi2

    BLOB HELP ???

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

    BLOB HELP ???

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

    trim

    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]
  20. rjoshi2

    SYSTEM DATE

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

Part and Inventory Search

Back
Top