LOB Info snippet
Description
The LOB Info snippet is a useful tool to organize and maintain the required LOB Info parameters field.
The SQL parameters snippet would be used in some AlchemyJ Extended Functions such as ajDBUpdateLOB and ajDBGetLOB.
To insert a LOB Info snippet, select a cell on an empty row and ensure that there are 4 extra empty rows below it to prevent the snippet from overwriting the values below.
Go to AlchemyJ ribbon and click Insert Snippet. Under the dropdown, select LOB Info.
Column definition
LOB Content Field, LOB Content Folder, LOB File Name field and LOB File Name are required fields for uploading a file. CLOB Big String Memory ID, CLOB Character Set Field are required for uploading a big string.
| Argument Name | Description |
|---|---|
| LOB Content Field (optional) | The name of the table column that stores the file. |
| LOB Content Folder (optional) | The local folder path of the file to be uploaded. |
| LOB File Name field (optional) | The name of the table column that stores the filename. It is done by ajDBGetLOB when saving the file. |
| LOB File Name (optional) | The filename of the file to be uploaded. |
| CLOB Big String Memory ID (optional) | The ID of the big string to be uploaded. |
| CLOB Character Set Field (optional) | The name of the column that stores the character set code of the file. Include this column if CLOB is used. |
| CLOB Character Set (optional) | The character set code of the big string. The default is utf-8. |
Example
Below is the example of the ajDBUpdateLOB function. insert the LOB Info snippet.
The snippet will be populated as shown below with no values.
Fill in the LOB Info details accordingly.
When referencing the LOB Info table, do remember to include the column headers as part of the cell range as shown in Cell B14 for the formula to work.