Even if you are running on SQL server (instead of Progress) there is no 'SQL" to see for most of the views used in vantage apps.
They are compiled progress 4GL constructs (even on SQL server).
Time Phase is a good example of that... It's a pretty straightforward progress app (basically a report displayed on screen) and it entirely uses temporary table data that doesn't persist in any way that would allow you to poke in with odbc and do a SQL query.
If you read the Progress 4GL Handbook (available for free pdf download on Progress' site - and very useful to learn how to create more powerful BAQ calc fields), Time Phase becomes recognizable as almost a '4GL 101' example app.
For your problem, I would examine all the transfer order table (TFOrdHed, TFOrdDtl, TFOrdSug, TFShipHead, TFShipDtl, TFShipUPS) records accessible via odbc and compare your transfer orders appearing as still open to ones that were processed clean and cleared out of time phase.
You'll probably find some obvious difference that (hopefully) was a lapse in processing (that can be corrected via the suitable vantage apps) and not corrupted data.
Rob Brown
They are compiled progress 4GL constructs (even on SQL server).
Time Phase is a good example of that... It's a pretty straightforward progress app (basically a report displayed on screen) and it entirely uses temporary table data that doesn't persist in any way that would allow you to poke in with odbc and do a SQL query.
If you read the Progress 4GL Handbook (available for free pdf download on Progress' site - and very useful to learn how to create more powerful BAQ calc fields), Time Phase becomes recognizable as almost a '4GL 101' example app.
For your problem, I would examine all the transfer order table (TFOrdHed, TFOrdDtl, TFOrdSug, TFShipHead, TFShipDtl, TFShipUPS) records accessible via odbc and compare your transfer orders appearing as still open to ones that were processed clean and cleared out of time phase.
You'll probably find some obvious difference that (hopefully) was a lapse in processing (that can be corrected via the suitable vantage apps) and not corrupted data.
Rob Brown
--- On Mon, 8/25/08, Tony Hughes <thughes281@...> wrote:
From: Tony Hughes <thughes281@...>
Subject: [Vantage] Record source of list in Developer Mode
To: vantage@yahoogroups.com
Date: Monday, August 25, 2008, 1:55 PM
If you enter Developer Mode and look at properties of a list or grid, you can see it shows a datasource drop down.
How can you see what the actual SQL is for that data source?
I'm getting strange things in Time Phase (like transfer orders showing up as demand even though they're long since shipped and closed) so I wanted to check.
Thank you,
Tony