2 Replies Latest reply: Apr 1, 2013 8:22 AM by HamidHelal RSS

    can we create a view or a table with a form push button?

    875255
      can we create a view or a table with a form push button using forms 6i?
      if yes what will be the command?
        • 1. Re: can we create a view or a table with a form push button?
          Paul M.
          can we create a view or a table with a form push button using forms 6i?
          Said that I don't think that's a good idea, did you try viewing help in Forms builder ? Those are DDL commands, so if you search DDL in Forms builder help you can see

          DDL (Data Dictionary Language) commands, such as CREATE TABLE and DROP SEQUENCE, can be issued by calling the FORMS_DDL built-in procedure. Be aware that FORMS_DDL built-in always issues an implicit COMMIT_FORM after executing the desired statement. Consequently, FORMS_DDL built-in should be called only when the application does not have unsaved changes pending that the operator might want to subsequently undo.
          • 2. Re: can we create a view or a table with a form push button?
            HamidHelal
            Gul wrote:
            can we create a view or a table with a form push button using forms 6i?
            if yes what will be the command?
            Yes. you can. use FORMS_DDL built-in. For example
            BEGIN 
              Forms_DDL('create table temp(n NUMBER)'); 
              IF NOT FORM_SUCCESS THEN 
                Message ('Table Creation Failed'); 
              ELSE 
                Message ('Table Created'); 
              END IF; 
            END; 
            Hope this helps

            Hamid