This is not a FireBird problem, it happens also with other DB, I've
faced it for years with SQL Server.
The only way I've found to solve it is requerying the datasource and
programatically repositioning cursor at desired point.
Roberto

--- In firebird-support@yahoogroups.com, Adomas Urbanavicius
<adomas@...> wrote:

>
> Hello,
> Linked MS Access via odbc to FB table.
> Deletion and editing : OK.
> But after inserting record, in field places we see strange values :
> "#Deleted".
> After closing, reopening table/form : values are correct. But while
> browsing table, after insertion, in new inserted records in all

places

> shown values look "#Deleted".
>
> Anyone faced this issue ?
>
>
> Sample :
> ID ,Name
> 1 Name1
> 2 Name2
> 3 Name3
>
> Inserting (manually) records :
> 4, Name4
> 5, Name5 .
>
> While browsing table we see :
> 1 Name1
> 2 Name2
> 3 Name3
> #Deleted #Deleted
> #Deleted #Deleted
>
> After reopening table :
> 1 Name1
> 2 Name2
> 3 Name3
> 4 Name4
> 5 Name5
>
> How to make records instantly to look ok ?
>
>
>
> Adomas
>