> 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
http://www.upscene.com
http://blog.upscene.com/thomas/

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