Home » Developer & Programmer » Forms » Sql script in Form6i
Sql script in Form6i [message #192431] Tue, 12 September 2006 06:25 Go to next message
magolestani
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 ?

Thanks
Re: Sql script in Form6i [message #192574 is a reply to message #192431] Tue, 12 September 2006 21:32 Go to previous message
djmartin
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.

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


Current Time: Thu Dec 08 20:03:11 CST 2016

Total time taken to generate the page: 0.10631 seconds