Smart Blobs

Posted in 2004

ROBERT GATT — Tue, 25 May 2004 13:00:57 — source: IIUG Forums & Mailing Lists

Can anyone tell me how can I select,update,insert and delete from a smart blob. Thanks Robert

↪ replying to ROBERT GATT

Gerd Kaluzinski — Wed, 26 May 2004 07:20:04 — source: IIUG Forums & Mailing Lists

Just use the SQL-Statements insert into xx values (...,filetoblob("<complete path and file>","server", ....)select .... lotofile(<col>,"<complete path and file>!","server", .... The "!" at the end of the filename by unloading a blob just prevents ids from using a unify-number to prevent overwrite if there is more than one unload in the statement. ROBERT GATT wrote: >Can anyone tell me how can I select,update,insert and delete from a smart blob. > >Thanks >Robert > > > > -- Gerd Kaluzinski Tel. :+49-(0)7541-585-5000 Fax :+49-(0)7541-585-5500 BYTEC GmbH mailto:support@bytec.de Hermann-Metzger-Str.7 http://www.bytec.de 88045 Friedrichshafen