On Wednesday, September 05, 2007 Simon Davies wrote:
> [...]
> This resolves down to calling a function vxprintf, which has the following
> line:
>while( realvalue>=10.0 && exp<=350 ){ realvalue *= 0.1; exp++; }
> When this line is reached, realvalue has value 98926650.5 and exp value 0.
>
Hi Liam,
In func_ext.c and map.h you're including private sqlite3 header
files: sqliteInt.h, os.h and vdbeInt.h, which change from release
to release.
If you only use the public sqlite3.h header file instead, it has
a greater chance of being compatible with new releases.
--- Liam Healy <[EMAI
OK I have posted a new version of extension-functions.tgz on
sqlite.org/contrib. This version includes definitions for READ_UTF8,
sqlite3ReadUtf8, SKIP_UTF8, sqlite3utf8CharLen, xtra_utf8_bytes,
xtra_utf8_bits, utf_mask taken from the 3.3.13 source code, so it should
continue to work in sqlite 3.4
You're using a third-party C++ SQL wrapper library, not sqlite directly.
#include "Database.h"
#include "Query.h"
You have to link with that library directly, possibly in addition to
libsqlite3.a. You might get a clue as to its name by looking in the
sample makefile provided, or examining th
Hi,
I am new to the world of SQLite3. I am using C++ on Windows XP. For a
development IDE I am using MinGW Developer Studio 2.05. After
downloading SQLite3 I began working with the sample program set and had
no difficulty properly assigning the correct include path to the MingW
compiler;
Also, just to add when you reply back with a different query to the list,
pls post a seperate mail with a appropriate subject line so that more people
might be interested to help you.
Thanks,
Pavan.
On 9/5/07, Clay Dowling <[EMAIL PROTECTED]> wrote:
>
> Nishit,
>
> Much as we believe in helpin
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
Will this function receive the database column values or indexes?
Why don't you read the fine manual?
http://sqlite.org/capi3ref.html#sqlite3_create_function
The function receives an array of sqlite3_value* pointers, one for each
argument. There
On 9/5/07, Cory Nelson <[EMAIL PROTECTED]> wrote:
> On 9/5/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> > What about defining __STD_IEC_559 before the compilation?
> > Acording to this:
> >
> >http://david.tribble.com/text/cdiffs.htm#C99-iec60559
> >
> > C99 allows one to force the compiler to f
On 9/5/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> What about defining __STD_IEC_559 before the compilation?
> Acording to this:
>
>http://david.tribble.com/text/cdiffs.htm#C99-iec60559
>
> C99 allows one to force the compiler to follow the standard, so maybe
> libc does it by default, but the
Nishit,
Much as we believe in helping out new people, I think it is reasonable to
expect that before you ask for helping in using the C interface to SQLite
that you familiarize yourself with C. Looping and logic structures are
something you should learn pretty early on, and if you haven't reached
Check out http://www.lazarusid.com/sqlite3 for a working example.
Clay Dowling
"Severin Müller" wrote:
> Hi
>
> I'm new to sqlite3, and i' have some Problems with my code. I'm trying to
> select data from a table and to save the result in a string. but i have no
> clue how to accomplish this.
>
>
Hi Nuno,
Have tried your suggestion; added __STD_IEC_559 to preprocessor
definitions for the sqlite project in Visual Studio. Same result.
I noted that the preprocessor macro quoted is applicable to C99 and
not C++. So I then tried specifying that Visual Studio compile the
sqlite code as C rather
On 9/5/07, Simon Davies <[EMAIL PROTECTED]> wrote:
[...]
> in sqlite3VdbeMemStringify.
> This resolves down to calling a function vxprintf, which has the following
> line:
>
>while( realvalue>=10.0 && exp<=350 ){ realvalue *= 0.1; exp++; }
>
[...]
> Interestingly, if the line is changed to
>
Hi All,
Here's my 2p...
on XP and VC++ (for my sins!)
The round function works.
sqlite_column_double() returns 98926650.5
The '01' on the end is introduced by calling sqlite_column_text
(in shell.c).
This results in reaching the line
sqlite3_snprintf(NBFS, z, "%!.15g", pMem->r);
in sq
One thing I note is that you have no parameters in your queries, so you
don't need to use sqlite3_bind_text.
Further, you might want to add "else" statements so you can print out
the errmsg if the prepare or step calls are failing.
David
On Wed, 2007-09-05 at 16:35 +0200, "Severin Müller" wrote
Hey
This is correct. This database is just for the users, who send commands to
nickserv. every nickname online is a entry in the database. i plan to change
that later, in case, sqlite encouters problems with 1000 tables in a database,
but for now it really like this.
Original-Nachr
Your SQL-strings seem a little strange. You are trying to select from a
table named as the content of nick, this would assume that you have a
table for each "nick" witch seems unlikely. How is your database modeled?
Severin Müller wrote:
Hey
Sorry for my unclearness. I want to access informat
Look in the Sqlite source for examples. Your function gets the
arguments you specify in the SQL and then your program does whatever you
like with them and returns a result. It could for example perform a
regular expression compare etc.
You register the function with Sqlite when you open a co
Look up the Sqlite API. The sqlite3_column_text call does what you want.
sqlite3_open
sqlite3_prepare
loop
sqlite3_step
if SQLITE_ROW sqlite_column_text;
if SQLITE_DONE sqlite3_finalize; exit
repeat
sqlite3_close
Add your own error tests.
Severin Müller wrote:
How can this be used to "Merge two tables"?
Scott
RaghavendraK 70574 wrote:
Thats great.
If possible Can u please provide a sample,
Will this function receive the database column values or indexes?
regards
ragha
On Wednesday, September 05, 2007 Arjen Markus wrote:
> Doug Currie wrote:
>>I suspect the bug is in the functions that convert between string and
>>double; that's why I keep harping on Steele and White's (and
>>Clinger's) PLDI 1990 papers. What I don't know is why this bug appears
>>in the binar
Thats great.
If possible Can u please provide a sample,
Will this function receive the database column values or indexes?
regards
ragha
**
This email and its attachments contain confidential information fro
Hey
Sorry for my unclearness. I want to access information in a sqlite database and
store it in a std::string or const char*, so i can return it to the callin
function. I have the following code:
std::string get_user_info(const char* nick,int mode)
{
#ifdef _WIN32
const char *filename
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
How to plug custom search algorthim within Sqlite?
For example,
select * from table where a = 'xxx';
Instead of using normal inbuilt search can it be userDefined
function?
Yes. You can use sqlite3_create_function to create a function taking two
p
"Severin Müller" <[EMAIL PROTECTED]> wrote:
Naw, the entire code doesn't work properly.
What's improper about the way it works? What specifically seems to be
the problem?
I just need something where i can save my query results in a string
and return the string...
I seem to have misplaced
How to plug custom search algorthim within Sqlite?
For example,
select * from table where a = 'xxx';
Instead of using normal inbuilt search can it be userDefined function?
regards
ragha
-
To unsubscribe, send email to
Hey
Naw, the entire code doesn't work properly.
I just need something where i can save my query results in a string and return
the string...
Original-Nachricht
> Datum: Wed, 5 Sep 2007 08:30:12 -0400
> Von: "Igor Tandetnik" <[EMAIL PROTECTED]>
> An: "SQLite"
> Betreff: [sqli
"Severin Müller" <[EMAIL PROTECTED]> wrote:
This won't work, because sUsername.assign... will not be accepted
with sqlite3_column_text, because sqlite_column_text if of type const
unsigned char...
Just cast it to const char*
Igor Tandetnik
--
Hi
This won't work, because sUsername.assign... will not be accepted with
sqlite3_column_text, because sqlite_column_text if of type const unsigned
char...
Anyway, the other version with the callback function still gives me headache...
how shall i access the data in my statement, when i have t
Scott Derrick <[EMAIL PROTECTED]> wrote:
Whats the procedure and rules for merging two tables?
Whatever you code them to be. There is no built-in mechanism for merging
two tables, if that's what you are asking. You will have to design and
implement any such mechanism yourself.
Igor Tandetni
nishit sharma <[EMAIL PROTECTED]>
wrote:
my question is it is possible to send variable in sqlite3_exec()
command and get the desired results or
there is different alternate to meet the requirement,
Not with sqlite3_exec. See sqlite3_prepare, sqlite3_bind_*,
sqlite3_step, sqlite3_column_*, sq
On Wed, 2007-09-05 at 19:14 +0800, Halton Huo wrote:
> Hello there,
>
> I just upgrade sqlite from 3.4.1 to 3.5.0, and run tracker, which use
> sqlite to save data.
>
> I got core dump everytime like following:
>
> [EMAIL PROTECTED] ([EMAIL PROTECTED]) signal SEGV (no mapping at the fault
> add
Hello there,
I just upgrade sqlite from 3.4.1 to 3.5.0, and run tracker, which use
sqlite to save data.
I got core dump everytime like following:
[EMAIL PROTECTED] ([EMAIL PROTECTED]) signal SEGV (no mapping at the fault
address) in t_splay at
0xfea296e2
0xfea296e2: t_splay+0x0022: movl
On Wed, 5 Sep 2007 10:54:55 +0200, Andre wrote:
> I use sqlite3_column_type so the SQLITE_NULL
> may actually be on a different [row] than the
> one that actually has data, I will keep
> investigating and report back, I might have
> to use
... sqlite3_column_type() on every row you sqlite3_step
This code is totaly untested. But something like this:
std::string sUsername;
sqlite3 *db;
if( sqlite3_open("db/users.db",&db) ){
// prepare the statement
sqlite3_stmt *oStmt;
if( sqlite3_prepare_v2(db,"SELECT username FROM users WHERE
nick=?",-1,&oStmt,NULL)==
Hi all,
this time i m trying
for(g=x-1000:g<=x+1000;g+=d)
where g is an integer, x is a define statement which is 2000 and d is an
column value
from database.
now i want to print specific values from database on the basis of g by
passing g in the sqlite3_exec() command.
my question is it is possi
hi,
in sqlite3 u r having a function named callback whose third argument is used
to save the
value of a column. u can store that value in an array or in char vairiable
also.
try this
regards
Nishit
On 9/5/07, "Severin Müller" <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> I'm new to sqlite3, and i' have
Hi
I'm new to sqlite3, and i' have some Problems with my code. I'm trying to
select data from a table and to save the result in a string. but i have no clue
how to accomplish this.
Here is a part of my code:
std::string get_user_info(const char* nick,int mode)
{
#ifdef _WIN32
const c
John Machin wrote:
On 5/09/2007 10:13 AM, John Stanton wrote:
John Machin wrote:
On 5/09/2007 6:18 AM, John Stanton wrote:
These are regular floating point numbers, and behave accordingly.
Utter nonsense. round(98926650.5, 1) -> 98926650.501 is a BUG.
Precisely, As I said, regul
Doug Currie wrote:
I suspect the bug is in the functions that convert between string and
double; that's why I keep harping on Steele and White's (and
Clinger's) PLDI 1990 papers. What I don't know is why this bug appears
in the binary from sqlite.org but not in the version I build myself
with gc
I don't want to send any of the developers on a wild goose chase, the
problem might be somewhere else, since you suggested
sqlite3_column_decltype() im thinking that it might be somewhere else in
determining the column type initially I use sqlite3_column_type so the
SQLITE_NULL may actually be on a
I'm using Visual Studio 2005 with wxSQLite3 wrapper. I have this
error at this line :
SQLITE_PRIVATE const unsigned char sqlite3UpperToLower[];
the error says:
.\..\wxsqlite3\sqlite3\src\sqlite3.c(6187) : error C2133:
'sqlite3UpperToLower' : unknown size
any suggestion on how to bypas
>Isn't it time to drop the Win9X support from the default build?
I do not believe that just because Win9x is missing a single required call
justifies dropping support for it altogether!
>I'm thinking that any optimization should be enabled for the majority of
>users. Or if it's not really an o
[EMAIL PROTECTED] wrote:
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, September 4, 2007 3:32:38 PM
Subject: Re: [sqlite] 3.5.0 alpha TryEnterCriticalSection linker error
=?ISO-8859-1?Q?Daniel_=D6nnerby?= <[EMAIL PROTECT
On 9/5/07, Doug Currie <[EMAIL PROTECTED]> wrote:
>
>
> Clinger's) PLDI 1990 papers. What I don't know is why this bug appears
> in the binary from sqlite.org but not in the version I build myself
> with gcc 3.4.5 from SQLite version 3.4.2 source.
>
>
Note it also appears when I compile SQLite from
Should I also try and create a sample database that illustrates the
problem?
Creating a new ticket at:
http://www.sqlite.org/cvstrac/tktnew
does not allow me to attach any file,
I wonder if I do a .dump and then import it would probably fix the
problem as it would reinsert from text, so don't rea
46 matches
Mail list logo