This is a very common thing. Many programming languages, like C++, do the
same thing. So it's not just a SQL thing.
--charlie
On Wed, Apr 30, 2014 at 7:11 AM, Marc L. Allen
wrote:
> Not an error. Int/Int uses integer division and results in an integer
> number. When one number is a float, the re
On Apr 30, 2014, at 8:50 PM, Jay Kreibich wrote:
> Given Oracle’s legacy, it might be that “2” defaults to a “numeric” type,
> rather than an integer.
Indeed, there are no ‘integer’ type per se in Oracle. At least not at the SQL
level. But more to the point, I don’t thing the various ANSI sta
I don't know if it's in the SQL standard or not, but the C, C++ and C#
languages all act this way. The result of mathematical operations on integers
is always an integer. If you want the result to be a floating-point number,
you have to force at least one of the operands to be a floating-point
Hi @all,
I want to link a table of my Database dynamically on runtime. I use the
following code in my Access2007 DB
Dim tdf As DAO.TableDef
Set tdf = CurrentDb.CreateTableDef("tableName")
tdf.Connect = "ODBC;DRIVER=SQLite3 ODBC Driver;Database=C:\SQLite\MyDB.sqlite;"
tdf.SourceTableName = "LiteT
On Apr 30, 2014, at 1:00 PM, Petite Abeille wrote:
>
> On Apr 30, 2014, at 2:22 PM, John McKown wrote:
>
>> PostgreSQL likewise returns 0 for 2/4 and .5 for 2/4.0 . This is likely a
>> part of the SQL standard.
>
> Just to be contrarian, Oracle doesn’t and returns 0.5. Ah!
>
Given Oracl
On Apr 30, 2014, at 2:22 PM, John McKown wrote:
> PostgreSQL likewise returns 0 for 2/4 and .5 for 2/4.0 . This is likely a
> part of the SQL standard.
Just to be contrarian, Oracle doesn’t and returns 0.5. Ah!
___
sqlite-users mailing list
sqlite-us
I have set busy time out for 5 seconds and given different names for every
attach and detaching database. still, this error is not getting fixed.
prepare, step and finalize are not throwing any errors.
What is the alternative solution for attach and detaching database? Thanks
in advance.
On Sun,
PostgreSQL likewise returns 0 for 2/4 and .5 for 2/4.0 . This is likely a
part of the SQL standard.
On Wed, Apr 30, 2014 at 7:11 AM, Marc L. Allen
wrote:
> Not an error. Int/Int uses integer division and results in an integer
> number. When one number is a float, the result becomes a float.
>
>
Not an error. Int/Int uses integer division and results in an integer number.
When one number is a float, the result becomes a float.
I don't know about all SQL varieties, but MSSQL is the same.
> On Apr 30, 2014, at 8:04 AM, "Gene Connor" wrote:
>
>
> SELECT DISTINCT 2/4 AS RESULT FROM TAB
SELECT DISTINCT 2/4 AS RESULT FROM TABLE;returns 0
SELECT DISTINCT 2/4.0 AS RESULT FROM TABLE;returns 0.5 (correct)
SELECT DISTINCT 2.0/4 AS RESULT FROM TABLE;returns 0.5 (correct)
SELECT DISTINCT 2.0/4.0 AS RESULT FROM TABLE;returns 0.5 (correct)
SELECT DISTINCT 2.0/4.01 AS RESULT FROM TABLE;retu
Simon Slavin wrote:
> On 29 Apr 2014, at 2:24pm, Drago, William @ MWG - NARDAEAST
> wrote:
>
>> Does closing the connection force, or at least encourage, the OS to write to
>> disk whatever it might have been caching?
>
> Closing a connection calls fclose() on the database file (as long as fop
On 30 Apr 2014, at 8:49am, 김병준 wrote:
> If sqlite3 access storage device directly, I think, it must be faster than
> using os file system.
> Because using os file system mean there must be some overhead.
> So, I'm curious about the reason why use os file system default.
Would you have to write
If sqlite3 access storage device directly, I think, it must be faster than
using os file system.
Because using os file system mean there must be some overhead.
So, I'm curious about the reason why use os file system default.
___
sqlite-users mailing list
13 matches
Mail list logo