Search results

  1. S

    Date format

    Hi, Yes, for instance while preparing an input file to upload some data into a table. You never know which format to use untill you try a test run. Thanks. Subhransu
  2. S

    Date format

    Hi, I wonder if a date can be stored in some different format than it appears on the screen. In other words, if a date is shown as dd/mm/yyyy, how can it be stored in mm/dd/yyyy format in a DB. Secondly, can two different date fields in a table have different formats such as dd/mm/yyyy and...
  3. S

    SLQ-92 equivalent

    Hi, What is the SQL-92 equivalent of "Sequences" in ABL database? In other words, how can we setup sequence in a progress non-ABL database? Thanks. Subhransu
  4. S

    Understanding Webspeed

    Hi, Is there any PPTs available which will be easier to unserstand the concepts of Webspeed? Thanks. Subhransu
  5. S

    Error Handling

    Thanks for this info. However I am using 9.1e. Is there any other way around?
  6. S

    Error Handling

    Hi All, I would like to know if there is a way to capture the error message without using NO-ERROR and ERROR-STATUS:GET-MESSAGE(n)? Thanks. Subhransu
  7. S

    Field Validation not working

    Hi, I tried putting a simple validation in "Field Validation Dialog Box" in DB Dictionary for a perticular field. e.g. for CustNum : custnum > 0 But it does not work as expected when inserting data using CREATE and ASSIGN statements. It seems the validation option is not working. Please...
  8. S

    SonicMQ Connection Error

    Hi, I am trying to connect to SonicMQ 6.1 from OpenEdge 10.2B. But while executing "run beginsession in ptpsession.", it is throwing the below error. "Application Service adapter.progress.jms not found at NameServer at Host 127.0.0.1 Port 5162. (8245)" I tried copying the files at...
  9. S

    SonicMQ Connectivity

    Hi, I had installed SonicMQ 6.1 in my machine. But I wonder how to connect Progress AppServer to SonicMQ? Also how can I execute a program to parse the incomming XML through SonicMQ? I am also not sure if SonicMQ6.1 is compartible with OpenEdge 10.2B. Please assist. Thanks. Subhransu
  10. S

    Use of Sequence from JDBC

    Hi All, How can we use the progress "sequence" while inserting a record into Progress DB through JDBC? Thanks. Subhransu
  11. S

    SQL-92 error while executing SQL query

    It worked. Thank you Sir. :)
  12. S

    SQL-92 error while executing SQL query

    Hi, I am able to connect to Sports.db through JDBC connection but could not able to execute "Select country from customer" from the java code. It is throwing the below exeption. [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519) Please let me know how can I...
  13. S

    Run Progress Code from Java

    Hi All, Is it possible to run a Progress 4gl code from Java with the introduction of OpenEdge 10.2B? If not, what are the otherways to acomplish similar requirement? Thanks. Subhransu
  14. S

    prowin32 and progress.exe

    Hi, Would some one tell me the difference between prowin32.exe and _progres.exe? Thanks. Subhransu
  15. S

    Capture the PID of a session

    Hi All, I am trying to capture the PID of my session. Is it possible to do so?
  16. S

    Logic behind temp-table

    Hi, If records are being fetched into local record buffer when we select them, how come we can see the columns of the records in the browse? Thanks. Subhransu
  17. S

    Logic behind temp-table

    Hi all, I would like to know (in a client server environment) how does a browse intrenally work when it runs the query. That is how the records are fetched, where are the stored, whether all the records are fetched etc.? Thanks. Subhransu
  18. S

    Load-Testing

    Hi All, In our production environment, the number of users are supposed to be up by 2000 in few months. Currently we have 3000 users who login to the system. We need to validate whether our system is capable to take the load? So how can we simulate this programatically? We would not like to...
  19. S

    Lock Wait Timeout

    Hi All, I need to capture all the lockwait timeouts in the application (both foreground and background). How would I do that? Thanks. Subhransu
  20. S

    Concurrent Reads

    Hi All, I would like to know what happens when a user tries to fetch a record in NO-LOCK which is being modified by another user at the same time but not been comitted till then? In other words, whether the user who wants to read that record will get a record which is not logically consistent or...
Top