Search results

  1. A

    Query taking too long to run

    Hi guys i'm running a query which isn't too complicated but is taking a lot longer than I would expect to run, its suming the value of sales orders (there are over 200,000 in the db) invoiced in the current month I'm not sure if i were to order the where clause of my query differently it would...
  2. A

    Show orders below % margin

    Hi guys , i'm struggling with some of the basics of S92. I'm trying to display all orders below a certain margin in a given month and year. Not sure if i'm missing something in my layout of the calculation thats giving me the syntax error, can anyone see anything glaringly obviously wrong with...
  3. A

    S92 Inner Join

    Hi guys , sorry this one might be a bit simple , tried to avoid Inner Joins in Progress but now I want to try one out can't get the syntax right. Could someone point out my error please Select name From Pub.arsc Inner Join Pub.oeeh on arsc.custno = oeeh.custno where cono = 1 Error I'm...
  4. A

    Unable to connect to Progress datasource with ASP

    Hi guys , been using simple ASP to connect to an MS Access database for applications on our company intranet. Our order entry server uses progress, I can connect to this using the ODBC built into MS Access for VB applications etc I've never been able to connect to the live datasourece...
Top