[icf-dev] Accessing SDO Temp-table

Hi Robert,

You can get the handle of the RowObject TT using where hDataSource is the SDO procedure handle.

This buffer should be positioned to the current row in the browser. You can then loop through the buffer fields and do what you need to.

You could also create a new buffer for this rowObject buffer and then open a query on that to navigate the data in the TT.

HTH,

Peter

|-Original Message-

|From: jds

|Sent: Friday, November 08, 2002 3:49 PM

|To: dev@icf.possenet.org

|Subject: Accessing SDO Temp-table

|

|

|Hi,

|

|Is there any way to access the entire record set (i.e. all

|records that can be seen in the browser) that the SDO

|retrieves on the client side from code?

|

|Your response is much appreciated.

|

|Kind regards

|Robert Pooley

|

|

|

|To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

|For additional commands, e-mail: dev-help@icf.possenet.org

|

|

To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

For additional commands, e-mail: dev-help@icf.possenet.org

Hi Peter,

Thanks for you reply.

You said " You can then loop through the buffer fields and do what you need

to.", how do we get the buffer fields ?

We tried but received the message

"User-defined function getbrowsefields invoked dynamically but could not be

found.

Kind regards

Robert Pooley

- Original Message -

From: "Peter Judge" To: Sent: Friday, November 08, 2002 4:51 PM

Subject: RE: Accessing SDO Temp-table

Hi Robert,

You can get the handle of the RowObject TT using {get RowObject

hRowObjectBuffer hDataSource} where hDataSource is the SDO procedure handle.

This buffer should be positioned to the current row in the browser. You

can then loop through the buffer fields and do what you need to.

You could also create a new buffer for this rowObject buffer and then open

a query on that to navigate the data in the TT.

HTH,

Peter

|-Original Message-

|From: jds

|Sent: Friday, November 08, 2002 3:49 PM

|To: dev@icf.possenet.org

|Subject: Accessing SDO Temp-table

|

|

|Hi,

|

|Is there any way to access the entire record set (i.e. all

|records that can be seen in the browser) that the SDO

|retrieves on the client side from code?

|

|Your response is much appreciated.

|

|Kind regards

|Robert Pooley

|

|

|

|To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

|For additional commands, e-mail: dev-help@icf.possenet.org

|

|

To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

For additional commands, e-mail: dev-help@icf.possenet.org

To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

For additional commands, e-mail: dev-help@icf.possenet.org

Hi Peter,

Thanks for you reply.

You said " You can then loop through the buffer fields and do what you need

to.", how do we get the buffer fields ?

We tried but received the message

"User-defined function getbrowsefields invoked dynamically but could not be

found.

Kind regards

Robert Pooley

- Original Message -

From: "Peter Judge" To: Sent: Friday, November 08, 2002 4:51 PM

Subject: RE: Accessing SDO Temp-table

Hi Robert,

You can get the handle of the RowObject TT using {get RowObject

hRowObjectBuffer hDataSource} where hDataSource is the SDO procedure handle.

This buffer should be positioned to the current row in the browser. You

can then loop through the buffer fields and do what you need to.

You could also create a new buffer for this rowObject buffer and then open

a query on that to navigate the data in the TT.

HTH,

Peter

|-Original Message-

|From: jds

|Sent: Friday, November 08, 2002 3:49 PM

|To: dev@icf.possenet.org

|Subject: Accessing SDO Temp-table

|

|

|Hi,

|

|Is there any way to access the entire record set (i.e. all

|records that can be seen in the browser) that the SDO

|retrieves on the client side from code?

|

|Your response is much appreciated.

|

|Kind regards

|Robert Pooley

|

|

|

|To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

|For additional commands, e-mail: dev-help@icf.possenet.org

|

|

To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

For additional commands, e-mail: dev-help@icf.possenet.org

To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

For additional commands, e-mail: dev-help@icf.possenet.org

Hi Robert,

The code you are looking for would be cseomthing like:

/* Get the buffer handle to the rowObject TT in the SDO */

}

DO iLoop = 1 to hRowObjectBuffer:NUM-FIELDS:

/* Sequentially get the handle to the fields in the rowObject buffer */

ASSIGN hRowObjectField = hRowObjectBuffer:BUFFER-FIELD(iLoop).

/* Do stuff here:

• The help files are quite useful here - look under the "buffer field object"

• and the "buffer object" sections for methods, attributes etc.

*/

END.

If you need to create a separate (named) buffer:

CREATE BUFFER hMyRowObjectBuffer FOR TABLE hRowObjectBuffer BUFFER-NAME "MyBuffer".

This is equivalent to the static constrcut:'

DEFINE BUFFER myBuffer FOR Buffer.

HTH,

Peter

|-Original Message-

|From: jds

|Sent: Wednesday, November 13, 2002 8:56 AM

|To: Peter Judge

|Cc: dev@icf.possenet.org

|Subject: Re: Accessing SDO Temp-table

|

|

|Hi Peter,

|

|Thanks for you reply.

|You said " You can then loop through the buffer fields and do

|what you need to.", how do we get the buffer fields ?

|

|We tried but received

|the message "User-defined function getbrowsefields invoked

|dynamically but could not be found.

|

|Kind regards

|Robert Pooley

To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

For additional commands, e-mail: dev-help@icf.possenet.org