meta data for this page
  •  

F_BLOBLINECOUNT

function from adhoc

input/output-compatibility to rFunc (B_LINE_COUNT)

Entrypoint bloblinecount compatible with UTF-8

Inputs/Outputs

   Input      BLOB        TextBLOb
   Output     INTEGER     No. of lines in a TextBLOb

Syntax

   TestSQL (to use with TestISO.GDB)
   SELECT 3 AS ISCORRECT, F_BLOBLINECOUNT(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 3;
   SELECT NULL AS ISCORRECT, F_BLOBLINECOUNT(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 10;