Re: [sqlite] Reseting total_changes() to 0

"Simon Slavin" wrote... On 29 Aug 2014, at 9:20pm, jose isaias cabrera wrote: Maybe is my lack of SQL knowledge, but I am finding myself having to calculate and keep track of changes Why is the number of changes useful for you to know ? It's not the sort of

Re: [sqlite] Simple SQLite-based spreadsheet?

I use the personal edition of this: http://www.sqliteexpert.com/ And I use this as well because the built-in graph is handy: http://sqlitebrowser.org/ -- Bill Drago Senior Engineer L3 Communications / Narda Microwave East 435 Moreland Road Hauppauge, NY 11788 631-272-5947 /

Re: [sqlite] Simple SQLite-based spreadsheet?

On Fri, 7 Dec 2012 22:05:47 -0500, John Gabriele wrote: >Just checked stackoverflow and found this: >https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ . Might >be what you're after. Thanks. I'll try it, but judging from the screenshots, but it's probably harder

Re: [sqlite] Reseting total_changes() to 0

On 29 Aug 2014, at 9:20pm, jose isaias cabrera wrote: > Maybe is my lack of SQL knowledge, but I am finding myself having to > calculate and keep track of changes Why is the number of changes useful for you to know ? It's not the sort of thing that's useful in pure

Re: [sqlite] Reseting total_changes() to 0

"Richard Hipp" wrote.. On Fri, Aug 29, 2014 at 12:33 AM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: Can total_chages() be set to zero or reset? No. Thanks. Maybe is my lack of SQL knowledge, but I am finding myself having to calculate and keep track of changes by setting

Re: [sqlite] Win32 .def exports != documented APIs ?

Howard Kapustein wrote: > > sqlite3_win32_is_nt > sqlite3_win32_mbcs_to_utf8 > sqlite3_win32_set_directory > sqlite3_win32_sleep > sqlite3_win32_utf8_to_mbcs > sqlite3_win32_write_debug > Jan is correct, these functions are non-portable and are primarily designed for abstracting differences

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

I would add a printf statement in unixDelete rather than rely on a break point working. Of course, it may not be unixDelete that is the problem, we just need to be sure. Do you have a disk on your target system? If you do, perhaps you could try creating the database file on that and see if

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

hi, Andy Ling I have removed the SQLITE_ENABLE_LOCKING_STYLE compile option, so it tell me the error : disk I/o error. but when I set breakpoint in unixdelete funtion , I found it not enter the funtion. I do not know why. You are right! What OS your host system is running

Re: [sqlite] Win32 .def exports != documented APIs ?

2014-08-29 5:22 GMT+02:00 Howard Kapustein : > The Win32 DLL download includes a .def file, but comparing the exports with > the documentation's function page shows several inconsistencies > > > > doc but not .def > > * sqlite3_mutex_held > *

[sqlite] Win32 .def exports != documented APIs ?

The Win32 DLL download includes a .def file, but comparing the exports with the documentation's function page shows several inconsistencies doc but not .def * sqlite3_mutex_held * sqlite3_mutex_notheld * sqlite3_unlock_notify * sqlite3_version (not a real API just a page name

Re: [sqlite] Reseting total_changes() to 0

On Fri, Aug 29, 2014 at 12:33 AM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: > > Greetings! > > Can total_chages() be set to zero or reset? > No. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Have you removed the SQLITE_ENABLE_LOCKING_STYLE compile option? On my vxWorks system, if I open a new database and create a table it always calls unixDelete trying to delete a “database name”-wal file. This doesn’t exist so it has to handle the error. This patch that was added …. #if

Re: [sqlite] String compare scoring functions

Hello Maurizio, 1) Logical answer Comparing two addresses and getting a similarity score can be a VERY complicated task if your requirements are high enough, and you can buy some very expensive software to perform this. I know because I work with some. 2) Technical answer For such a