Results 1 to 2 of 2

Thread: forms 6i problem

  1. #1
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    forms 6i problem

    To update rows in a Table ,i gave Table name dynamically but it is not woking in forms 6i.
    ex:
    Lvstring:=UPDATE testsum t SET t.pr_sm_cfch=(SELECT t.pr_sm_cfch+b.pr_sm_cfch FROM ' ||' '|| Tablename ||' '|| ' b WHERE t.pr_sm_tokn=b.pr_sm_tokn AND (T.PR_SM_PERD,T.PR_SM_TOKN) IN
    (SELECT MAX(PR_SM_PERD),PR_SM_TOKN FROM pr_wsum_yr
    GROUP BY PR_SM_TOKN) AND t.pr_sm_mode='||''''||'W'||''' AND b.pr_sm_mode='||''''||'W'||''')
    WHERE t.pr_sm_mode='||''''||'W'||''' AND (T.PR_SM_PERD,T.PR_SM_TOKN) IN
    (SELECT MAX(y.PR_SM_PERD),y.PR_SM_TOKN FROM pr_wsum_yr y
    WHERE y.PR_SM_MODE='||''''||'W'||''' GROUP BY y.PR_SM_TOKN)
    AND t.pr_sm_tokn IN (SELECT pr_sm_tokn FROM'||' '|| t ||' '|| 'WHERE
    pr_sm_mode='||''''||'W'||'''' ;
    forms_ddl(Lvstring) is not working for Update . What command i need to use
    pls suggest me.


  2. #2
    Junior Member
    Join Date
    Oct 2007
    Answers
    4

    Re: forms 6i problem

    What message is appearing while updating this?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact