Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLite - M-Business Anywhere Programming » UltraLite for M-Business Anywhere API reference » ULTable class


appendBytes method

Appends the specified subset of the specified array of bytes to the new value for the specified SQLType.LONGBINARY column.

  UInt16 columnID, 
  Array value, 
  UInt32 srcOffset, 
  UInt32 count
  • columnID   The ID number of the column. The first column in the table has an ID value of one.

  • value   The new value for the column.

  • srcOffset   The value to append to the current new value for the column.

  • count   The number of bytes to be copied.


The bytes at position srcOffset (starting from 0) through srcOffset+count-1 of the array value are appended to the value for the specified column. When inserting, insertBegin initializes the new value to the column's default value. The data in the row is not actually changed until you execute an insert, and that change is not permanent until it is committed.

If any of the following is true, an Error with code SQLCode.SQLE_INVALID_PARAMETER is thrown and the destination is not modified:

  • The value argument is null.

  • The srcOffset argument is negative.

  • The count argument is negative.

  • srcOffset+count is greater than value.length, the length of the source array.

For other errors, a SQLException with the appropriate error code is thrown.