Search results

Hi Team, Might be a silly question... How can i determine the maximum number of characters that can be stored in a CHARACTER data type (Variable and DB field of type CHARACTER) as part of Progress 10.1C? Sometime back i remember i have seen in some document saying we can store 2000 characters...

Team, Can someone help me understand the diff between WRITE trigger and REPLICATION-WRITE Trigger? When i tried creating a record to REPLICATION table in WRITE trigger i was able to... If so what makes REPLICATION-WRITE trigger so special? It might be a silly question though. It would be...

Team, While using XREF utility i was little confused with the 2 below keywords. Could someone explain the difference between them? 1. ACCESS 2. REFERENCE In most cases both of them, are equal adn the only differece i could see is the keyword as below; "utility/bridge.p" 17 "ACCESS" "mas.TERR"...

Team, When i take an XREF for the program that uses FILL method to create records for my table, i couldnt see an appropriate entry in XREF file with "CREATE" option in it. Is this a kind of bug in XREF tool or am i missing out something? dsProMain.p /* Include temp table component */...

Team, In our Production environment we are getting error message 9287. I could see what the error message is all about... It is happening consistently across programs and modules. What could be the root cause of this issue? Any clues where i can start on?

Hi Team, I am not sure if am missing out something, may be... I have 2 questions; Question 1: I have a Division id field which is a character field that would right align if only the numeric characters are available in the input string, others will be left aligned. The Division Id value is...

Hi Team, Here is the requirement - I don't want to create a record for a customer table if cust-id field has value as "" (BLANK). There are 2 existing triggers (create & write) for the same table; Create Trigger: TRIGGER PROCEDURE FOR CREATE OF customer. ASSIGN customer.create_dt = TODAY...

Hi Team, Am not sure why am getting the below error; ┌─────────────────────────────────── Error ────────────────────────────────────┐ │ ** Warning -- database archive is already connected. (1012) │ │ Database physical names /ad03/arch12/archive and /cd04/arch5/archive do not │...

Hi Team, Where can i get the description and details about the hidden tables and its fields? Do we have any separate documentation for the same. Thanks in advance!

Hi Everybody, Am not sure if it is a strange behavior of XREF when temp-table & buffers are used. Below is a sample code snippet with its xref details. XREF Details: "C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 COMPILE "C:\saravanakumarb\bufferTest.p"...

Hi Team, Do we have any separate document which lists all the pre-defined classes & interfaces used in Progress 4GL? I can see few in OOPS manual but it would be of great help if it is documented in a separate manual and be available for reference. Can someone help me out in this regard? Thanks..!

Team, Consider the below scenario; I have to write data to a file which doesn't exist. Henceforth in this case Progress tries to create a new file. But i haven't given the folder permission, so Progress will throw an error in this case. I hope "OUTPUT TO" statement doesn't have NO-ERROR option...

Team, I have a SELECTION-LIST widget (multi selection option included) in which on pressing "ENTER" key am able to select the record whereas when i press SPACE-BAR am not able to select the record. I tried even writing an explicit trigger for space bar. Note: am using CHUI interface... Please...

Team, It would be of great help if someone can pull me out from my problem. Here is my problem; Is there a possibility to get proper "userProfileID" and "UserID" as 0. I am not sure how come after choosing the userprofileid for the matching userid the userid becomes 0? Here is the log file...

Team, Is there a max limit for defining the data relations or number of temp-tables that can be used in a DataSet? Thanks in advance..!

Team, Here is my problem; Consider the below assign statement xyz = "some string " + <<input value from a field from UI>> + " some string". Scenario 1: If <<input value>> is "Test" then the value of xyz would be "somestring Test somestring" Scenario 2: If <<input value>> is ? then the value of...

Hi Team, All the codes written and DB for our application are against the code page, ISO8859-1. Now we are planning to convert it to UTF-8. I could get some ways and steps from PROKB for converting the DB. Do we need to write any special code or perform any other operation to make the code...

Hi Everybody, I am not able to figure out the reason for the below behavior. Can someone let me know in detail; In the above code snippet i can get the record available even after the transaction block. (Out of this transaction block i am able to update name of the customer) This code...

Hi Everybody, Wanna know if CRC error will be thrown if we add a new field to an existing table. The scenario is like this: Few programs are there that refers to an existing table, say Table_1. Now i am adding a new field to Table_1, will CRC error been thrown when i execute the programs that...

Hi Everybody, Below is my requirement; say after joining 2 tables customer & order i have 3 fields in the result set as follows; 1. Customer ID 2. Customer Name 3. Order Number Pre-Requisites: 1. In order table Order number is not unique, it may repeat Now i need to Break By Order number but...