Reference:10. Modify Sequence and TSeq

The same syntax for array assignment in Java also applies to the sequence modification in esProc, that is, you can just assign directly to the member at appointed position to implement it. 

esproc_reference10_1Besides, similar to SQL statement, you can also use the insert, delete, modify, and other functions to perform the insert, delete, modify, and other operations on the sequence.

esproc_reference10_2

Unlike the other Sequence, the member of record in TSeq cannot be assigned directly. For example, if T is a TSeq, then the T(3)=r operation is wrong.

When modifying TSeq, you can only use insert( ), delete( ), modify( ), and other functions to modify the TSeq, or directly modify the record of this field.

esproc_reference10_3

As the expression in the A5 indicates that you can use ISeq to indicate the position when deleting the records in the TSeq. Therefore, with the pickout function of pselect() in the TSeq, you can delete the records according to the specified conditions.

esproc_reference10_4Use reset() function to delete all records in the TSeq and only keep the data structure.

esproc_reference10_5

Advertisements

About datathinker

a technical consultant on Database performance optimization, Database storage expansion, Off-database computation. personal blog at: datakeywrod, website: raqsoft
This entry was posted in Reference and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s