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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.