My guess is that this is not related to Firebird itself, but to the components you use. JOIN is generally part of SELECT, and your error message indicates UPDATE or DELETE, so my guess is that you've SELECTED fields in your application and then try to update/delete them (from a grid or something).

If this is the case and you use IBO, then you have to either specify the UpdateSQL/DeleteSQL properties or specify which table to update in KeyRelation. But then this would be a question for the ibobjects list rather than firebird-support. If you use other components, then I guess some other list would be appropriate.

On the other hand, if you get this error message when writing something like:

DELETE FROM MyTable
WHERE EXISTS (SELECT ... LEFT JOIN ... WHERE ...)

then please describe your problem more in detail on this list.

I think your error message is basically saying that it cannot find which table row to modify.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of phfranzos
Sent: 31. august 2010 10:05
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebirs 2.1 : left join right join full join outer join dont' work !

The join command works only when its used alone but not with left, right etc....
When I use for example left outer join..... then I get the following error: 'The cursor identified in the update or delete statement is not positioned in a row. No current record for fetch operation.'
Can someone help me ?