Devlopers Plz help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Devlopers Plz help

  1. #1
    Join Date
    Jun 2001
    Posts
    56

    Hi friends
    In field data stored 123456.
    I wanna create EIGHTY (80) text items in control block,
    and select 1 from data through substr(id,1,1) and store in first text item,
    But problem is that i wanna store 2 like that with loop

    1
    1 2
    1 2 3
    1 in first text item when second number retrieve store 1 in second text item and 2 in first text item like that EIGHTY (80) text items.

    Plz help me bcoz its urgent.


  2. #2
    Join Date
    Jan 2001
    Posts
    153
    TYPE store IS TABLE OF XXXX ROWTYPE
    INDEX BY BINARY_INTEGER;

    variablestore store;
    var1 := length(urfield1);


    for i in 1..var1
    loop
    storeme := substr(var1,i,1);
    variablestore(i) := storeme;
    end loop;

    from here take on..
    Vijay.s

  3. #3
    Join Date
    Jun 2001
    Posts
    56

    Sir I can't understand
    Plz sir write in easy we
    What type and level of trigger i apply ?
    In control block text item names are A1 to A80.
    I select data from id column and numbers table.
    Data is only 123456 and one row only.

    How i can store that data in text items like scrolling of numbers?
    Thanx in advance.

  4. #4
    Join Date
    Nov 2000
    Posts
    245

    looks like you want multi-rows, just add 2 lines in the loop:

    for i in 1..var1
    loop
    storeme := substr(var1,i,1);
    variablestore(i) := storeme;
    --
    insert into xxx values(storeme);
    commit;
    --
    end loop;

    xxx is your table name


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width