Search results

Now, i understand both LONGCHAR and CLOB. :) Thanks a Lot Tom, Tamhas, for your Mentorship!! Thanks & Regards!! Rajat.

Hi Tom, I tried the above code, but got an error: "INPUT/OUTPUT operation are not Allowed..". I read the documentation again and tried this code and it ran successfully, Perhaps we are not able to display CLOB field directly? Am i writing the correct code, please confirm? DEF VAR l-reslt...

Hi Tom, Thanks for the reply. 1. Yes input file does have more then five lines, i took a random number #5 for ENTRY function. 2. I tried your example but according to it we are coping the data from a file to LONGCHAR data type, then where CLOB database field comes into picture and according to...

Wow, I got it when i posted this thread then content between CODE tags shown as progress code. Next time i will make sure to use proper code tags!!! Thanks for Informing !! Rajat.

Hi Cringer, Apologies, but i didn't get completely that what do mean by CODE TAGS. Do i need to use before i start coding and after code ends and shouldn't insert /****/(comments there). Could you please elaborate so that next time i will make sure to use proper code tags. Thanks &...

Hi Tamhas, Thanks for the quick reply. Again i tried the code with COPY-LOB and without it : /*------------------------------------------------------------------------------------------------------------------------------------*/ DEF VAR l-val AS CHAR NO-UNDO. DEF VAR l-val1...

Hello Everyone, hope you all are doing well. :) For understanding LONGCHAR and CLOB datatype i am trying one scenario where i want to store large text file(more then 50kb) into a CLOB field of database table and later retrieve that field and display in EDITOR. /*Code that I am trying to fill...

Hello Everyone, I want to add few points into this: 1. Progress have its default stream which is connected to screen output. If we use OUTPUT TO statement then we redirect that default stream to somewhere else. 2. If we use DEFINE STREAM statement then we are creating the new stream and...

I can understand the difference now, thanks for your mentorship Tom. :)

Yes, you are correct. But i am curious to know that what are the scenario's where we can use Form not Frame or Vice-Versa.

Hi Tom, As per my understanding, this question has two parts. Q 1: Could any one explain whats the basic differences between FORM and a FRAME. ANS: This is the main difference that i have found between From and Frame(Described above). Q2: what we can achieve from the one which we cannot...

Form and Frame is used to display data in progress. Difference: 1. From display data to the current block of transaction and Frame display all data which is in the block. 2. Because Form display data to the current block only, apparently we face Frame flashing problem and to resolve this...

Hi Dude, hope you are doing well. :) Actually i am facing the same problem with procedure editor. In my personal laptop when i write code in procedure editor then it will display in simple text format. My apologies for this, next time i will make sure to write proper code tags. Requirement:-...

Hello everyone, I studied about dynamic temp-table and visualized the benefits that we can get from it. i tried the simplest scenario of dynamic temp-table but facing some issues ex: def var qh as handle. create temp-table qh. find customer where customer.custnum = 1. if available...

Thanks everyone, for providing your inputs. As of now i am able to understand the basic usage of handles. :)

I got it Tom, i was trying to clarify some of my doubts. In the end i am able to send data from browse-widget. :) Thanks!!!

Hi Osborne, The above mentioned code doesn't work because we use output statement after VALUE-CHANGED trigger. if i little manipulate this code for ex:- DEFINE STREAM c-strm. DEFINE QUERY q1 FOR Customer SCROLLING. OUTPUT STREAM c-strm TO VALUE("C:\DFG\111.TXT"). DEFINE BROWSE b1 QUERY q1...

That's correct, this code works fine. but if i take output statement out of this code and define this into definition section then it will return me error message. This is quite surprising because i am globally defining output statement same as for each example that i mentioned above, but in...

Hi Osborne, thanks for replying. That comes to my mind also, as per my understanding that why stream is different from output to statement as instead of diverting a stream via output to we are creating new stream. Ex:- DEF STREAM c-strm. OUTPUT STREAM c-strm TO...

Hello Everyone, I took a single select browse widget associated with customer table having 3 fields which populates automatically when we execute that. Requirement:- i wanted to send multiple records which i select from a browse one-by-one to a .text file and i can select n number of records...