Recent content by idingsdale

Well that was embarrasing :D Have got that working (I think!), under "Statement cache information" it lists what I assume are progress files, such as: ip-window-view xxxxxx.w dispatch xxxxxx.w Presumably the next step is to interrogate those files as one of them will contain the relevant query?

Excellent I'll have a look! Dont think so, even if I did I wouldnt have a clue what to do with it! :) It's not exactly a small app either I dont have those options :( My protop looks like: 1. User Control 2. Locking and Waiting Statistics 3. Block Access 4. Record...

Also, I'll ask in here rather than creating another thread! I fancied having a look at ProTop to do some digging around in the database too, have tried running it from a client (win 7) with prowin32 dbname -H host -S service -p protop and from the server (win 2003) itself with prowin32 [path...

Thanks Tom, Could you give me a bit more information about how I would go about that, or point me in the right direction for documentation?

My starting point is a Windows GUI application with a Progress backend. I need to figure out where certain data is coming from

I want to find the name of the table and column ideally. I know I could ask the vendor, but I prefer the tools to be able to do it myself :) With MS SQL I'd use query profiler, open or update a window in the front end and examine the queries to see whats going on

Hi All, I'm looking after an application running on Progress 10.2B I'd really like a way to track down where certain frontend fields exist in the database - I've used SQL Profiler with SQL server before for this purpose. Is there an equivalent for Progress?

Its the same as any other ODBC data source - create a DSN, test it and then you should be able to use it in VS. I figured out my query problem in the end, the secret is to use the current date as a select parameter - the final query turned into this: SELECT DISTINCT...

I'm doing some work on a Progress 10.1A database, connected by ODBC to a .NET application in Visual Studio 2008. My SQL query is returning survey responses and looks like this: I want to be able to return surveys for jobs completed in the past 4 weeks, but no functions such as "select...

Thanks for the response, its reassuring to know I'm not the first to do this! Do you know where I might find the DoubleTake user group as I cant see anything on the website.. After playing with Progress in a VM, I think I understand a bit more how it all works. My plan at this stage is to...

Hi, Thanks for your reply. Doubletake is replication software, it replicates files as they are changed at the block level. DoubleTake have said they can support Progress, but not if the DB is in "Direct IO mode" as the DoubleTake service does not see the writes to disk. As the replicated...

Hi All, I'm pretty new to Progress, so apologies if any of this seems obvious. We have a couple of databases on Progress 10.1A and want to replicate them to an off site server over a WAN link. Progress Replication is too expensive and as part of our wider DR strategy we wil be purchasing...