Home » Developer & Programmer » Forms » DBF file creation from oracle 10g forms (Oracle 10g and oracle forms 10g)
DBF file creation from oracle 10g forms [message #434087] Mon, 07 December 2009 02:51 Go to next message
murugub
Messages: 7
Registered: December 2009
Junior Member
Hi,

I have to create a DBF III file based on a oracle query result. It can either through oracle form 10g or PL/SQL. Is there any solution to achieve this

Thanks in advance
Muruganandhan

[Edited by LF: after topics have being merged, the most descriptive message text was copied into this message, while the others have been deleted]

[Updated on: Mon, 07 December 2009 06:37] by Moderator

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #434267 is a reply to message #434087] Tue, 08 December 2009 04:12 Go to previous messageGo to next message
arni111
Messages: 6
Registered: December 2009
Junior Member

you can do everything with Forms and PL/SQL
Ok , not everything, but in this case u can.
read the manual for FORMS_DDL

by example

Declare
req Varchar2(1000) ;
Begin
Req := 'Insert into ....' || the_bind value || .... ;
Forms_ddl( req ) ;


Regards
Arni
Re: DBF file creation from oracle 10g forms [message #434299 is a reply to message #434267] Tue, 08 December 2009 07:58 Go to previous messageGo to next message
murugub
Messages: 7
Registered: December 2009
Junior Member
FORMS_DDL is used for issueing DDL commands to database through forms, how can we use that for creating a DBF file. Can you please explain in detail

Muruganandhan
Re: DBF file creation from oracle 10g forms [message #434306 is a reply to message #434087] Tue, 08 December 2009 08:25 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
What do you need explaining?
Do you know the syntax to create datafiles?
If so what is stopping you issuing the command via forms_ddl?
Re: DBF file creation from oracle 10g forms [message #434354 is a reply to message #434306] Tue, 08 December 2009 22:50 Go to previous messageGo to next message
murugub
Messages: 7
Registered: December 2009
Junior Member
I am not asking about oracle datafile creation. I am asking about DBF III file format(Dbase file).
Re: DBF file creation from oracle 10g forms [message #434426 is a reply to message #434087] Wed, 09 December 2009 04:12 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you know how to create a DBF III file without using oracle?
I've got no idea what the structure of such a file is and I kind of doubt anyone else on this forum does either (I might be wrong).
If we know what form the data is supposed to have we could probably help.
Re: DBF file creation from oracle 10g forms [message #434555 is a reply to message #434426] Wed, 09 December 2009 12:43 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is, I suppose, dBase III. I had had a tiny application, but I don't think I knew anything about file structure. Thanks Google, here it is.
Re: DBF file creation from oracle 10g forms [message #435170 is a reply to message #434087] Mon, 14 December 2009 22:43 Go to previous messageGo to next message
murugub
Messages: 7
Registered: December 2009
Junior Member
Any clues on this?
Re: DBF file creation from oracle 10g forms [message #435180 is a reply to message #435170] Tue, 15 December 2009 00:33 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What "clues", exactly? Would you like someone to do the programming for you?
Re: DBF file creation from oracle 10g forms [message #435707 is a reply to message #435180] Thu, 17 December 2009 08:35 Go to previous messageGo to next message
murugub
Messages: 7
Registered: December 2009
Junior Member
I am not expecting someone to programming for me. I just need some clue to how to achive this. "clue" in the sense, some sort of steps to create a DBF III file.

Anyway thanks for your response....
Re: DBF file creation from oracle 10g forms [message #437541 is a reply to message #435707] Mon, 04 January 2010 23:46 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This discussion has moved to http://www.orafaq.com/forum/m/437540/67467/#msg_437540

David
Previous Topic: Copy Functionality in Custom Form
Next Topic: direction of canvas
Goto Forum:
  


Current Time: Wed Sep 28 22:53:56 CDT 2016

Total time taken to generate the page: 0.05491 seconds