Home » Developer & Programmer » Forms » Getting query from rdf file
Getting query from rdf file [message #282313] Wed, 21 November 2007 08:16 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
hi,
i am using form 6 and want to read query from rdf file at runtime , do anybody have some idea


thnx in advance
Re: Getting query from rdf file [message #282390 is a reply to message #282313] Wed, 21 November 2007 16:45 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea. But, what will you do with query once you extract it from RDF file?
Re: Getting query from rdf file [message #282405 is a reply to message #282390] Wed, 21 November 2007 22:45 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
basically i am developing an ERP , and need to buffer the data of specified reports after lets say every 20 minutes into an excel file.
Re: Getting query from rdf file [message #282417 is a reply to message #282405] Wed, 21 November 2007 23:30 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
When you said 'read query from rdf file at runtime' did you mean 'read the parameters that were used when running the report'?

When you said 'need to buffer the data of specified reports' do you, again, mean 'buffer the parameters that were used when running the report'?

David
Re: Getting query from rdf file [message #282418 is a reply to message #282417] Wed, 21 November 2007 23:34 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
1. if i can get query of a report from .rdf , than i can simply write the data to excel file after specified intervals

or

2. i am not talkin about parameters , it has to be actual data
Re: Getting query from rdf file [message #282429 is a reply to message #282418] Thu, 22 November 2007 00:04 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
For me:
Query=SQL, data=result lines

Agreed?

David
Re: Getting query from rdf file [message #282432 is a reply to message #282418] Thu, 22 November 2007 00:11 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

write the data to excel file after specified intervals

Why wouldn't you (instead of such an unusual operation of extracting a query from a report and doing something with it in a form) simply schedule a job which would create a report?
Re: Getting query from rdf file [message #282440 is a reply to message #282313] Thu, 22 November 2007 00:20 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
@ djmartin

Agreed

@littlefoot

what can i say, it is the requirement from my boss......

basically the problem is that, sometime the connection is lost at the plant ( ERP for a cement company) and the work is interupted . So i order to avoid the interuption in work i need to buffer some data in excel file , so that data can be used and work not interrupted even if connection is lost.

Regards
Re: Getting query from rdf file [message #282442 is a reply to message #282440] Thu, 22 November 2007 00:24 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You said "need to buffer the data of specified reports after lets say every 20 minutes into an excel file". Do you mean KEEP the last 20 minutes worth of data in an excel file?

David
Re: Getting query from rdf file [message #282444 is a reply to message #282440] Thu, 22 November 2007 00:26 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Another idea: how about creating a materialized view in the plant database which would refresh periodically and enable you to view data, nevertheless the connection to the remote database is established or not?
Re: Getting query from rdf file [message #282445 is a reply to message #282313] Thu, 22 November 2007 00:27 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
@ djmartin
yes

@ littlefoot

materialized view will be the last option as my boss alreadyt rejected it, anyways thnx

[Updated on: Thu, 22 November 2007 00:33]

Report message to a moderator

Re: Getting query from rdf file [message #282451 is a reply to message #282445] Thu, 22 November 2007 00:51 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
How are you running this report?

Have you considered have a 'dbms_job' which runs a PL/SQL deck every 5 minutes and creates a new copy of a '.csv' file?

David
Re: Getting query from rdf file [message #282472 is a reply to message #282313] Thu, 22 November 2007 01:47 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
but i still need to get the sql query from rdf file, and then i am going to the same thing
Re: Getting query from rdf file [message #282477 is a reply to message #282472] Thu, 22 November 2007 02:06 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does it mean that there are several reports involved (so you'd extract a different query every time) or that report's query is being changed frequently (so you have to extract its new copy every time)? Because, a simple one-time "copy-paste" technique would work, right? But that's obviously too simple.
Re: Getting query from rdf file [message #282497 is a reply to message #282313] Thu, 22 November 2007 03:04 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
yes , there is more than one report
Re: Getting query from rdf file [message #282639 is a reply to message #282497] Thu, 22 November 2007 19:28 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay, change all the reports so that they first write the output to the Excel file and then use that file to create the paper copy. Alternatively, as the paper reports are working, add a 'pre-report' report that produces the Excel file. That way, if the link fails during the second part of the process (writing the existing paper report) then the local Excel copy is available already.

David
Re: Getting query from rdf file [message #282664 is a reply to message #282313] Thu, 22 November 2007 22:50 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
@dj martin
do u mean that i use rpt2xls.pll for writing the report to excel.
Re: Getting query from rdf file [message #282669 is a reply to message #282664] Thu, 22 November 2007 23:32 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
No idea. Never used it. I was thinking of writing a script that produces a 'csv' file and running it before the current report is called.

David
Re: Getting query from rdf file [message #282670 is a reply to message #282669] Thu, 22 November 2007 23:34 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'rpt2xls'. There are a few interesting threads.

David
Re: Getting query from rdf file [message #282672 is a reply to message #282313] Thu, 22 November 2007 23:40 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
yes i have read it, but its like hitting ur head on the wall when bringing the excel file to same format as in report
Re: Getting query from rdf file [message #282676 is a reply to message #282672] Fri, 23 November 2007 00:00 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Then write the output as a flat file using 'text_io'. Why does Excel have to be used?

There would be a flat file per reprot and if you wish to you could keep hyperlinks to them in an Excel file.

David
Previous Topic: Very Basic User Form
Next Topic: My ifrun60.exe opens then immediately closes
Goto Forum:
  


Current Time: Mon Feb 17 18:31:05 CST 2025