Recent content by Subhransu

  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?
Top