Binary Data value return as 0

Using aggregate to get the data from table, filter by unique id so each time only return one result.

In the result, consist of Id (Identifier), Content (Binary Data), CreatedDateTime (Date Time).

However, each time the Content return from aggregate shown as "-optimized-".

When assign the Content to Local Variable, result shown as "Binary Data (0 bytes)".

What happened?

Hello Qiuyan,

Is see two strong possibilities.

1. The record binary attribute is empty. No binary data was saved.

2. The variable is not yet being used, so the compiler is optimising the code and the binary data is not being fetched from the database.

Hope this helps.