Release 10.1A: OpenEdge Getting Started:
New and Revised Features

> ## Proc-Text-Buffer technique

> The first technique, `proc-text-buffer`, requires you to access result sets available through a pseudo table for which each row is a long character string. Consequently, you must parse each long string to access specific fields. And, although you can use the `proc-text-buffer` technique to hold the results from all of the SQL statements included in a stored procedure, the buffer you create to hold the results can only hold one results set record from one result set at a time.

> Review the example presented in Figure 2–2.

>     RUN STORED-PROC send-sql-statement
>          (“SELECT name, address, city, state, postal_code FROM customer WHERE
>          credit_limit>=500”).
>     FOR EACH proc-text-buffer:
>          DISPLAY proc-text-buffer.
>     END.

> Figure 2–2: Proc-text-buffer technique example

> Since `proc-text-buffer` contains the character equivalent of the columns described by the `SELECT` statement, Figure 2–2 simply shows the character string results that display when the results are returned from the executed procedure; the individual columns of the result set have not been parsed.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095