>>My entire application is working smoothly, but there's always that one last unexpected thing....I get the error...
>>
>
>I have a feeling that your problem is stemming from the view that is based on other views...
>
>possibly the reason that it works from the project manager is that the dbc is included in the project and is always open when the prokect is open? Do you have views that span dbc's?
>>>>>>NO, I only have one dbc
Do any of your 'nested' views share common source tables?
>>>>>Absolutely - see below:
The view I'm having problems with is "Finance_Report"
It is based on the following:
1. Travel_Orders (a table with travel orders for the employee)
2. Finance_Travel_View (two tables: Travel_Orders and Dependent_Travel, to link the dependents traveling with the employee)
3. Kwaj_Arrivals_and_Departures (a view created with SQL inside a .PRG due to its complexity. The view designer couldn't handle it. This takes the itinerary_details file and extracts only the arrivals and departures for Kwajalein (we don't print the entire itinerary on the travel order form - this form is regulated and not subject to change). The code for this view is pasted below:
create view kwaj_departures as;
select *;
from "travel!itinerary details";
where travel_from = 'Kwajalein';
order by depart_date;
create view kwaj_arrivals as;
select *;
from "travel!itinerary details";
where travel_to = 'Kwajalein';
order by arrival_date
create view Kwaj_Arrivals_and_Departures as;
select;
nvl(kwaj_departures.travnbr, kwaj_arrivals.travnbr) travnbr,;
kwaj_departures.depart_date,;
kwaj_departures.carrier departure_carrier,;
kwaj_arrivals.arrival_date,;
kwaj_arrivals.carrier arrival_carrier;
from kwaj_departures full join kwaj_arrivals;
on kwaj_departures.travnbr = kwaj_arrivals.travnbr
*******************************
Now, I need all that information to print out. It does it without skipping a beat on the report I designed in the report designer. This is wonderful, but our Finance Department wants to tweak it and do their own financial analysis, therefore the requirement for Excel output.
I put Do finance_report.prg in a menu option for the application to split it out. If I run it before opening any forms, it does great, but the form won't come up because the file is already in use. If I get out and run the form first, it comes up like a champ, but then the report won't run because either the table can't be found, is already in use, etc.
**********************************
Can you help?
Sorry my first message wasn't clearer, but I really didn't have a clue at the time it could be the views. Actually, I was beginning to wonder how to get a private data session for a .prg.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement