Recent content by cywong119

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...

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...

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.

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...

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"...

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"...

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...

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...

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...

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...