Home » Developer & Programmer » Forms » Sql script in Form6i
Sql script in Form6i [message #192431] Tue, 12 September 2006 06:25 Go to next message
Messages: 16
Registered: October 2005
Location: Iran
Junior Member

Hi there,

I want to make a sql script file in Forms6i and then run it in Forms6i , too.

I want to make my script file by this query:

select 'grant '||privilege||' on '||table_name||' to USER2;'
from USER_tab_privs where grantee='USER1'

What can I do ?

Re: Sql script in Form6i [message #192574 is a reply to message #192431] Tue, 12 September 2006 21:32 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use the 'host' command to run the script on the server and then use 'text_io' to read it back. Search this forum for the keywords mentioned.

Previous Topic: about d2k
Next Topic: Libraries
Goto Forum:

Current Time: Mon Oct 24 02:53:33 CDT 2016

Total time taken to generate the page: 0.14622 seconds