meta data for this page
  •  

F_BLOBCAT

compatibility to GrUDF

Entrypoint blobcat not compatible with UTF-8 - use ||

Inputs/Outputs

   Input     BLOB     TextBLOb to join with TextBLOb from parameter 2
             BLOB     TextBLOb to append to TextBLOb from parameter 1
   Output    BLOB     Joins two TextBLObs to one TextBLOB

Syntax

   This function appends an CRLF and then appends the 2nd BLOb
   TestSQL (to use with TestISO.GDB)
   INSERT INTO BLOBTEST (TEXTBLOB) SELECT F_BLOBCAT(TEXTBLOB, (SELECT TEXTBLOB FROM BLOBTEST WHERE BLOBTESTID = 2)) FROM BLOBTEST WHERE BLOBTESTID = 1;
   Insert a new record in table BLOBTEST with the content of the field TEXTBLOB form datarow with ID = 1 append with the datarow ID = 2