Error when editing IBQuery

[EricDraven]

I am receiving the following error when trying to edit a record in an IBQuery.

"feature is not supported BLOB and array data types are not supported for compare operation"

The following SQL code is used to select the record to edit.

Select * from Bookings
where BOOKING = "BookNo"
and ITINERARY = "ItinNo"

If the querys recordcount is zero, then I know it is a new record being entered by the user which is saving perfectly (using IBQuery1.Append). If a record is located, I call IBQuery1.Edit instead, but once the Post command is reached the above message is displayed. The fields Booking and Itinerary are both of type FLOAT (I have read that you cannot include array/blob fields in the where clause) and the IBQuery is linked to an IBUpdateSQL component with the correct SQL code in it.

I do seem to be able to find the most obscure errors around...


When your feeling down and your resistance is low, light another cigarette and let yourself go

 

[Svanhooft]

hi,

If a blob field is part of a table you cann't use the * for the update. You have to write a special query where you put the blob field in as a parameter. So check your update queries and remove the blob fields. and write a special one for the blobfileds.

Steph [Bigglasses]

 

[EricDraven]

I have removed the * from my SQL code and replaced it with all of my required field names barring the BLOB fields. I have also removed the BLOB field names form the IBUpdate SQL for testing purposes but I am still getting the same error! Why is it only happening when I try to edit a record? I can append a new record (including BLOB fields) just fine!


When your feeling down and your resistance is low, light another cigarette and let yourself go

 

[EricDraven]

Ahhh, Changing the Query.Post statement to Query.ApplyUpdates solves this problem! I still have a problem with some of the BLOB fields but I think I know a way around that already...

Famous last words...


When your feeling down and your resistance is low, light another cigarette and let yourself go