Many thanks, it would help.
Csaba
2012/1/16 Vivien Malerba vmale...@gmail.com
2012/1/16 Csaba Jeney csje...@genoid.hu
Is there any way to query the valid savepoints? At least their names?
Many thanks.
AFAIK, the only way to do this is to keep track of each begin, rollback,
add
how to add average value replace the ? to the end of line of this following
database:
ID namesex match chinese english phy chemtotal
CY001 credmale104 112 101 85 99 697
CY002 rosefemale 87 105 98 119 101 693
Hello.
I'm using SQLite in my project that compiles by MSVC 6.0 in
Windows XP. I've upgraded SQLite library from 3.7.8 to
3.7.10 and got a problem. Builds went fine, but when I was
launching my application, I got memory fault. Application
faulted on first call of
Am 17.01.2012 10:50, schrieb YAN HONG YE:
how to add average value replace the ? to the end of line of this following
database:
ID namesex match chinese english phy chemtotal
CY001 credmale104 112 101 85 99 697
CY002 rosefemale 87
Am 17.01.2012 11:20, schrieb Oliver Peters:
Am 17.01.2012 10:50, schrieb YAN HONG YE:
how to add average value replace the ? to the end of line of this
following database:
ID name sex match chinese english phy chem total
CY001 cred male 104 112 101 85 99 697
CY002 rose female 87 105 98 119 101
Hello.
I'm using SQLite in my project that compiles by MSVC 6.0 in
Windows XP. I've upgraded SQLite library from 3.7.8 to
3.7.10 and got a problem. Builds went fine, but when I was
launching my application, I got memory fault. Application
faulted on first call of
darkelf wrote:
MSDN says, that GetFullPathNameW() is present since
Windows 95, so i thought function GetFullPathNameW() can be
used when _WIN32_WINNT is not defined.
I'm unable to locate the MSDN documentation that indicates this.
For now I've just defined _WIN32_WINNT as
I've working on a location aware application that uses GUIDs as the
primary key for related tables. The SQLite R*Tree module is the natural
choice for indexing the image location data but there the issue of the
integer primary key type.
Is it possible to change the primary key type?
Is it
On 17 Jan 2012, at 11:01am, g...@novadsp.com wrote:
I've working on a location aware application that uses GUIDs as the primary
key for related tables. The SQLite R*Tree module is the natural choice for
indexing the image location data but there the issue of the integer primary
key type.
Thanks Simon,
Neither of those things are simple.
Rather than hack an existing library, I recommend that you allow the R*Tree
module to maintain its integer keys and make another (normal, not R*Tree) table
in the same SQLite database to keep the list of GUIDs vs. integer keys.
Ouch :)
Hello, Joe.
Thanks for your reply.
MSDN says, that GetFullPathNameW() is present since
Windows 95, so i thought function GetFullPathNameW() can be
used when _WIN32_WINNT is not defined.
I'm unable to locate the MSDN documentation that indicates this.
I can't find it in WWW, seems like
Mainly grouping sqlite applications in the embedded environment, hopefully
generating some reusable methods of accessing the sqlite internals. One
example might be a reusable method for storing BSON objects, so differing
BSON applications share a common table/column view of BSON.
On Mon, Jan
Hi,
In the documentation for the .dump command for the sqlite3 shell
(http://www.sqlite.org/sqlite.html) there is an ellipsis after the name of
the table, implying that it is possible to specify multiple tables and
have more than one table dumped at once. However in the shell.c source
code, the
Dear sir,
Is there a way to turn off the Pager subsystem of SQLIte application - that is,
not have to deal with declarations and definitions of the functions ** that
make
up the Pager sub-system API?
uo+
As examples:
/* Open and close a Pager connection. */
SQLITE_PRIVATE int
Hi
I have a question on how to enable PENDING LOCK before issuing an
INSERT statement from the C# code.
Do let me know if you can point me to some resources where I can find
the answer or provide me the response.
Regards
Ajay Solanki
+91 98192 54465 tel:%2B91%2098192%2054465
On Mon, Jan 16, 2012 at 11:47 PM, Max Vlasov max.vla...@gmail.com wrote:
On Tue, Jan 17, 2012 at 5:05 AM, John Elrick john.elr...@fenestra.com
wrote:
I can try that approach with BCC. I was concerned that the IDE would be
getting inaccurate information from the .OBJ. Crossing into a
darkelf dark...@ukr.net wrote:
MSDN says, that GetFullPathNameW() is present since
Windows 95, so i thought function GetFullPathNameW() can be
used when _WIN32_WINNT is not defined.
I'm unable to locate the MSDN documentation that indicates this.
I can't find it in WWW, seems like
On Mon, Jan 16, 2012 at 5:36 PM, Richard Hipp d...@sqlite.org wrote:
On Mon, Jan 16, 2012 at 5:31 PM, John Elrick john.elr...@fenestra.com
wrote:
SNIP
This is very curious and perhaps a useful clue. SQLite does call
SNIP
It is a clue that I need a break. While updating the counters to
On 17 Jan 2012, at 6:47am, Solanki, Ajay (GE Energy) wrote:
I have a question on how to enable PENDING LOCK before issuing an
INSERT statement from the C# code.
What do you want SQLite to do instead of a pending lock ?
If you want to disable the locking entirely, you can do it with PRAGMAs.
Solanki, Ajay (GE Energy) ajay.sola...@ge.com wrote:
I have a question on how to enable PENDING LOCK before issuing an
INSERT statement from the C# code.
What do you mean, enable PENDING LOCK? It's not something you can enable or
disable. SQLite will acquire a pending lock on the database
u okafor uo07...@yahoo.com wrote:
Is there a way to turn off the Pager subsystem of SQLIte application - that
is,
not have to deal with declarations and definitions of the functions ** that
make
up the Pager sub-system API?
In what way do you feel you are forced to deal with those
On Mon, Jan 16, 2012 at 8:05 PM, John Elrick john.elr...@fenestra.comwrote:
On Mon, Jan 16, 2012 at 5:31 PM, Richard Hipp d...@sqlite.org wrote:
On Mon, Jan 16, 2012 at 5:13 PM, John Elrick john.elr...@fenestra.com
wrote:
I did this trace through the Delphi IDE and hand copied the call
Hello, Igor.
MSDN says, that GetFullPathNameW() is present since
Windows 95, so i thought function GetFullPathNameW() can be
used when _WIN32_WINNT is not defined.
I'm unable to locate the MSDN documentation that indicates this.
I can't find it in WWW, seems like Microsoft don't
Hi,
I'm using static linking with Delphi and a new function required binding in
3.7.10 - msize (__msize). The problem here is that there's no official way
to query the size of a memory block in Delphi memory manager, at least I'm
not aware of one. Should I solve this anyway (for example by keeping
I attempted all of the above and the call stacks do not change. That leads
me to one of two conclusions:
1. The call stacks are inaccurate
2. There is some side effect which is causing malloc to be called inside
of a procedure which should not be calling malloc.
I've posted an update to
Pavel Ivanov wrote, On 1/17/2012 9:42 AM:
I attempted all of the above and the call stacks do not change. That leads
me to one of two conclusions:
1. The call stacks are inaccurate
2. There is some side effect which is causing malloc to be called inside
of a procedure which should not be
I'm after an application which will allow me to enter data into a sqlite
database using a 'grid' layout of the data. I.e. I want the existing
contents of the database displayed as a table and I want to be able to
click on a field in a row and just edit the data in place. In addition
I want to be
Another example is reusing parts of fossil code in a group ware
application. The two projects might generate a common table view of what a
user is, hence generating some common code to manage user id tables. Then
you have folks doing something completely unrelated, but still using sqlite
and
http://javascriptsource.com/forms/dynamic-table.html
Looks great if you operate from a browser. Can we still get sqlite
embedded into the browser, or do we have to plug it in?
On Tue, Jan 17, 2012 at 8:05 AM, Chris Green c...@isbd.net wrote:
I'm after an application which will allow me to
What happens if my application fails to call sqlite3_close() before it
exits? Does it leave the db in some unknown state or open to corruption?
If I have a daemon type program, will I need to catch signals that try
to close/kill the program and call sqlite3_close() before exiting?
Thanks!!
On Tue, Jan 17, 2012 at 11:51 AM, Bill McCormick wpmccorm...@gmail.comwrote:
What happens if my application fails to call sqlite3_close() before it
exits? Does it leave the db in some unknown state or open to corruption?
If I have a daemon type program, will I need to catch signals that try
On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young wrote:
http://javascriptsource.com/forms/dynamic-table.html
Looks great if you operate from a browser. Can we still get sqlite
embedded into the browser, or do we have to plug it in?
That doesn't really do it for me, it doesn't edit in
Le 17/01/2012 18:15, Chris Green a écrit :
Hello Chris,
You should look at Dojo javascript library, I think they have the widget
you are looking for. Of course you still need the back-end plumbing (PHP
I suppose).
Best wishes
Noël
On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young
On Tue, Jan 17, 2012 at 06:21:48PM +0100, noel.frankinet wrote:
Le 17/01/2012 18:15, Chris Green a écrit :
Hello Chris,
You should look at Dojo javascript library, I think they have the
widget you are looking for. Of course you still need the back-end
plumbing (PHP I suppose).
That seems
On Tue, 17 Jan 2012 11:35:58 +, g...@novadsp.com g...@novadsp.com
wrote:
Thanks Simon,
Neither of those things are simple.
Rather than hack an existing library, I recommend that you allow the R*Tree
module to maintain its integer keys and make another (normal, not R*Tree)
table in the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 17/01/12 05:01, Matt Young wrote:
Mainly grouping sqlite applications in the embedded environment,
hopefully generating some reusable methods of accessing the sqlite
internals.
I'm still totally confused about what you are trying to achieve.
I guess that sqlite3_set_auxdata cannot be called by the xStep
implementation of an aggregate function.
The doc says:
The following two functions may be used by scalar SQL functions to
associate metadata with argument values.
I will try with sqlite3_aggregate_context.
Sorry for the disturbance.
I'm trying to write a function with a sig like this:
int BindParameter(sqlite3_stmt* stmt, int sqlType, const char* pname,
char* value);
Somewhere before the call(s) to BindParameter, I'll have a string that
looks like this:
(FOO=some text value, BAR=3.141, ZIP=45, TIMESTAMP1=01/17/12
I believe the secret is: don't bother.
sqlite does type conversion as needed, so you can just pass the strings
you've parsed out of your larger string to sqlite3_bind_text().
If the issue is that you need to decode your TIMESTAMP1 column to get the
same format as TIMESTAMP2, and you want to use
http://www.c-sharpcorner.com/UploadFile/prasad_1/RegExpressionSample72005040853AM/RegExpressionSample1.aspx
At that site they parse your string using regex in c#, though I did't see a
time stamp test, and their is the equivalent regex functions, many, in a c
libs.
On Tue, Jan 17, 2012 at
Hi All,
Does SQLite support any SQL command to get column datatype of table
like varchar, INTEGER?
Please share example of such command. It would be helpful for me.
Thanking you.
--
Regards,
- Tarun Thakur
___
sqlite-users mailing list
Hi,
I have ICU integrated with SQLITE.
How do I specify a diacritic insensitive search ?.
ex:- when I search for all strings that begin with 'e', the result set
should return all strings that begin with 'e' as well as the accentuated
'e'.
-Sreekumar
David Garfield wrote, On 1/17/2012 7:05 PM:
I believe the secret is: don't bother.
sqlite does type conversion as needed, so you can just pass the strings
you've parsed out of your larger string to sqlite3_bind_text().
Excellent! Exactly what I was looking for.
If the issue is that you need
Well, to begin with, SQLite doesn't exactly have column data types like most
other DBMS, rather, columns have affinities, which might be looked at as
sort of preferences. See http://www.sqlite.org/different.html#typing and
http://www.sqlite.org/datatype3.html#affinity
However, this command
Hello, Joe.
You wrote Tuesday, January 17, 2012, 12:50:35:
For now I've just defined _WIN32_WINNT as 0x500, but not sure is
it correct, and will my application works if it will be launched under
Windows 9X.
This is the correct fix. Also, most modern Windows projects already
have the
I asked this question on the sql_dev list which Richard Hipp told me that
this list was the proper place.
I asked whether it is possible to execute SQLite in 80K of RAM. Well, I can
now tell you that you can, just about.
My environment has no malloc so I used the MEMSYS5 method of internal
46 matches
Mail list logo