Hi,
I have a problem using sqlite in mac. When I run my application(executable
jar) from Windows OS, it works perfectly.
But when I try to launch the application from Mac, I get the following error
apples-imac:CreateJar apple$ java -jar TreeTable.jar
Unable to load sqlite: java.lang.
UnsatisfiedLi
Sander Jansen wrote:
> I need to store NaNs in my database and able to retrieve them as well.
>
> Since sqlite will give me back 0.0 when I call sqlite3_column_double
> and a result contains a NAN,
> I was wondering what the best way is to retrieve a NAN from the database.
>
> Here's what I current
Michael Schlenker-4 wrote:
>
> htizo schrieb:
>> G'day,
>> Using sqlitev2.8.17 in php5 is there a way to look up a table for similar
>> strings (case insensitive)?
>> i.e. If I have the string "BLADEcatcher"
>> I want to find "blade_catcher" or "bladecatcher1" or even "bladecatcha"
>> so say 60
Alessio Forconi wrote:
>
> Hello everyone,
>
> I am making the first steps with the programming and I want to help
> create a DataTable from a database sqlite with C #.
> Can you give me an example of how do I create it without using a
> dataset?
> Thank you very much for your help.
>
Just in
I need to store NaNs in my database and able to retrieve them as well.
Since sqlite will give me back 0.0 when I call sqlite3_column_double
and a result contains a NAN,
I was wondering what the best way is to retrieve a NAN from the database.
Here's what I currently do in peudo code:
if (sqlite3
jesuscheung wrote:
> if your table's primary key is auto incremented, try:
>
> select max(id) from table
>
> this will be faster than using count()
... but would give incorrect answer if records are ever deleted from the
table.
Igor Tandetnik
___
Actually, Firestorm DAO pretty much does what I want. The problem with
that solution is that it would leave me with the dilemma of limiting
myself to 20 tables or paying for a $1000 license.
I have sqlite-jdbc. It works fine. But using raw jdbc is pretty painful.
I am surprised there are no
On Thu, 8 Jan 2009 15:29:33 +0100, n...@nobswolf.info (Emil
Obermayr) wrote in General Discussion of SQLite Database
:
>Hello list,
>
>I run a Windows XP system and want to "fill" the sqlite-DB through a
>ODBC-connection with data from other databases and then use it on a
>independant server (ligh
if your table's primary key is auto incremented, try:
select max(id) from table
this will be faster than using count()
--
View this message in context:
http://www.nabble.com/How-to-get-the-total-row-number-of-a-table-by-Sqlite-more-efficient%EF%BC%9F-tp20061797p21359430.html
Sent from the SQLi
On Thu, Jan 08, 2009 at 06:30:38AM -0800, liron.levy10 scratched on the wall:
>
> i am trying to use the "insert or replace" query command , and "insert" is
> the command who executed always even though the query is alredy exist. and
> the right command to use is "replace" command
> someone know
I haven't looked much at the source but will give it a shot.Thanks for the
reply.
On Wed, Jan 7, 2009 at 12:31 PM, Kees Nuyt wrote:
> On Wed, 7 Jan 2009 10:25:12 -0800, ed
> wrote in General Discussion of SQLite Database
> :
>
> >Hello, I did not receive a reply to my question.Does anyone have
If you trying to extract data from a sqlite database to a DataTable
here is how you do it using the .Net data provider:
SQLiteConnection conn = new SQLiteConnection("Data
Source=database.db");
conn.Open();
SQLiteDataAdapter apt = new SQLiteDataAdapter("select * f
Hello everyone,
I am making the first steps with the programming and I want to help
create a DataTable from a database sqlite with C #.
Can you give me an example of how do I create it without using a
dataset?
Thank you very much for your help.
___
sql
Do you have a primary key on the table you're running the insert or replace
statement on? I'm assuming you meant the record already exists.
SB
On Thu, Jan 8, 2009 at 9:30 AM, liron.levy10 wrote:
>
> i am trying to use the "insert or replace" query command , and "insert" is
> the command who ex
i am trying to use the "insert or replace" query command , and "insert" is
the command who executed always even though the query is alredy exist. and
the right command to use is "replace" command
someone know what is the problem?
--
View this message in context:
http://www.nabble.com/insert-or-
Hello list,
I run a Windows XP system and want to "fill" the sqlite-DB through a
ODBC-connection with data from other databases and then use it on a
independant server (lighttp on USB-stick).
The sqlite-version I get as ODBC-driver works nicely.
The sqlite-version I get included in PHP as well.
Sorry for noise: the problem was in quite other place.
--
pozdrawiam / regards
Zbigniew Baniewski
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
Reading the paper
http://www.tcl.tk/community/tcl2004/Papers/D.RichardHipp/drh.html
I'm trying to use the ability to work using "in-memory-database". But there
is a problem: sometimes the data doesn't get transferred from memory back
onto disk. The procedure, that I wrote, is fairly simple:
#v+
htizo schrieb:
> G'day,
> Using sqlitev2.8.17 in php5 is there a way to look up a table for similar
> strings (case insensitive)?
> i.e. If I have the string "BLADEcatcher"
> I want to find "blade_catcher" or "bladecatcher1" or even "bladecatcha"
> so say 60% - 70% of characters the same.
sqlite 2
G'day,
Using sqlitev2.8.17 in php5 is there a way to look up a table for similar
strings (case insensitive)?
i.e. If I have the string "BLADEcatcher"
I want to find "blade_catcher" or "bladecatcher1" or even "bladecatcha"
so say 60% - 70% of characters the same.
I hope I've explained that sufficie
Thanks, Igor. That worked perfectly. Time for me to read up on rowid
and the subtleties of subselects.
Regards,
- Robert
On Thu, Jan 8, 2009 at 6:48 AM, Igor Tandetnik wrote:
> select div, team from teams t1 where rowid in
> (select rowid from teams t2 where t1.div = t2.div
> order by wins de
Thanks MikeW,
Is there a way to do strftime %W with another function.
It don't seems to be possible with datetime.
Thanks
PooLpi
2009/1/8 MikeW
> PooLpi writes:
>
> >
> > Hello,
> >
> > Happy new year 2009 to the list ;)
> >
> > I'm working on weeks with Perl (DateTime module) and Sqlite.
>
"Robert Citek"
wrote in message
news:4145b6790901072206u73b367f1g3d377bb6962de...@mail.gmail.com
> How can I construction a SQL query to pick the top three (3) items in
> a group?
>
> I have a list of sports teams which are grouped into divisions, say A,
> B, C, D, etc. At the end of the season I
PooLpi writes:
>
> Hello,
>
> Happy new year 2009 to the list ;)
>
> I'm working on weeks with Perl (DateTime module) and Sqlite.
>
...snip...
> The ISO (ISO8601) definition says that the first week containing a Thursday
> is week #1.
>
> My dates in the database are in this format : -M
--- robert.ci...@gmail.com wrote:
> I am still curious to know if there is a purely SQL way to do the same.
This can be achieved using group_concat:
select div,
rtrim (substr (s, 1, 10)) nr1,
rtrim (substr (s, 1, 10)) nr2,
rtrim (substr (s, 1, 10)) nr3
from (
select div, group_co
Hello,
Happy new year 2009 to the list ;)
I'm working on weeks with Perl (DateTime module) and Sqlite.
With the end of 2008 and the beginning of 2009 :
In my database, if i select dates at the end of 2008, it gives me :
week #51 => 22-28 dec
week #52 => 29-31 dec
at the beginning of 20
Lukas Haase writes:
>
> Hello,
>
> Can somebody tell me why this (simple) query take so much time? This
> query does nothing more than querying a table and JOINing two other
> tables together.
>
... snip ...
>
> Does anybody have an idea what's going wrong here? How can I speed up
> this q
Hello,
In one hand, object persistence framework provide solutions starting from a
description of your DB - object mapping.
Unfortunately, these solutions are not easy to deploy. Does not seem to fit
your need.
In the other hand, if you just want java database access, you can have a
look at sqlit
28 matches
Mail list logo