Search results for query: *

Hi LimonaM, You can create a parameter and pass the parameter from FORM TO Report Using CREATE PARAMETER LIST,ADD PARAMETER LIST command. But, You should pass this parameter to RUN_PRODUCT command Please let me know on the same. Thanks, Ravi.(ravich_74@hotmail.com)

Hi LimonaM, You have to use Run_product command in the form. It will call the report from the form. In the report, You have to set the DESTYPE,DESTNAME(system mode property) into printer. please let me know on the same. Thanks, Ravi.

Hi, Please find herewith attached solution. update table1 set t1.column = (select sum(t2.column1) FROM table2 t2 WHERE t1.column2= t2.column2 AND t1.column3 =...

Hi bbugs , There is a command called LOGON is available in D2K FORM. You should use this command before going to use the HOST command. syntex: LOGON('USERNAME','PASSWORD'||'@HOST STRING'); HOST('C:\.........'); LOGOUT; Please check it in the D2k form...

Hi Hind, Please you have to add the following code into your program. It will be improve your performance without making any changes on the database side. ----------------------------------------------------------- declaring section T_count number(10); Execution Section...

Hi caskey, Please find herewith attaching the solution regarding your problem. solution 1:- ---------- SELECT A.NAME,B.CODE FROM TABLE1 A,(SELECT DISTINCT ID,VALUE,CODE FROM TABLE2 WHERE VALUE = 'S') B WHERE A.ID = B.ID(+); (or) SOLUTION :- 2 -------- SELECT A.NAME,B.CODE FROM...

Hi Sujosh, Please to find and use the following script. It will be useful to eleminate the if..then..else statement in your code and it is also to increment to 1. SELECT nvl(max(trans_seq_num),1)+1 into ltrans_seq_num FROM pv_trans ; please let me know on the same. Please contact...

Hi all, The following query is not depending on id. It is the dynamic one. Please take this. SELECT a.col_a,a.col_b,a.col_c FROM table1 a WHERE nvl(a.col_c - (SELECT max(b.col_c) col_c FROM table1 b WHERE b.col_c < a.col_c...

Hi bholm, Please find herewith attaching my query with solution. It is the best one. DELETE FROM my_table WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM my_table GROUP BY SUBID,USERID); Please let me know on the same and please let me the feedback to the following id...