V4CC - Sql Blob Update Fails with Binded NSData

[Ernesto Giannotta]

Hi Ruslan,

I can't update a Blob field with NSData using SqlExecute.
I get an error ErrorNumber:0x7004 Using clause required for dynamic parameters.

Steps To Reproduce:

        NSData *rawData = [NSArchiver archivedDataWithRootObject:[NSArray arrayWithObject:@"SomeText"]];
        NSArray *binds = [NSArray arrayWithObject:rawData];
        
        // this will fail, NSData object will not be accepted as bind
        [mDB sqlExecute:@"UPDATE Persons SET FieldBlob = :1 WHERE FieldName = 'Erne'" bind:binds];



reported to Mantis with attached test file.



Cool Runnings,
Erne.