Search results

Hi, I have the following stored procedure CREATE PROCEDURE SEARCH_CRUISE_DEBUG33( ) RESULT ( CruiseId VARCHAR(10000) ) BEGIN String resultString = null ; // Businees logic to populate resultString. SQLResultSet.set(1, resultString); SQLResultSet.insert(); END The length of...

Hi , I am new on Java Stored Procedure. Our application is a java based application connecting to progress DB. Below is a sample of stored procedure we write. I want to set isolation level to Read Uncommitted. With out that, its creating share locks. Can any one tell me how to set isolation...

HI, I am a junior progress resource. In our development environment, in appserver log , we are getting entries like AS AS Server Message state = MSGSTATE_INITRQ AS AS Server Message state = MSGSTATE_RECVLAST requestID= <REQ|2391c70de6acfedc:-4a57888b:13776dacd49:-7ff8-001267> AS AS -- TRACE...

Can anyone please provide me link to any document on tutorial of using com-handle for Excel.

Help need on colon "::" Hai, Can you help me whats the meaning of using :: Can you please tell any pdf or something where i can get more information on it. I have seen in some places its used like Prodataset-handle::buffer-handle.

Hai, I need to find the number of records in a buffer which satisfies a given where condition. for example : i have a query h_query:query-prepare("for each compinv"). i need to find the number of records.. There is a function called h_query:num-results.but this needs the query to be opened...

Hai, I got a temp-table t-t1 and t-t2. both having similar signature. now t-t1 has one record and t-t2 has another record. i want to write a for each statement such that it will fetch record from t-t1 and then from t-t2. Is this possible to do without copying data from both to one temp-table.?

Hai, Is there anyway to get the primary unique key of a buffer from its handle. there is a statement like hbuff:index-information(i). but that gives information of all the indexes for different values of i. but that is a over load as i have to loop through it. is there any easier way? it...

hai, Is there anyway to identify whether a temp-table or dataset is passed as by-reference to the called procedure, from the called procedure... For example... run test.p(input dataset d-data by-reference). /* prodecure test.p) */ input parameter dataset-handle h-data). i want to know...

Hai, I am a beginner in progress.. Please help me in following situation. define variable v-where as char. assign v-where = "tbprihdr.price-id = 1234". find first tbprihdr where price-id = 1234. message price-id. /* the record is available in buffer. */ if v-where then message...

Hai, I am facing a problem. i was compiling the following piece of code def new shared temp-table tt-temp like hoteldsc. def new shared dataset d-date for tt-temp. but i got the error Buffer tt-temp in shared dataset d-date must be shared too. (12383) ** Could not understand...

Hai I am new guy on progress. only 2 months of experience.I am facing a problem and it will be great help if someone can get me a solution. The problem is , i am getting the following error. SYSTEM ERROR: Memory violation. (49) ** Save file named core for analysis by Progress Software...