Search results

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi, I would like to know whether a database block only contains records of one table or different tables? Thanks. Subhransu

Hi, I believe that a read-only browse does not fetch all the records at a time which meet the criteria. But if that is correct, I would like to know the number of records being fetched at a time and how can it be controlled? Thanks. Subhransu

Hi, I would like to know if there is a way to find out the total percentage of space taken by a field with respect to the size of the table. Secondly I would like to know if the size of the table contributes to the slowness in accessing the table? Thanks. Subhransu

Hi All, I want to write a program which will list all the .p programs which have a specific include file (.i) with a specific include parameter (e.g. &filename). Can anyone suggest any simple ways to do so with a sample code? Appriciate your help on this. Thanks. Subhransu