This content has been marked as final. Show 2 replies
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.
Gul wrote:Yes. you can. use FORMS_DDL built-in. For example
can we create a view or a table with a form push button using forms 6i?
if yes what will be the command?
Hope this helps
BEGIN Forms_DDL('create table temp(n NUMBER)'); IF NOT FORM_SUCCESS THEN Message ('Table Creation Failed'); ELSE Message ('Table Created'); END IF; END;