On 1 Sep 2017, at 9:50pm, Simon Slavin wrote:
> you appear to be trying to execute a command with the database name in,
> something like
>
>> "F:\\Temp\\test_database.jdb "VACUUM"
I’ve just realised what’s going on. OP has confused the sqlite3 shell tool
with what it’s like to use the SQLi
> On Sep 1, 2017, at 1:47 PM, Papa wrote:
>
> Yes, right after opening the database, I want o perform a vacuuming so that
> the new tables can be created, writing and/or read.
I don't know how to put this politely, but you seem to be making things up out
of thin air. There's nothing anywhere
ns Alfke
>Sent: Friday, 1 September, 2017 12:46
>To: SQLite mailing list
>Subject: Re: [sqlite] SQL statement and C++
>
>
>
>> On Sep 1, 2017, at 11:23 AM, Papa wrote:
>>
>> I get an error indicating that binary_sql_statement evaluates to
>NULL.
>
>Most o
On 1 Sep 2017, at 9:47pm, Papa wrote:
> Yes, right after opening the database, I want o perform a vacuuming so that
> the new tables can be created, writing and/or read.
You do not need to execute VACUUM to use new tables. In fact the command will
cause a long delay for no useful result, si
On 1 Sep 2017, at 9:24pm, Papa wrote:
> database_name = "F:\\Temp\\test_database.jdb";
and later
>sql_statement_request = database_name + L" \"VACUUM; \" ";
>// Compiled the SQL statement into a byte-code
>rc = sqlite3_prepare_v2(db,
>sql_statement_request.data()
Yes, right after opening the database, I want o perform a vacuuming so
that the new tables can be created, writing and/or read.
On 2017-09-01 4:31 PM, Igor Korot wrote:
Hi,
What are you trying to achieve?
Are you trying to perform a "VACUUM" command on the data base?
Thank you.
On Sep 1, 20
Hi,
What are you trying to achieve?
Are you trying to perform a "VACUUM" command on the data base?
Thank you.
On Sep 1, 2017 2:23 PM, "Papa" wrote:
In this snip, I'd like to show a brief description of what the class member
function should do, in order to ask you if the SQL statement has been
Thanks for your suggestion Jens, I tried it and this is what they report.
---
DEBUGING
---
sqlite3_extended_errcode == 1
sqlite3_errcode == 1
sqlite3_errmsg == near "F": syntax error
---
OK
---
Wha
> On Sep 1, 2017, at 11:23 AM, Papa wrote:
>
> I get an error indicating that binary_sql_statement evaluates to NULL.
Most often that means there's a syntax error in the SQL statement.
You should call sqlite3_errcode() to get the error code, and sqlite3_errmsg()
to get an error message.
—Jen
9 matches
Mail list logo
