Subject Re: [firebird-support] DELETE FROM error (no google results)
Author Thomas Steinmaurer
> 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??

An user-defined funtion possibly. As this only happens when the table is
not empty, I guess the UDF is called in a trigger.

Take Ann's advice and come back with the requested information.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!