I created two tables A and B.
There exists a record which contains B's information.
Now I need to drop table B and delete all its information in table A.
The two actions were wrapped in a transaction,but dropping table always fail.
Error no is
SQLITE_CANTOPENwhich means"Unable to open
Hi Eugene,
On 12 Apr 2009, at 9:53 AM, Eugene Wee wrote:
> Hi,
>
> On Mon, Apr 13, 2009 at 12:40 AM, Tito Ciuro wrote:
>> One question, when I run the command I see that the fragmentation in
>> "All tables" is greater than "All tables and indices". How can that
>> be? The sum of all tables and t
"Rene Claassen"
schrieb im Newsbeitrag
news:64d5d370904090322t2f2b24f2pf8aafb4963fd0...@mail.gmail.com...
> How can I convert it into a string through ODBC? Here is some of my data.
>
> Date_Stamp
> 2009/03/16 10:52
> ...
I assume, this is a "textbased Date" - normally understandable
by most wra
Hi,
On Mon, Apr 13, 2009 at 12:40 AM, Tito Ciuro wrote:
> One question, when I run the command I see that the fragmentation in
> "All tables" is greater than "All tables and indices". How can that
> be? The sum of all tables and their indices doesn't add up (10.6% +
> 7.5% ≠ 9.6%):
From the give
Hi Kees,
On Apr 12, 2009, at 5:27 AM, Kees Nuyt wrote:
> PRAGMA freelist_count; tells you how many pages are free.
> If there are many free pages, you may have a reason to
> vacuum. It doesn't tell anything about the average
> percentage of payload in database pages, which would be
> another reas
On Sat, 11 Apr 2009 20:16:32 -0700, Tito Ciuro
wrote:
>Hi Lawrence,
>
>On Apr 11, 2009, at 7:51 PM, Lawrence Gold wrote:
>
>> I can't offer a formula, but I suggest making it an option for the
>> users of the software, with sufficient warning that it could take some
>> time, as well as a Cancel b
Marcus
thanks for your suggestions. I have of course checked the obvious things
before posting here.
Both the BEGIN EXCLUSIVE and the COMMIT return SQLITE_OK.
Each thread opens its own db handle with sqlite_open and operates on it.
These are completely isolated, they don't know about each other
I have no idea why it doesn't work in that way, it used to
in my application. however, just a few points:
maybe your BEGIN wasn't successful and you didn't realize ?
maybe you run the INSERT on a DB handle that was not the one
that invoked the BEGIN ?
maybe your COMMIT wasn't successful and you di
8 matches
Mail list logo