tags:

views:

44

answers:

1
Q: 

Can I query inside a SQLite Transaction?

I'm using the SQLite3 database system in the Android library.

I need to execute a query during a transaction to see if there is a similar entry already there. If there is, I have to perform some other logic and adjustments before I add a new row.

Can I execute a query within a transaction and get the result back immediately?

+1  A: 

Yes it is safe to do so.

SB  2010-05-15 17:44:19

related questions

C#, Linq2SQL: Getting the highest of each group.
Determine the size of the records returned by a database server (Kb,Mb)?
How can I view live MySQL queries?
Query Optimization TSQL and otherwise
enforcing database constraints: code vs sql
Retrieving a list of blog posts with related tags with less query
How do I create a "filter by price" type of query?
SQL Server - Query Short-Circuiting?
PHP - Query single value per iteration or fetch all at start and retrieve from array?
Inserting rows in table that has a relationship with another table
Is 20 SQL Queries per page load really considered a lot?
MS Access - Mass Emailing?
Novice SQL query question for a movie ratings database
Using django how can I combine two queries from separate models into one query?
Combining queries in MySQL
SQL - How to make a conditional INSERT
How do I compress this Oracle resultset into values according to row priority, ignoring nulls?
How to query an Oracle table from SQL Server 2000?
What are some best practices for querying binary data from a database?
How do you sort a tree stored using the nested set model?
Query showing list of associations in many-to-many relationship
How do I declare a multi-column PK in MySQL
ORA-01031: insufficient privileges when creating package
PostGreSQL - Rename database
SQL Server 2005 implementation of MySQL REPLACE INTO?