Results 1 to 2 of 2

Thread: CK6: IgnoreCase and BLOB not mix

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2009
    Location
    New Zealand
    Posts
    1,830

    Default CK6: IgnoreCase and BLOB not mix

    Hi Martin,

    Tested Using:
    * DF19 RC1 & DB2 CK6.2
    * DF18.2 & DB2 CK6.1

    We found that if any field within a table has a IgnoreCase index associated with it,
    And if the table has a BLOB field - DF will crash while trying to save.

    For example:

    Create a Table as per:
    1. FILENAME ASC(250)
    2. FTITLE ASC(250)
    3. FTYPE ASC(5)
    4. FSIZE NUM(8.0)
    5. CREATED DATE(10)
    6. MODIFIED DTM(23.6)
    7. FILEDATA BINARY(10MB) <-- use native type BLOB


    Then, Create a simple view with a cdbCJGrid of fields 1-6 BUT not field 7 as its a binary.

    Try to edit and save data - all works well.

    NOW, create a index as per:
    1. FILENAME IgnoreCase=True


    And test the view again, as soon as you edit a row and try to save it - DF crashes !
    Last edited by raveens; 7-Jul-2017 at 12:34 AM.
    Regards,
    Raveen Sundram

    Software Development Manager
    Excellent Software Ltd
    Auckland, New Zealand
    www.helixretail.co.nz


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •