Re: [Firebird-odbc-devel] Isolation level when using Access

[Kevin L. <ke...@af...>]

"Vladimir Tsvigun" wrote:

> Firebird have not DYNAMIC cursor
>     OdbcJdbc displays all types of cursors STATIC
>     You can simulate through the program
>     However if to analyse Access log ODBC
>     Look as it does MsAccess from any log ODBC
>     SELECT FLD1 from MYTABLE where FLD1 == ?  AND  FLD1 == ?  AND
> FLD1 == ?  AND FLD1 == ?  AND FLD1 == ?  AND ...
>     .Execute
>     .Fetch 20-30 row
>     .Close
>     View page to table

I'm not sure I follow. I understand the cursor problem but am not sure
I understand how to similate it in Access. I don't see a way for me to
tell Access how to fetch the records.

I think I userstand what's happening. If I open a table and manually
insert a record by typing in the field values and save the record, it
remains visible. I don't have to close and open the table to see it.

If I copy and paste 1 or more records, I think Access is inserting
those records in a different transaction, so they are not visible until
I close and reopen the table.

Not sure if there is anything to do about that...=<


>  I now announced Manager transactions
>     See message
>         [Firebird-odbc-devel] Full-function SQL Transaction Manager
> is added ( build OdbcJdbc v2.0.0103 )

I saw this and am now playing with some ideas for some other projects I
am working on. Pretty cool stuff...=)

Kevin Lingofelter