Recent content by weiwei

  1. W

    Progress Result records count different after exporting.

    Anyone use Progress Result? Result is imbedded in our Student Mangement System called Skyward which uses progress database. I try to use Result to make a query and export it to text file and automate the process. But in Result, if I view as browse, and then click the Count button, I can see 7000...
  2. W

    Odbc

    We use crystal reports 10. odbc driver is Merant 3.60 32 bit progress SQL 92 v9.1 D
  3. W

    Server not reachable or possible RPC error

    Thank you, do you mean it's table joins cause the problem. Is there any way that I can find out which join that cause the problem? Thanks
  4. W

    Odbc

    I've already searched the knowledge center of progress, and tried all possible ways, but no luck at all
  5. W

    Server not reachable or possible RPC error

    DO you have the solution now, I have the same problem? Thanks
  6. W

    Odbc

    We have a crystal report for student report. It runs OK before, but recently after I run it, it takes much longer time, if I run for a student, it takes 8 minutes, and generate the report, but if I run a grade level, it will keep running and gives error: Querry engine error: 'HY000...
  7. W

    failed to open a rowset

    :( Using Crystal Reports 10 with outer joins produces syntax error Failed to open Rowset ODBC progress driver Progress Syntax error (7587). How can I fix this? Thanks
  8. W

    today's date Progress database sql syntax

    thanks Thank you, it's very helpful
  9. W

    today's date Progress database sql syntax

    does now() include hours, minutes? It's good only with date, for that's paramenter when user enter Thanks
  10. W

    today's date Progress database sql syntax

    I'm creating a report using a report builder tool on progress database, how can I use filter to make the date as today's date? For example: schooldate=today's date? Thanks
  11. W

    check if a user is a dba or not

    dba questions Thank you for all. We are K12 enviroment using application SKyward which is using Progress database. I use odbc connection Access database find out in the sysdbauth I cannot find that user name we thought we have created. But we did create it, and we test it from ODBC it can...
  12. W

    check if a user is a dba or not

    New to Progress, I'm creating a crystal report with connectection to progress db. We created an ODBC user connecting to Progress database. we granted the user DBA rights. But today when we test it, we can link the database, tables,but we cannot open the tables, it says failed odbc user...
Top