| How to convert files saved in tally software to html or excel file [message #123195] |
Fri, 10 June 2005 08:39  |
krish23
Messages: 18
Registered: June 2005
Location: India
|
Junior Member |
|
|
Can anyone answer me the following
How to convert files saved in tally software to html or excel file?
What is the difference between pre insert and on insert triggers?
what is the hierarchy of triggers in forms?
What is a pll? and how can we attach it to forms?
What is a object library? what is the use of it?
|
|
|
|
| Re: How to convert files saved in tally software to html or excel file [message #123572 is a reply to message #123195] |
Tue, 14 June 2005 00:31  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I have not worked with 'tally' and this question has been asked before. Google it.
To create an excel file use 'csv' format and write the output as a flat file using utl_file or text_io (depends on which version forms you are using - search this forum for previous references to the two packages).
Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Form Builder Reference'. Download it and search for 'pre-insert' and then 'on-insert'. Basically the first is used to do 'things' before inserting into an Oracle database and the second is to do things into a non-Oracle database.
Hierarchy can be found in the Oracle doco. but tell us what you are doing and we can give a more directed answer. Basically the 'pre-' triggers happen in 'form' then 'block' then 'record' then 'item' order and the 'post-' triggers happen in 'item' then 'record' then 'block' then 'form' order.
A 'pll' is an Oracle object to hold PL/SQL which contains embedded forms commands, that is, code you can't store in the database. Use the 'attached libraries' facility to attach a pll to your form (always say 'yes' to the 'remove path' question).
Objective library can store property information and when referenced by a set of forms permit the global changing of features by the simple act of changing an object characteristic and then regenerating all the referencing forms ('inheritance').
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
