SQL Anywhere database

Author

autocommit

Gregg Vine

2005-05-20, 9:23 am

for customer

ASA 902 2451

Hi there,

We've got a huge problem with administering some of the ASA database tables.

We are doing an ODBC connection to the ASA tables from Visual FoxPro. When
we've changed the contents of the table, we can see the changes on the ASA
side. As soon as we close the tables from FoxPro, the tables roll back in
ASA.

We have no idea why this happens.

We've read something about cooperative commits in the help docs, but we're
not sure how to use this or even if this is what's causing the propblem.

PLEASE - THIS IS URGENT !!!

Thanks!

Gregg

Dmitri

2005-05-20, 9:23 am

Gregg Vine wrote:

> ASA 902 2451
>
> Hi there,
>
> We've got a huge problem with administering some of the ASA database tables.
>
> We are doing an ODBC connection to the ASA tables from Visual FoxPro. When
> we've changed the contents of the table, we can see the changes on the ASA
> side. As soon as we close the tables from FoxPro, the tables roll back in
> ASA.
>
> We have no idea why this happens.

You don't commit your transactions.

Dmitri.

Sponsored Links