LOB Info snippet
The LOB Info snippet is a useful tool to organize and maintain the required LOB Info parameters field.
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.
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.
|LOB Content Field|
|The name of the table column that stores the file.|
|LOB Content Folder|
|The local folder path of the file to be uploaded.|
|LOB File Name field|
|The name of the table column that stores the filename. It is done by ajDBGetLOB when saving the file.|
|LOB File Name|
|The filename of the file to be uploaded.|
|CLOB Big String Memory ID|
|The ID of the big string to be uploaded.|
|CLOB Character Set Field|
|The name of the column that stores the character set code of the file. Include this column if CLOB is used.|
|CLOB Character Set|
|The character set code of the big string. The default is utf-8.|
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.