Subject Re: DELETE FROM error (no google results)
Author ryguy_40
Ann and Thomas. Thank you for pointing me in the right direction.

UDFFIXEDPOINT was indeed a user-defined function being activated by a few triggers. I dropped the triggers and now my delete script works.

Note: Don't be alarmed by the fact that I dropped the triggers (which were triggers to maintain relational integrity upon any inserts, updates, or deletes), this is a test-bed database that nothing depends on (and is backed up).

Thank you again.


--- In, "ryguy_40" <ryguy_40@...> wrote:
> Hello,
> I am having a very strange problem that Google returned no results for.. The SQL is a simple delete statement.
> SQL: delete from po_detail where pod_auto_key = 13777
> Here is the error:
> Preparing query: delete from po_detail where pod_auto_key = 13777
> Error: *** IBPP::SQLException ***
> Context: Statement::Prepare( delete from po_detail where pod_auto_key = 13777 )
> Message: isc_dsql_prepare failed
> SQL Message : -104
> Invalid token
> Engine Code : 335544343
> Engine Message :
> invalid request BLR at offset 539
> function UDFFIXEDPOINT is not defined
> module name or entrypoint could not be found
> It's worth noting, a "delete from" statement works on empty tables (ie, no errors but 0 rows affected). But I can not delete anything from tables with data.
> Anyone know what might be causing this?? What is UDFFIXEDPOINT??