Dan,
On Sun, Oct 28, 2012 at 10:07 PM, Dan Kennedy wrote:
> On 10/29/2012 07:35 AM, Igor Korot wrote:
>>
>> Hi, ALL,
>> Will I be punished if I call ROLLBACK outside transaction?
>
>
> No. You will be rewarded with an error code though.
Good ;-) I guess I will need to find the error id to return
See this topic http://www.w3schools.com/sql/sql_join.asp for more
information =S and sry about my english =D
2012/10/29 Caio Honma
> prob. u want something like "SELECT t1.score, t1.rank, t2.subrank, t1.game
> FROM table1 t1 LEFT JOIN table2 t2 ON t1.game = t2.game (if game is the
> common colum
On 10/29/2012 07:35 AM, Igor Korot wrote:
Hi, ALL,
Will I be punished if I call ROLLBACK outside transaction?
No. You will be rewarded with an error code though.
To check if an SQLite connection has an open write-transaction:
http://www.sqlite.org/c3ref/get_autocommit.html
Dan.
___
prob. u want something like "SELECT t1.score, t1.rank, t2.subrank, t1.game
FROM table1 t1 LEFT JOIN table2 t2 ON t1.game = t2.game (if game is the
common column on both tables else use the common element)
2012/10/29 Rick Guizawa
> Dear Friends, please help with sqlite query, i have a table like
Dear Friends, please help with sqlite query, i have a table like:
score| rank | game
98| 1 |1615
98| 1 |1615
92| 2 |1615
87| 3 |1615
87| 3 |1615
87| 3 |1615
112 | 1 |1616
94| 2 |1616
94| 2
Igor Korot wrote:
> Will I be punished if I call ROLLBACK outside transaction?
You'll get an error (I would expect SQLITE_MISUSE), but otherwise nothing bad
will happen.
> Thing is I'm trying to write a function in C++ that will be used
> mostly inside transactions
> but the usage will be gener
Hi, ALL,
Will I be punished if I call ROLLBACK outside transaction?
Thing is I'm trying to write a function in C++ that will be used
mostly inside transactions
but the usage will be general. So if there is an error I want to
ROLLBACK, but I don't want
to keep track of where am I: inside transactio
It sounds like you are pushing SQLite well beyond what it was intended to
do. Remember the motto: SQLite is not intended to replace Oracle, it is
intended to replace fopen(). SQLite does a great job for roles such as
data storage for a desktop application, or for databases in cellphones or
other
Thank you. This is what I wanted to hear. And as you already saw from
responses, fragmentation is far from your main problem. I'd like to
point to one particular issue:
> However, we're starting to see problems. There is so much activity on some
> servers that there is never a chance for our chec
On 10/28/12 10:58 AM, Simon Slavin wrote:
On 28 Oct 2012, at 2:48pm, David Barrett wrote:
Wow, I didn't realize this was such a controversial question.
Not particularly controversial, just complicated, and not subject to a good
explanation other than reading lots of documentation about both
On 28 Oct 2012, at 2:48pm, David Barrett wrote:
> Wow, I didn't realize this was such a controversial question.
Not particularly controversial, just complicated, and not subject to a good
explanation other than reading lots of documentation about both engines.
Your description of your setup s
Wow, I didn't realize this was such a controversial question.
I'm a huge sqlite fan. Expensify is built on sqlite. We have a 40GB
database, replicated using our custom distributed transaction layer across
5 severs in three different datacenters.[1] It's been powering all of
Expensify (including
OK. Curiosity is a good thing in certain situations. But could you
kindly tell me what will you do with this information (assuming it's
possible to obtain it of course)?
Pavel
On Sat, Oct 27, 2012 at 11:54 PM, David Barrett wrote:
> I completely understand the wide and varied differences. I'm j
13 matches
Mail list logo