Why doesn't a query return recently inserted data?

The issue reported to us is: "INSERT statements seem to work OK and an immediate SELECT with the same cursor displays the data, but when I retry the query, the data is gone."

Some ODBC-enabled languages have autocommit set to off by default. There are two ways to ensure that INSERT statements are committed:

1. Turn on the relevant autocommit flag in your connection.
2. Use appropriate commit and rollback methods in your script.

Refer to the following resources for detailed information on how to do this:

• Python
  • mxODBC

    (http://www.egenix.com/products/python/mxODBC/)

  • pyodbc

    (http://pyodbc.sourceforge.net)

• perldoc DBI or Perl

  (http://dbi.perl.org)

• PHP

  (http://www.php.net)

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•