Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating SQL8 tables in FORMS DEVELOPER

Status
Not open for further replies.

taqmeena

Programmer
Mar 22, 2005
53
0
0
PK
i have created a software that consits of 13 Tables.
to create these tables in SQL i have saved a Text file Named Tables.SQL . whenever i wish to create these table on the pc i run the command in the Sql8 Prompt.

Start D:\Tables.sql
this command creates all the Tables.

my requirement is to create these tables from the backend of a First Welcome form of A Application.
when the First Time welcome form appears the command above is autogenerated from that welcome form.

2nd :- how to Log on The Sql user from the form builder so that the user just knows the password of users tables that is created by me behind first Welcom Form. and users did get the knowledge about orginal sql user which user is log on.

 
1st - Use FORMS_DDL.

2nd - You can find out the current username and password using GET_APPLICATION_PROPERTY.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top