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

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:46:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.