You can also use GNU WinCVS, http://www.wincvs.org/download.html
Regards,
Jay
On Fri, Feb 27, 2009 at 3:07 AM, Sherief N. Farouk wrote:
>
>
> On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote:
>
> > Can someone please give me a suggestion for a good client for CVS
> > that runs
> > under Win
You can use the hex code of the non-printable character:
update tableA set field1 = "line1 x'0a' line2"
-Toby
>Are there any docs for how to write SQL for special characters like
>return and linefeed?
>
>On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is
>\n so an SQL might be
"Greg Robertson"
wrote in message
news:151e70a00902261923u203fdcd0yb334e5b87dd3f...@mail.gmail.com
> Are there any docs for how to write SQL for special characters like
> return and linefeed?
>
> On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is
> \n so an SQL might be somethin
Are there any docs for how to write SQL for special characters like
return and linefeed?
On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is
\n so an SQL might be something like:
UPDATE TableA SET Field1 = "line 1\nline 2"
which would produce:
line 1
line 2
in Field1
Is ther
On 27/02/2009 12:09 PM, His Nerdship wrote:
> Does anyone know the sqlite3_mprintf/sqlite3_vmprintf format specifier for
> 64-bit integers?
> I have tried %Ld and %I64d, but it just guillotines the string at that
> point.
> I am using Borland C++ Builder v6.
> Thanks in advance.
Guess: %lld (as in
Does anyone know the sqlite3_mprintf/sqlite3_vmprintf format specifier for
64-bit integers?
I have tried %Ld and %I64d, but it just guillotines the string at that
point.
I am using Borland C++ Builder v6.
Thanks in advance.
--
View this message in context:
http://www.nabble.com/sqlite3_mprintf--
Adobe AIR did not include the FTS module.
I read in this thread
(https://store1.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=75&catid=697&threadid=1417051&enterthread=y)
that they disabled loadable modules.
However, it would have been easy for them to statically include the FTS
(a
On Thu, 26 Feb 2009 17:33:25 -0500, Bryan Lemster
wrote:
>Hello,
>I have a question on sqlite - Is there a good way to launch an
>executable when a table is updated? Thanks.
Not out-of-the-box, but you could write a function in a
loadable extension which forks a process and have that
functi
On Thu, 2009-02-26 at 16:41 -0600, P Kishor wrote:
> candid feedback
>
> http://entropy.homelinux.org/axis/northwind.png nice
> http://entropy.homelinux.org/axis/client_services.png ouch!
It's actually not so bad once you use it a bit. It's an all-in-one CRM
app thingy that does basically everyt
ahhh... my apologies... your screenshots show examples of applications
that can be built with your tool; they are not screenshots of the tool
itself. Never mind my critique.
I do look forward to your packages even though I am mostly a
shell/Perl DBI user and don't really need GUIs.
On Thu, Feb 26
On Thu, Feb 26, 2009 at 4:30 PM, Daniel Kasak
wrote:
> On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote:
>
>> None of these really provide the kind of data entry screens I'd like to
>> have; I have not had time to try OOo Base yet.
>
> Well then. You'll be interested in my projects :)
>
> http:
Hello,
I have a question on sqlite - Is there a good way to launch an
executable when a table is updated? Thanks.
-Bryan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Feb 26, 2009 at 3:37 PM, anjela patnaik wrote:
> Hello all,
>
> I'm new to sqlite3. I have data in a Oracle table with one column being a
> date type. Now, I've exported this table into a sql file with insert
> statements.
>
> Then, I ran the .read command in sqlite3 to read in the sql s
On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote:
> None of these really provide the kind of data entry screens I'd like to
> have; I have not had time to try OOo Base yet.
Well then. You'll be interested in my projects :)
http://entropy.homelinux.org/axis/
( my home server is unfortunately j
On 27/02/2009 8:37 AM, anjela patnaik wrote:
> Hello all,
>
> I'm new to sqlite3. I have data in a Oracle table with one column being a
> date type.
> Now, I've exported this table into a sql file with insert statements.
>
> Then, I ran the .read command in sqlite3 to read in the sql statemen
On Feb 26, 2009, at 4:37 PM, anjela patnaik wrote:
>
> Then, I ran the .read command in sqlite3 to read in the sql
> statements.
> sqlite doesn't support the TO_Date function.
Please send me an example of the TOAD-generated INSERT statement that
includes a TO_Date function.
D. Richard Hipp
Kim Boulton wrote:
> Is there a compiled v3.6.11 sqlite3.exe with the .timer facility
> enabled.
I don't think so for windows -- but I've been wrong many times before. ;)
[From shell.c]
#if !defined(_WIN32) && !defined(WIN32) && . . . .
#include
#include
. . . .
. . . .
#define BEGIN_TIMER beg
On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote:
> Can someone please give me a suggestion for a good client for CVS
> that runs
> under Windows?
>
> I have my linux system but figured it would be nice to have a client
> in both
> places, a belt and suspenders kind of person I guess.
This is a bit of a religious question, but which are the mest/most
popular *nix GUIs out there? I'm using a firefox plugin but not
entirely happy with it. What do you use and why?
A lot depends on what you are trying to accomplish. For example, I move
between several machines, mixed between sever
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
P Kishor wrote:
> hmmm... my amalgamation tarball does have shell.c separately from
> sqlite3.c. You sure you got the right source?
The .zip amalgamation only includes sqlite3.c, sqlite3ext.h and
sqlite3.h. The .tar.gz amalgamation also includes the
Hello all,
I'm new to sqlite3. I have data in a Oracle table with one column being a date
type. Now, I've exported this table into a sql file with insert statements.
Then, I ran the .read command in sqlite3 to read in the sql statements.
sqlite doesn't support the TO_Date function.
How do
Try TortoiseCVS.
- Sherief
On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote:
> Can someone please give me a suggestion for a good client for CVS
> that runs
> under Windows?
>
> I have my linux system but figured it would be nice to have a client
> in both
> places, a belt and suspende
I have yet to find a CVS client that beats the standard command
line client. ;shrug
I've heard plenty of people say good things about TortoiseCVS though.
-T
On Thu, Feb 26, 2009 at 4:28 PM, J. R. Westmoreland wrote:
> Can someone please give me a suggestion for a good client for CVS th
Can someone please give me a suggestion for a good client for CVS that runs
under Windows?
I have my linux system but figured it would be nice to have a client in both
places, a belt and suspenders kind of person I guess.
Thanks,
J. R.
J. R. Westmoreland
E-mail: j..
I'm sure I have the right stuff but in my spooling through the file I could
have over looked it.
I also have a copy of the CVS tree and now I have the right file I'll look
there. Much easier to find things. :)
Thanks again,
J. R.
J. R. Westmoreland
E-mail: j...@jrw.org
On Thu, Feb 26, 2009 at 3:06 PM, J. R. Westmoreland wrote:
> Thanks, I got the amalgamated source and didn't see it there. I'll try that.
hmmm... my amalgamation tarball does have shell.c separately from
sqlite3.c. You sure you got the right source?
>
>
> J. R. Westmoreland
Thanks, I got the amalgamated source and didn't see it there. I'll try that.
J. R. Westmoreland
E-mail: j...@jrw.org
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor
Sent: Thursday, February 26, 2
On Thu, Feb 26, 2009 at 2:50 PM, J. R. Westmoreland wrote:
> Where do I find the source to the command-line tool. I looked but didn't see
> it.
> Sorry if this should be obvious. :)
download the source and search for it, or, you can browse the CVS
tree. Here is the link to shell.c
http://www.sql
Where do I find the source to the command-line tool. I looked but didn't see
it.
Sorry if this should be obvious. :)
J. R.
J. R. Westmoreland
E-mail: j...@jrw.org
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Be
Greetings,
This is a bit of a religious question, but which are the mest/most
popular *nix GUIs out there? I'm using a firefox plugin but not
entirely happy with it. What do you use and why?
TIA,
Nuno Magalhães
LU#484677
___
sqlite-users mailing list
sq
jackspratt
wrote:
> I'm doing some research on SQLite. Can anyone list or point me to
> documentaion on distinctly unique features available in SQLite.
Did your research include actually going to SQLite's site and clicking
on Documentation link? The second document at this link is titled
"Dist
Hi Everyone,
I'm doing some research on SQLite. Can anyone list or point me to
documentaion on distinctly unique features available in SQLite. Thanks in
advance!
- Jack
--
View this message in context:
http://www.nabble.com/SQLite-unique-features-tp22232541p22232541.html
Sent from the SQLite m
Kim Boulton
wrote:
> Is there a compiled v3.6.11 sqlite3.exe
with the .timer facility
> enabled.
Not for windows (I
believe) as follows:
[From
shell.c]
#if !defined(_WIN32)
&& !defined(WIN32) && . . .
#include
#include
. .
.
. .
.
#define BEGIN_TIMER
beginTimer()
#define END_TIME
On Wed, 25 Feb 2009 19:51:07 -0500 (EST), Michael
(mrobi...@cs.fiu.edu) wrote:
>Hello users group,
>
>I have been looking in the documentation for sample programs
>in C, but no luck yet.
The source of the sqlite3 commandline tool may serve as an
example. Alternatively, you could take a look at
Greg Robertson
wrote:
> Is it possible with just an SQL to Concatenate the content from
> several records of a single field with perhaps a character inbetween?
>
> For example if I have TableA that has Field1 with the following info
> in Field1:
>
> rec1: How
> rec2: are
> rec3: you
> rec4: ?
Is it possible with just an SQL to Concatenate the content from
several records of a single field with perhaps a character inbetween?
For example if I have TableA that has Field1 with the following info in Field1:
rec1: How
rec2: are
rec3: you
rec4: ?
Would it be possibly using only SQL to o
Hi Ben,
> Unfortunately though I don't have the option of updating it, since I
> am
> using it on a very widespread set of machines which I don't have root
> privileges on...
You don't necessarily have to install the newer SQLite at system
level. You could incorporate it into your app or inst
Hi Leo,
> insert into 'tblName' Values (NULL, 'five');
> create table 'tblRefMaxName' ('ref' integer, 'nn' text);
> insert into 'tblRefMaxName' Values (select max(id) from tblName,
> 'eins');
Apart from the responses already from other posters, you should use
the correct quotes for entities (
On Wed, Feb 25, 2009 at 10:29:59AM -0800, Chris Wedgwood scratched on the wall:
> On Mon, Feb 23, 2009 at 04:28:00PM -0500, D. Richard Hipp wrote:
>
> > Remember: SQLite is not trying to replace Oracle. SQLite is trying
> > to replace fopen().
>
> Exactly. SQLite is *wonderful* for this, and I
It is an embedded system, so the number of users depends on how it is
used. Be aware that it is not a database server like Oracle or DB2, but
is a library of routines to link into your application.
Eversogood wrote:
> Hi,
>
> What is the maximum number of concurrent users for SQLite?
>
> Thanks
>>
>>
>>> kdb "select * from kfz where CRC32=-1509747892;"
>>> 48482364|48|0|0C|00|00|0||20|5B93|-1509747892|||0|GP-T 1006|0
>>> 20209667|20|1|3C|00|32|202880||99|4FBD|-1509747892|||0|FL-AK 98|1
>>> 20209667|20|1|3C|00|32|202880||99|4FBD|-1509747892|||0|FL-AK 98|1
>>
>> What could cause 48482364 t
"Marian Aldenhoevel"
wrote in
message news:49a65fac.5060...@mba-software.de
> I am having a strange problem with a sqlite3 database. See the
> following transcript:
>
>> sqlite3 kdb "select * from kfz where kfznr=48482364;"
>> 48482364|48|0|0C|00|00|0||20|5B93|1746294314|||0|GP-T 1006|0
>
> kfznr
On Feb 26, 2009, at 6:28 AM, Eversogood wrote:
> Hi,
>
> What is the maximum number of concurrent users for SQLite?
>
There is no limit, though writes are serialized.
Your question betrays that you are thinking of SQLite as if it were
any other client/server database engine. It is not. SQLi
Hi Donald,
On Feb 25, 2009, at 3:39 PM, Griggs, Donald wrote:
> Greetings, Tito,
>
> Did you see page:
>http://www.sqlite.org/lang_attach.html
>
>
> Transactions involving multiple attached databases are atomic,
> assuming
> that the main database is not ":memory:".
>
> It then goes on to s
On Mon, Feb 23, 2009 at 04:28:00PM -0500, D. Richard Hipp wrote:
> Remember: SQLite is not trying to replace Oracle. SQLite is trying
> to replace fopen().
Exactly. SQLite is *wonderful* for this, and I would hate to see it
compromised by adding features that really aren't necessary.
There are
Hi,
>> > CREATE TABLE IF NOT EXISTS KFZ (
>
> Is that as reported by the command-line sqlite3 executable program, or
> is it from some script that you hope is the one that was used to create
> the table?
That is from the script I _know_ is the one that created the table. I
will send output f
On 26/02/2009 9:45 PM, John Machin wrote:
> On 26/02/2009 8:23 PM, Marian Aldenhoevel wrote:
>> Hi,
>>
>> I am having a strange problem with a sqlite3 database. See the following
>> transcript:
>>
>> > sqlite3 kdb "select * from kfz where kfznr=48482364;"
>> > 48482364|48|0|0C|00|00|0||20|5B93|1
Hi,
What is the maximum number of concurrent users for SQLite?
Thanks,
Ev
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 26/02/2009 8:23 PM, Marian Aldenhoevel wrote:
> Hi,
>
> I am having a strange problem with a sqlite3 database. See the following
> transcript:
>
> > sqlite3 kdb "select * from kfz where kfznr=48482364;"
> > 48482364|48|0|0C|00|00|0||20|5B93|1746294314|||0|GP-T 1006|0
>
> kfznr is the prima
Hi,
I am having a strange problem with a sqlite3 database. See the following
transcript:
> sqlite3 kdb "select * from kfz where kfznr=48482364;"
> 48482364|48|0|0C|00|00|0||20|5B93|1746294314|||0|GP-T 1006|0
kfznr is the primary key, so this is to be expected. Now two queries as
fired from t
50 matches
Mail list logo