On 22 Dec 2011, at 4:35am, Virparia, Chetan J (GE Energy) wrote:
> Query : Select * from mytable where in ( around 0.2 million
> comma separated values)
Anything that requires handling .2 million things is going to be tricky.
Optimizing this query would be done differently depending on what g
On 22/12/2011 7:25 AM, Matt Young wrote:
select count() from sqlite_master;
No??
...where type='table';
Cheers,
Mohit.
22/12/2011 | 12:51 PM.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sq
Hi,
We have been using SQLite database for a while using single threaded WCF
service for our condition based monitor solution. Since, we are facing
issues related to scalability for our next generation products due to
single threaded architecture, We have been working on using SQLite
concurr
On 22 Dec 2011, at 2:52am, YAN HONG YE wrote:
> I have a question about C binding for sqlite, I have a table like this:
>
> Name Price1 Price2 Sum
> A123 231
> A222 12
> A321 223
>
> how to use functin int sum(price1+price2)
> result to put into
> I have a question about C binding for sqlite. I have seen those for
> integer, float... but I was wondering how to deal with a NUMERIC (x, y)
> type ?
> We can't use float or double, we could loose precision, so maybe with a
> string ?
I have a question about C binding for sqlite, I have a tabl
select count() from sqlite_master;
No??
On Wed, Dec 21, 2011 at 10:32 AM, smallboat wrote:
> Hello,
>
> I have a sqlite file. I would like to open it and know how many tables in
> it.
>
> What is the command line to open a sqlite file and get to know how many
> tables in it? Thanks.
>
> Regards
On Dec 21, 2011, at 11:40 PM, Chris Mets wrote:
> Is this truly a limitation of SQLite or am I doing something wrong?
The later. Simply create your view. Then restrict it.
In other words:
create view foo as select bar from baz
select * from foo where bar = ?
_
When I execute the following SQL statement: select * from test2 where f2 =
@param;
it prompts me correctly for a parameter value.
However, when I try to create a view: create view testview as select * from
test2 where f2 = @param;
I receive the following error message: Parameters are not
There it is, when I printed this value out to a txt file everything was there.
Apparently there is some sort of character limit when displaying strings in
debug mode in Visual Studio 2010, news to me...
Thanks everyone!
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:s
Now, this is a very good test case and explanation what happens, except...
How did you check value of CString testing after iterating though the
entire char array? Did you look at it in your debugger? Maybe your
debugger is not capable of showing CString contents longer than 2048
symbols? The valu
Somthing like
sqlite3 sqlite.file
sqlite> select count(*) from sqlite_master where type = 'table';
/Roger
On 12/21/11 19:32, smallboat wrote:
Hello,
I have a sqlite file. I would like to open it and know how many tables in it.
What is the command line to open a sqlite file and get to know how
On 21 Dec 2011 at 18:32, smallboat wrote:
> I have a sqlite file. I would like to open it and know how many tables in it.
>
> What is the command line to open a sqlite file and get to know how many tables
> in it? Thanks.
See:
http://www.sqlite.org/sqlite.html
and:
http://www.sqlite.org/faq.
So delving further into this has gotten me nothing else; this is the best I
could do to simplify this to understandable steps.
(I'm new to this service so no idea if attachments are allows so sorry about
the length in advance)
I have this code:
sqlite3_stmt* state = NULL;
Hello,
I have a sqlite file. I would like to open it and know how many tables in it.
What is the command line to open a sqlite file and get to know how many tables
in it? Thanks.
Regards,
Joe
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
On Wed, Dec 21, 2011 at 10:41 AM, Jacob A. Camp
wrote:
> I have a line of code that executes that line:
>
> const unsigned char * temp2 = sqlite3_column_text(state, 0);
>
> This queries the database and after the call is complete I pass this value to
> another function. This function then fails b
What does strlen() tell you on the XML before you put it in the table?
Can you boil all this down to one record in a table, and some code so we can
all see what's going on?
Do a .dump of the table and post the code.
See if you can reproduce it in a simple example.
Michael D. Black
Senio
I have a line of code that executes that line:
const unsigned char * temp2 = sqlite3_column_text(state, 0);
This queries the database and after the call is complete I pass this value to
another function. This function then fails because temp2 points to a location
that contains the incomplete te
Jake wrote:
> For the previous post asking what occurs after 2030, there's nothing
What do you mean, nothing? What exactly happens when you try to access p[2030]?
> because the
> returned value is only allocated for those characters.
What makes you believe this?
--
Igor Tandetnik
Simon Slavin writes:
>
>
> On 21 Dec 2011, at 1:31pm, nobre wrote:
>
> > Is there any chance you are storing a \0 char inside the xml ?
>
> Or that you are mixing 8-bit and 16-bit Unicode in such a way that one of
> your
routines thinks that it has read a
> 0x00 termination character ?
>
>
The problem can be fixed by variables bindings patch:
http://sqlite.mobigroup.ru/wiki?name=tclsqlite
I think, you can do same for you lang.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
On 21 Dec 2011, at 1:31pm, nobre wrote:
> Is there any chance you are storing a \0 char inside the xml ?
Or that you are mixing 8-bit and 16-bit Unicode in such a way that one of your
routines thinks that it has read a 0x00 termination character ?
Simon.
___
Is there any chance you are storing a \0 char inside the xml ?
Jacob A. Camp wrote:
>
> Hello,
>
> I've been looking into an issue that a few of our programmers have looked
> at as well and it left us all wondering. Basically, our database has a
> VARCHAR column that has an XML file written to
Jacob A. Camp wrote:
> The field in the database contains 8955 characters and when I execute the
> sqlite3_column_text() on that specific column to access
> the data, the const unsigned char* that's returned only contains 2030
> characters
What do you mean by that? sqlite3_column_text doesn't p
Hello,
I've been looking into an issue that a few of our programmers have looked at as
well and it left us all wondering. Basically, our database has a VARCHAR column
that has an XML file written to it when the object is manipulated. I can use a
tool to view the database file and I can ensure t
24 matches
Mail list logo