Cariotoglou Mike wrote:
>
> I see again that you all miss the point. I DO know how to handle floating
> point. My point is :
>
...
>
> since a solution to this issue is fairly simple, and the applicable audience
> is large, why not provide one?
> the fact that MSSQL will not be able to do the
hi
maybe the GMT is obsolete. The new time-standart becomes BMT
- Biel Mean Time, which is linked up to the Central European
Winter/Standard time - which is UTC + 1 hour (aka internet
time).
regards
e.
Цитат на писмо от John Stanton <[EMAIL PROTECTED]>:
> Brad wrote:
> >> I am looking for a
I see again that you all miss the point. I DO know how to handle floating
point. My point is :
a. a lot of people will make the error indicated. I am sure that they are poor
programmers. I am also sure (judging from some of the questions posted in this
list), that there is a lot of them...
Also be sure to #define THREADSAFE in your project settings if you'll be using
multiple threads.
From: Mike Marshall [mailto:[EMAIL PROTECTED]
Sent: Tue 12/13/2005 2:17 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Trying to compile under VC.NET
Just
Dennis Cote wrote:
John Stanton wrote:
Brad wrote:
I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be
stored in
the database and they should be compared.
If the class you're using has .Value property, or a
John Stanton wrote:
Brad wrote:
I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be
stored in
the database and they should be compared.
If the class you're using has .Value property, or a way to easily
Brad wrote:
I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be stored in
the database and they should be compared.
If the class you're using has .Value property, or a way to easily
transform the date from one format
I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be stored
in
the database and they should be compared.
If the class you're using has .Value property, or a way to easily
transform the date from one format to another,
Hello Dave,
Perhaps I'd have said it's "poor practice" to compare floating point
numbers that way. I think you're right but, the wording changes make an
attack into valid criticism.
C
Wednesday, December 14, 2005, 11:58:11 AM, you wrote:
>>>
>>>select * from test where f=13.06; -- returns no
Hello Henning,
CTime will give you access to the "time_t" field. I just store the
time_t in the DB. It's an unsigned long that represents seconds since
Jan 1, 1970. You can feed a time_t back into CTime to initialize it.
Be aware though that Microsoft is changing what "time(NULL)" returns.
I
>>
>>select * from test where f=13.06; -- returns no data
Pardon me for throwing a bomb, but no good programmer
would ever use = to compare floating point numbers.
Choose a more appropriate representation for your data.
Eric Bohlman wrote:
m christensen wrote:
What you are doing is needs analysis and by definition requires
'help' or input from others. This is not doing YOUR work for you.
On the other hand needs analysis is much more complex than just
asking users what they want.
Most of the time they
Hi,
what is the difference between sqlite3.exe (the command-line
shell) and an application which calls sqlite3_get_table()?
Because the same sql script gives different results! :-)
the script:
In sqlite327.exe:
CREATE TABLE accounts (us TEXT, pw TEXT, md5 TEXT, UNIQUE
(us));
INSERT INTO
m christensen wrote:
What you are doing is needs analysis and by definition requires 'help'
or input from others. This is not doing YOUR work for you.
On the other hand needs analysis is much more complex than just asking
users what they want.
Most of the time they simply don't know.
Hi,
I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be stored in
the database and they should be compared.
Anyone has an idea?
Henning
I missed any reference to Pocket PC. Although there is a look alike
Delphi product for PalmOS there is no support for the Pocket PC.
Unfortunately your only options for Pocket PC seem to be something from
Mickeysoft probably using ODBC or some other kludge for some of your
data (anything non
On 12/14/05, Cariotoglou Mike <[EMAIL PROTECTED]> wrote:
> I now have a concrete example, which actually happened in an
> installation, and helps to demonstrate the severity of the issue:
>
> try this code:
>
> create table test(f double);
> insert into test values(13.04);
> update test set
> If you would just submit the particular query that is causing
> the problem, that would be an enormous help. If you can also
> include the schema for your database, so much the better.
Statement failing in sqlite3_prepare is:
"UPDATE SDDSTORE SET SDD = ?, TIMESTAMP =
thank you both Arjen Markus & John Oliva
I'll try VB - appforge as I know vb reasonably well. Tcl/tk and others
will have to wait
glenn
John Oliva wrote:
You might want to look at using AppForge (www.appforge.com) which takes a
slightly restricted version of VB6, VB.NET and C# and can
"Shields, Daniel" <[EMAIL PROTECTED]> wrote:
>
> I will try and provide a script to reproduce the problem but
> I can't see how to script a prepare/step construct when it is
> not available in the SQL syntax.
>
If you would just submit the particular query that is causing
the problem, that
create table test(f double);
insert into test values(13.04);
update test set f=f+0.02;
select * from test where f=13.06; -- returns no data
Using MS SQL Server 2000, substituting the "float" type (with a range
of -1.79E+308 through 1.79E+308) for your double, I get the same
results, i.e. no
as you may remember, some time ago I raised an issue with floating point
accuracy, and how this may affect sqlite.
I now have a concrete example, which actually happened in an
installation, and helps to demonstrate the severity of the issue:
try this code:
create table test(f double);
insert
"Shields, Daniel" <[EMAIL PROTECTED]> wrote:
> I have a process that consistently crashes preparing a fairly innocuous
> statement.
> Has anyone seen anything similar? Any suggestions for a fix/workaround? The
> stack
> trace of the problem follows.
>
You are, it seems, the person who posted
> You are, it seems, the person who posted ticket #1557.
>
> A stack trace is of little to no help in fixing a problem
> like this. What is needed is a script that when feed into
> the "sqlite" command-line shell will reproduce the problem.
> Send in such a script (or added it to ticket #1557)
Hi Clay, thanks for this, I've found it on the net and will certainly have a
look at the features it provides, as for purchasing it, I don't have two
pennies to rub together at the moment but should be able to get enough
information regarding the product without purchasing it though.
Thanks again
Cariotoglou Mike wrote:
>
> as you may remember, some time ago I raised an issue with floating point
> accuracy, and how this may affect sqlite.
>
> I now have a concrete example, which actually happened in an
> installation, and helps to demonstrate the severity of the issue:
>
> try this
Hi Marc, yes you were clear in your post, I know that you came to my defence
and if it wasn't for yours and Juan's comments this thread would most
certainly have died a death by now but I am continually receiving excellent
comments from people.
I would like to thank you personally aswell Marc,
Hi Gerry, thanks for you comments and words of luck, I will certainly need
them.
Keep all your comments coming people.
Thanks again.
John.
-Original Message-
From: Gerry Snyder [mailto:[EMAIL PROTECTED]
Sent: 13 December 2005 18:07
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]
John,
There's a package often found in the discount aisles of computer stores
called My Database. My father (who doesn't pretend to know anything about
databases or programming) uses it for his business and personal uses. The
tool looked absolutely brilliant from the perspective of making it
I have a process that consistently crashes preparing a fairly innocuous
statement.
Has anyone seen anything similar? Any suggestions for a fix/workaround? The
stack
trace of the problem follows.
Thanks,
Daniel.
[EMAIL PROTECTED] ([EMAIL PROTECTED]) terminated by signal SEGV (no
You might want to look at using AppForge (www.appforge.com) which takes a
slightly restricted version of VB6, VB.NET and C# and can produce output for
many handheld devices (including PPC). Also, you can program in .NET for
the desktop and .NET compact framework for the Pocket PC.
Regards,
John
31 matches
Mail list logo