...
File1 column shows file names File2 column shows blob files. In the created database, the BLOB file column is selected as "bytea" data type.
You can use it in Access,Postgres,Mssql,Oracle,Sqlıte,MySql databases.
FileMemoColumnin VT must have a file extension in the given column.If there is no extension in the column value and all files are of the same type, an extension can be added to the macro value.
Key | Description | ||
|---|---|---|---|
| BLOB/MEMO field containing the file content. GEODI will automatically determine the file content | ||
| The column name idenfting the primary key of the tableMacro for the unique number of the file. The rules for macros are at the end of the document. | ||
| The Macro for the name of the file that will to appear in searches and viewers. Rules for macros can be found are at the end of the document. |
| The column name (BLOB/Memo Field) where the file content can be found. GEODI will automatically determine the file content |
| Code Block | ||
|---|---|---|
| ||
{
"Defines":[
{
"__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
"TableFilter":"TEST",
"IDColumnMacro":"[OBJECTID]",
"FileNameColumnMacro":"[FILE1]",
"FileMemoColumn":"file2"
}
]
} |
...