SQL Syntax Reqd

SQL Syntax Reqd

Post by Uwe Webe » Wed, 20 Jun 2001 00:24:56




> Can anyone please supply the syntax required for inserting/updating BLOB
> (Text) fields.

> For instance INSERT tablename (COL1, BLOBCOL)
> VALUES ('firstvalue', ??????????)

> Dave Goldsbrough

No way.
You have to write a "small program". ESQL/C or Java-JDBC is fine.

If you are using Smart BLOBS (IDS 9.x requested) you can use two nice
functions to "select" and "write" (insert) those BLOBs called "lotofile"
and "filetoblob". For syntax look at the SQL Syntax Guide from the Answer
Online.

Reagards
Uwe

 
 
 

SQL Syntax Reqd

Post by Stefan Weidenede » Wed, 20 Jun 2001 05:27:01


Hi,

if you want to use "dbaccess", you might use
the "LOAD" statement instead of an INSERT.
Otherwise -> see answer from "Uwe"

Regards

Stefan