Forgot to add. I got idea for last method from this[1] post.
[1]
http://sqlite.1065341.n5.nabble.com/fast-string-prefix-matching-td10777.html
On Thu, Aug 2, 2012 at 11:36 PM, Navaneeth.K.N wrote:
> Hello,
>
> I have a table which contains a set of words. These are stored in a table
> called 'pa
Hello,
I have a table which contains a set of words. These are stored in a table
called 'patterns_content' with pattern as unique key. There is a FTS4 table
named 'patterns' which has 'content=patterns_content' set. It will have
only ASCII characters. Something like,
ab
abd
abcd
.
.
Give
OK for now, but for how long? I still think that 140 is going to come back and
bite you in the rear end sometime when you're not expecting it. As I
understand it, you have a short collection of bytes that is the result of
encrypting a short string. You have much less than 140 bytes of data to
On 8/2/2012 8:40 AM, Arbol One wrote:
I was wondering if there is an 'Installer' for Windows 7 that you would
recommend. I want my user to have all the necessary SQLite3 files needed for
my application as well as all the gtkmm files.
You can create installers with WiX (http://wix.sourcefo
I was wondering if there is an 'Installer' for Windows 7 that you would
recommend. I want my user to have all the necessary SQLite3 files needed for
my application as well as all the gtkmm files.
TIA
___
sqlite-users mailing list
sqlite-users@sqlite.
YAN HONG YE wrote:
> char *sql;
> sprintf(sql,"select * from myprivate;");
Start by changing this to
sql = "select * from myprivate;";
> free(sql);
> free(result);
... and dropping these two. You should only free() what you've malloc'ed, and
you haven't malloc'ed either of them.
--
Igor Ta
Thanks Dan,
It was related to having 2 different versions of
sqlite in PHP running, one being 3.6.15, the other 3.7.7.1. I must have
set journal_mode to WAL on the local copy, which was not recognized on
the production server. After setting journal_mode to DELETE, the
production side recognise
On 08/02/2012 02:43 PM, Wim Paulussen wrote:
I have a database giving me the dreaded 'File is encryptes or not a
database' command. I checked for the 'SQlite format 3' part, which is
present. All other databases in the same directory work as expected,
there are no journal files present, so I am
On 2 August 2012 08:28, YAN HONG YE wrote:
.
.
.
> when I use command
> " jii select ccc"
> it shows a problem:
>
> "jii.exe has encountered a problem and needs to close. We are sorry for the
> inconvenience."
>
> I couldn't resolve it.
>
> void query_table(sqlite3 *l_db)
> {
> char **re
I have a database giving me the dreaded 'File is encryptes or not a
database' command. I checked for the 'SQlite format 3' part, which is
present. All other databases in the same directory work as expected,
there are no journal files present, so I am at a loss how to get this
solved. Anyone sugg
You could download the origin zip source file by the link:
www.yycred.com/sqlte_crypto1.zip
when I use command
" jii select ccc"
it shows a problem:
"jii.exe has encountered a problem and needs to close. We are sorry for the
inconvenience."
I couldn't resolve it.
void query_table(sqlite3
sqlite3_bind_text(stat,1,uu2,140,NULL);
change to
sqlite3_bind_blob(stat,1,uu2,140,NULL);
it's ok! thank you!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
12 matches
Mail list logo
