RAW function

(ORACLE only)

Extracts bytes from a field.

Syntax 

 

RAW ( field [ , position [ , length ] ] )

field

Any field from which you want to extract bytes.

position

An integer expression that indicates the position of the first byte you want to extract from field. The default value of position is 1.

length

An integer expression that indicates the number of bytes you want to extract from field. If you do not use the length argument, RAW uses field from position to end.

Example 

This procedure extracts bytes from the Name field of the first Customer, starting at byte 8, and writes 4 bytes to the variable r1:

 

r-rawfct.p

/*You must connect to a non-OpenEdge demo database to run this procedure*/ DEFINE VARIABLE r1 AS RAW NO-UNDO.   FIND FIRST Customer NO-LOCK. r1 = RAW(Customer.Name,8,4).

Notes 

If position is less a 1, or length is less than 0, the AVM returns a run-time error.

If (position +length -1) is greater than the length of the field from which you are extracting the bytes, the AVM returns a run-time error.

See also 

GET-BYTE function, LENGTH statement, PUT-BYTE statement, RAW statement