Home » Developer & Programmer » Forms » database option !
database option ! [message #259583] Thu, 16 August 2007 00:52 Go to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hello All,

What is the use of database option(Tools- Preferences- Access- Database)in Forms 6i?
and how to use it? I am trying to use it but not understanding what it does exactly?

Please guide.
Thanks.
Re: database option ! [message #260755 is a reply to message #259583] Mon, 20 August 2007 19:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In older versions of Forms it was quite common to store the forms in the database. To do this you needed to run a script which would create the required tables.

This feature is typically no longer used.

David
Re: database option ! [message #261378 is a reply to message #260755] Wed, 22 August 2007 07:26 Go to previous messageGo to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hello David,

How to store form in the database.What is exactly use to store in the database.Where I have to go in database to see the form, I am using form6i.
I want to understand it.Can you give some steps to use this option.
Please give some steps.

Thanks.




Re: database option ! [message #261482 is a reply to message #261378] Wed, 22 August 2007 14:34 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Forms 3.0 was (one) of the "older" versions David mentioned. Here's how it worked: when you created a form (blocks, items, triggers, procedures, ...), you could SAVE it to the database and generate the executable (FMX) file. Source was also stored in the (editable) FMB file (this extension remained till recent versions).

When you revisited the form, you had two options: first was to OPEN it from the database, the second one was to LOAD it from the FMB file.

I don't remember which tables were used to store forms; I'll try to connect to one of the old databases and find that information if you are really interested in it.
Re: database option ! [message #261868 is a reply to message #261482] Thu, 23 August 2007 21:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Can anyone find a link to the Forms installation manual?

David
Re: database option ! [message #261924 is a reply to message #261868] Fri, 24 August 2007 01:25 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which Forms installation manual, David? 3.0?

I've searched for tables I mentioned in my previous post; here they are (SYSTEM is the owner):

FORM_APP_
FORM_BLK_
FORM_COMMENT_
FORM_FLD_
FORM_MAP_
FORM_PAGE_
FORM_PROCEDURE_
FORM_REFERENCE_
FORM_SQLTXT_
FORM_TRG_
FORM_TRIGGER_
FORM_USER_

Re: database option ! [message #262385 is a reply to message #261924] Sun, 26 August 2007 21:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I can't find any reference to these tables in the latest Forms documentation. Nor are there any 'sql' files in the latest Forms documentation, and it was via 'sql' files that tables were previously created. There isn't anything useful on 'google' either.

David
Re: database option ! [message #266296 is a reply to message #261482] Mon, 10 September 2007 07:10 Go to previous messageGo to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hello,

Please give more details,yes I am really intrested to do this
task.

Thanks!
Re: database option ! [message #266299 is a reply to message #266296] Mon, 10 September 2007 07:22 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that more details is that there are no more details.
Previous Topic: ORA-03106 fatal two-task communication protocol error
Next Topic: Previous window disappears when another one is opened.
Goto Forum:
  


Current Time: Tue Dec 06 16:14:08 CST 2016

Total time taken to generate the page: 0.09313 seconds