meta data for this page
  •  

F_BLOBMID

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

Entrypoint blobmid not compatible with UTF-8 - use U_MID

F_RBLOBMID

input/output-compatibility to rFunc (B_SUBSTR, B_LONGSUBSTR)

Entrypoint r_blobmid not compatible with UTF-8 - use U_MID

Inputs/Outputs

   Input     BLOB                  TextBLOb
             INTEGER               Position, at which the determined string starts
             INTEGER               Length of returned string
   Output    CSTRING(32760)        number of letters (parameter 3) of the entered text starting from the entered letternumber (parameter 2)

Syntax

   F_BLOBMID - counting for parameter 2 starts with 0
   F_RBLOBMID - counting for parameter 2 starts with 1
   TestSQL (to use with TestISO.GDB)
   SELECT 'zwei' AS ISCORRECT, F_BLOBMID(TEXTBLOB, 4, 4) FROM BLOBTEST WHERE BLOBTESTID = 2;
   SELECT NULL AS ISCORRECT, F_BLOBMID(TEXTBLOB, NULL, NULL) FROM BLOBTEST WHERE BLOBTESTID = 10;