blobwrite

beasscript-logo-small  

endoflive

blobwite=<id>=<filename>

 

The given file is written into the Database.

A unique ID can be allocated. If none is allocated, then the function gives an ID back.

 

The File can be restored by blobread.

 

Operation:

 

be.as manages files in the table beas_blobs with the column names

ID, filename and blobentry. If the table does not exist, this is created automatically.

At Microsoft SQL Server the type "image" is used as Blob-Column, otherwise "blob"

 

If a storage of a file is needed, the function is invoked and the ID is filed in the real table, as a cross reference.

 

Handing over:

id                Unique ID. When empty, then automatically generating. Type: Char20

filename        Filename. If there is no "\" indicated (directory tree), then in be.as temporary directory will be sought.

 

Return:

The following variables are given back.

sys_blobid        Unique ID

         In the error case:

         

         file not exists File not found.

 

 

Example:

blobwrite==c:\temp\testfile.txt

blobread=<sys_blobid>

message=file create: <sys_blobfile>

 

 

help-achtung

A Blob mustn't exceed the size of 10 MByte!