OraFAQ Forum: Forms » DBF file creation from oracle 10g forms

Home » Developer & Programmer » Forms » DBF file creation from oracle 10g forms (Oracle 10g and oracle forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBF file creation from oracle 10g forms [message #434087]

Mon, 07 December 2009 02:51

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

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

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #434299 is a reply to message #434267]

Tue, 08 December 2009 07:58

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

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #434306 is a reply to message #434087]

Tue, 08 December 2009 08:25

cookiemonster
Messages: 13920
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?

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #434354 is a reply to message #434306]

Tue, 08 December 2009 22:50

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).

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #434426 is a reply to message #434087]

Wed, 09 December 2009 04:12

cookiemonster
Messages: 13920
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.

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #434555 is a reply to message #434426]

Wed, 09 December 2009 12:43

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #435170 is a reply to message #434087]

Mon, 14 December 2009 22:43

murugub
Messages: 7
Registered: December 2009

Junior Member

Any clues on this?

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #435180 is a reply to message #435170]

Tue, 15 December 2009 00:33

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What "clues", exactly? Would you like someone to do the programming for you?

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #435707 is a reply to message #435180]

Thu, 17 December 2009 08:35

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....

Report message to a moderator

Re: DBF file creation from oracle 10g forms [message #437541 is a reply to message #435707]

Mon, 04 January 2010 23:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

This discussion has moved to http://www.orafaq.com/forum/m/437540/67467/#msg_437540

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 21:17:29 CDT 2024