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. Ryan --- In [email protected], "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?? >
