Search results

  1. M

    Question Search all columns of all tables

    Hi All in MS SQL, I can search all columns for a given value (e.g. %test%). Can I do the same with Progress (using SQL)? Regards mark
  2. M

    Help with QueryPlan

    Hi Guys I'm a total noob and using 64 bit ODBC driver to query 10.2B SP06 (can't apply any other SP's as it's a 3rd party vendor product and that's the latest they certify) from SQL client (SSMS, RazorSQL, etc.). Queries are really slow and I'm trying to figure out what the issue sis. Read...
  3. M

    Why does a SQL query take so long to detect invalid col name

    I'm using OpenEdge 10.2A with 64 bit ODBC driver and linked server in SQL Server 2008 R2 I run a SQL query that spans 5 tables (probabaly a few thousand rows in each and all inner joins). Query completes in 15 secs (need to improve, but it will do for now). If I mis-spell ONE column name, it...
  4. M

    Total Noob to Progress - Need help with tools

    Hi Guys We just acquired a company who has a manufacturing system that runs on Progress (OpenEdge 10.2B) -- that's what their OBDC driver says. I have no experience at all with Progress of 4GL (nor does their IT guy) and have been tasked with integrating their accounts system with Microsoft...
  5. M

    SQLServer 2008R2 to Progress OpenEdge10.2

    Hi Guys We just acquired a company that has some apps running on Progress. We're a Microsoft shop and need to query the data from SQL server (in the short term). We have the following ODBC drivers installed on SQLServer, but they don't show up when I try to add a link server, or as a provider...
Top