Dan Kennedy wrote:
>
> On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote:
> > I found the nifty ODBC driver for SQLite and have been trying to use
> > it to replace a 2.8 SQlite implementation in some desktop software.
> > It's working very well except for a rather large problem of not
Ultimately what I am trying to do is install the ruby wiki, Instiki. In
doing some research I found that rubys sqlite-lib wasn't compatible with
sqlite3. So i removed sqlite3 to get sqlite2. Later to find out that, oh.
sqlite3-ruby library is the one I needed to use. So now I have to figure out
I really don't know. Will it work the way I think it will? :-)
On 3/3/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote:
> I found the nifty ODBC driver for SQLite and have been trying to use
> it to replace a 2.8 SQlite implementation in some
On 3/4/07, aaron smith <[EMAIL PROTECTED]> wrote:
I'm somewhatenew to the linux world. I'm running a dedicated CenteOS box.
I'm trying to get sqlite3 installed. I've downloaded this binary
http://www.sqlite.org/sqlite-3.3.13.so.gz. gunzip it. I see an
sql.x.x.x.sofile. What do I do with that? if
On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote:
> I found the nifty ODBC driver for SQLite and have been trying to use
> it to replace a 2.8 SQlite implementation in some desktop software.
> It's working very well except for a rather large problem of not being
> able to call the last_id
I'm somewhatenew to the linux world. I'm running a dedicated CenteOS box.
I'm trying to get sqlite3 installed. I've downloaded this binary
http://www.sqlite.org/sqlite-3.3.13.so.gz. gunzip it. I see an
sql.x.x.x.sofile. What do I do with that? if I try to execute it I get
s segmentation
fault.
> but it seems like only changes made through the connection I call the
> function on are counted.
This is correct.
The documentation is misleading and should mention this limitation.
> Is there any way to get the total number of
> changes made through all opened connections?
Get the
I found the nifty ODBC driver for SQLite and have been trying to use
it to replace a 2.8 SQlite implementation in some desktop software.
It's working very well except for a rather large problem of not being
able to call the last_id API functions. I need to get the primary keys
assigned to parent
On 3/3/07, A.J.Millan <[EMAIL PROTECTED]> wrote:
Hi all:
I need a simple search, say:
SELECT someField IN someTable WHERE name LIKE '%xyzetc%';
This is standard SQL syntax, and works just fine in SQLite. It will
match all rows where someField contains the string 'xyzetc'
You can also anchor
A.J.Millan <[EMAIL PROTECTED]> wrote:
I need a simple search, say:
SELECT someField IN someTable WHERE name LIKE '%xyzetc%';
After some search in this list, I'm a bit more confused that before.
For
example after reading literally:
The escape mechanism for LIKE has never been implemented in
Ron Stevens wrote:
I have multiple database connections opened against the same database
and I'm having problems with sqlite3_total_changes(). The docs state:
"This function returns the total number of database rows that have be
modified, inserted, or deleted since the database connection was
Hi,
I have multiple database connections opened against the same database
and I'm having problems with sqlite3_total_changes(). The docs state:
"This function returns the total number of database rows that have be
modified, inserted, or deleted since the database connection was
created using
Hi all:
I need a simple search, say:
SELECT someField IN someTable WHERE name LIKE '%xyzetc%';
After some search in this list, I'm a bit more confused that before. For
example after reading literally:
>The escape mechanism for LIKE has never been implemented in
>SQLite. The work-around is to
I was able to link with UNICOWS and my application now runs on Windows 95
even with the newest revision of SQLITE.
Thanks for the tip.
-Original Message-
From: Roger Binns [mailto:[EMAIL PROTECTED]
Sent: Friday, March 02, 2007 8:20 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]
> T wrote:
> > Last month, Mikey C wrote (in part):
> >
> >> I've had these functions hanging around for some
> time... if anyone
> >> wants the code, please take it.
> >>
> >> I have all the code as a MS Visual Studio 2003
> project. It is based
> >> on source code 3.3.5
> >
> >
> >>
T wrote:
Last month, Mikey C wrote (in part):
I've had these functions hanging around for some time... if anyone
wants the code, please take it.
I have all the code as a MS Visual Studio 2003 project. It is based
on source code 3.3.5
replace(X,Y,Z) Returns the string X with every
I have a business application written that uses SQLite 2.8.16 as the
backend database. I love it and it's been as stable as anyone could
ever hope for. However, I want to move it forward before it's too
late. I'd like to go into it expecting potential problems but from
what I've read the move
On Sat, 3 Mar 2007, [EMAIL PROTECTED] wrote:
Please be assured that I am working diligently to block this kind of spam
on the mailing list. But the spammers keep getting more and more
clever...
Richard,
Yes, they are getting more devious. Most lists are spammed only rarely;
newsgroups
"PayPal" <[EMAIL PROTECTED]> wrote:
> You have received this email because your account
Please be assured that I am working diligently to block
this kind of spam on the mailing list. But the spammers
keep getting more and more clever...
--
D. Richard Hipp <[EMAIL PROTECTED]>
Hi Neil,
Re: " I would like to perform regular expression queries interactively, i.e.
from the sqlite> prompt"I
I'm not sure what operating system you're using, but there are sqlite GUI
utilities that register a REGEX function. In windows, one such free one is
Sqlite3Explorer:
Hello jp,
with DISQLite3, I use the the following colation callback function without
problems:
function SQLite3_Compare_System_NoCase_Ansi(
UserData: Pointer;
l1: Integer; const s1: Pointer;
l2: Integer; const s2: Pointer): Integer;
begin
Result := CompareStringA(LOCALE_SYSTEM_DEFAULT,
21 matches
Mail list logo