...
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 |
| Macro for the unique number of the file. The rules for macros are at the end of the documentThe column name idenfting the primary key of the table. |
| Macro for the The name of the file to that will appear in searches and viewers. Rules for macros are can be found 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"
}
]
} |
...