Recent content by cywong119

  1. C

    How to invoke crystal report in progress 4GL programm?

    Dear All, I am new in Progress 4GL programming. I am goto develop an application to generate a crystal report for users. First all, I have to retrieve a set of data from Progress Database. Then, put these data into crystal report Finally, display the crystal report to user...
  2. C

    Error "Optional feature not implemented"

    I make use the DSN of Progress ODBC driver to connect to Progress Database in my Visual Basic Programm/Application. Does anyone encounter such error message "Optional feature not implemented" When you issue a sql statement to progress database by using DSN of Progress ODBC. I checked that...
  3. C

    Getting Current Date is SQL

    solution: CURDATE() The similar function of GetDate() in Progress is: CURDATE() Example: INSERT INTO objects (object_owner, object_id, create_date) VALUES (USER, 1001, CURDATE()) ; Good luck! P.S. You can find all progress database functions in Electronic Documentation.
  4. C

    How to set isolation level at run time?

    Dear All, I make use the DSN of Progress ODBC driver to connect to Progress Database in my Visual Basic Programm/Application. For generating reports, I need to set the Isolation Level of the DSN to "Read Uncommitted" so that user can view all data of table A while other users are updating...
  5. C

    ODBC Error "Error in Row"

    Dear all, After issuing a query "Select fieldA from TableA" through ODBC, the ODBC return a error "Error in Row". I find that when userA are updating/deleting/adding record to TABLE A and userB are retrieving record from Table A at the same time. Then userB receives "Error in Row"...
  6. C

    ODBC Error "Error in Row"

    Dear all, After issuing a query "Select fieldA from TableA" through ODBC, the ODBC return a error "Error in Row". I find that when userA are updating/deleting/adding record to TABLE A and userB are retrieving record from Table A at the same time. Then userB receives "Error in Row"...
  7. C

    ODBC Error "Error in Row"

    Dear all, After issue a query "Select fieldA from TableA" through ODBC, the ODBC return a error "Error in Row". I find that when userA are updating/deleting/adding record to TABLE A and userB retrieving record from Table A at the same time. Then userB receives "Error in Row" error. It...
  8. C

    data type conversion

    Dear All, I am new in progress. could anyone tell me how to change a character data type into a integer type in SQL statement? I have try the following statement, but it fails. select cint( pub.tableA.fieldA ) from pub.tableA pub.tableA.fieldA is in character type, I want to...
  9. C

    what's wrong with my progress procedure?

    Dear All, I create a progress procedure called myprog.p. My procedure is to run a external program in progress procedure. When I try to run this programm, it prompt error. I am not very familiar with progress 4GL program. what's wrong with my progress procedure? I have no idea...
  10. C

    SQL question: how to concat two different data type fileds into one ?

    Help please! Could anyone advise me how to concatenate two fields into one in progress SQL? My SQL statement is as follows: select pub.tableA.fieldA || pub.tableA.fieldB from pub.tableA pub.tableA.fieldA is character type pub.tableA.fieldB is integer type Of course this SQL...
Back
Top