Hello Dr. Hipp:
I have previously reported compiler warnings to you issued
by the Pelles C MS-Windows compiler and you have repaired
them in the following release. This is the first time I have tried
to compile the single file sqlite3.c using the compiler version 3.50
and it reported some
With the suggestion that the problem was a compiler bug
in PellesC for Windows, I posted a message on their forum.
One response suggested a couple of configuration changes
and also said to wait a while because it took a long time to
compile.
So, I let the compiler continue after it had reported a
On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote:
>Greetings!
>imagine this data content,
>c1, c1, c3
>a, 1, 2
>b, 3, 4
>c, 5, 6
>a, 9, 8
>a, 1, 9
>c, 1, 3
>I would like to get a list of all the items in c1. So, the return would be,
>a,
>b,
>c
>I know how to do it
On Sat, 5 May 2007 21:03:27 -0400, jose isaias cabrera wrote:
>Ok, I am going to push my luck. :-) Imagine the same data, what if I
>wanted to get the sum of the other two columns also? I know how to do it
>one at a time, so in this instance I would have to do 3 separate call using
>sum or
You ask too many questions in one go. I will be surprised if anyone
is willing to provide that much assistance all at once.
It appears that you need some more fundamental knowledge about
programming on GNU/Linux and maybe even about programming in C.
Some of your questions are contradictory and
On Mon, 7 May 2007 11:28:57 -0400, Jonathan Kahn wrote:
>Hey all,
> I have tried different things such as reindex and vacuum on my primary key
>auto inc field but I cannot reset it so that things start from one. I
>deleted everything from my table but it still keeps the amount that was
>there
On Thu, 15 Jun 2006 20:12:41 +0100, Adam wrote:
>Hi All,
>I'm creating a database which will look a little like:
>create table main (f1 TEXT, f2 TEXT, f3 TEXT, t1 TEXT, t2 TEXT, tn TEXT);
>f1, f2 and f3 will always be present. Any or all of the ts might be NULL.
>I'd like to prevent entries
On Sun, 18 Jun 2006 00:23:58 -0400, David D Speck wrote:
>Please pardon what may be a rank newbie question, but I'm just starting
>with SQL and have not seen this addressed in the tutorials that I've
>studied.
>I have to compile a single name and address list from many small list
>files. It
On Tue, 20 Jun 2006 15:34:21 +0200, Ralf Junker wrote:
>SQLiteSpy 1.5.4 is released. Changes include:
>* Updated to SQLite3 3.3.6.
>* The schema tree view did not automatically reflect if a table was emptied or
>initial records were being added.
>* The default text encoding for newly
On Wed, 21 Jun 2006 09:24:35 +0200, Ralf Junker wrote:
>>1. SQLiteSpy is able to read and work with database files
>>formatted by versions of Sqlite earlier than 3.3.6 but it also
>>appears to change the database format rather than leave
>>it as it was found.
>>
>>I use php version 5.1.4
On Thu, 22 Jun 2006 12:59:54 +0530, Puneet Goel wrote:
>I am considering using SQL Lite for my purpose. For that i need some help in
>decision making. I have an applivation which nneds to store muliple number
>of messages for a user. Messages will grow over time. Also there can be
>thousands of
On Thu, 22 Jun 2006 18:48:08 +0530, Puneet Goel wrote:
>that there can be multiple incoming SMS/MMS for
>different users at the same time. Also there can be multiple reads too all
>at the same time. Frequency may be high considering there might be thousands
>of users.
>>
>>
>> Open/close of
On Thu, 22 Jun 2006 19:14:35 + (GMT), Fred a wrote:
>But without this problem context, can i :
>- open a (new) database
>- insert some records
>- (don t close db)
>- select field
>...?
You can test this requirement using the sqlite3 command line utility.
There is a tutorial
On Sun, 25 Jun 2006 01:58:10 -0700 (PDT), RohitPatel wrote:
>Intial database will have about 30+ tables, very few records in each of
>these tables, one or two indices on some tables.
For such a small database, why not create it directly on disk? The
time required should be just a one second
On Sat, 24 Jun 2006 20:10:58 -0700 (PDT), onemind wrote:
>I am using the sqlite gui and click import table from csv. I select a txt
>file that contain over 200,000 words in a list. Sqlite works fine with a
>smaller list of 200-300 words but when i import my big list, it hangs for
>ages or
There was a small error in my previous post.
The 'begin transaction;' line was missed when
I copied the text out of the script and editted
it to remove the code around the text.
On Sat, 24 Jun 2006 20:10:58 -0700 (PDT), onemind wrote:
>I am using the sqlite gui and click import table from csv. I
On Sun, 25 Jun 2006 18:24:50 -0700 (PDT), onemind wrote:
>It took over 8 hours, so if anyone could tell me a text command that would
>do this same task of importing a txt file into a table through the sqlite3
>command line that would be great. It must be the gui slowing it down
>somehow.
On Mon, 26 Jun 2006 11:20:59 +0100, Brandon, Nicholas (UK) wrote:
>>The use of sequential numbers as the trailing part of the 'word'
>>results in a continual rebalancing of the b-tree with each insertion.
>Is that right considering it looks like you have not created an index on
>the word
On Mon, 26 Jun 2006 20:03:35 +0200, Edwin Knoppert wrote:
>Just wanted to warn you i can not read a newly created table created with
>the current release and opening it in v3.2.1 (afaik)
>Sorry, i removed the older dll, i overwrote it with the latest and read the
>table instantly.
>Before i
e pragma helps anyway..
>- Original Message -----
>From: "C.Peachment" <[EMAIL PROTECTED]>
>To: <sqlite-users@sqlite.org>
>Sent: Monday, June 26, 2006 8:16 PM
>Subject: Re: [sqlite] v3.2.1 and current differences!
>> On Mon, 26 Jun 2006 20:03:35 +0200, Ed
On Wed, 28 Jun 2006 10:29:47 +0600, blins wrote:
> How to get column description from table using SQL
To get table definition for '':
select sql from sqlite_master where type='table' and name='';
On Wed, 28 Jun 2006 12:40:52 +0600, blins wrote:
>>> How to get column description from table using SQL
>CP> To get table definition for '':
>CP> select sql from sqlite_master where type='table' and name='';
>I need column definition.
Sqlite does not require that columns be typed so
You could include a date/time field somewhere in the database
that is queried on a regular basis by your display function.
Depending on the update rate, you could poll every second,
every minute, or every hour. Any change of value would justify
a full data retrieval and screen refresh.
The update
The solution I have adopted to both of these issues is to:
1. ensure all strings are enclosed by matching quotation marks, and
2. use the question mark substitution form of prepared statement
with subsequent bind of parameters. This can only be done from a
programming language and not the
You are using PHP syntax incorrectly.
You could use the following:
try {
$dbh = new PDO('sqlite:c:\Program Files\Kinetic\BaseStation\BaseStation.sqb');
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "";
die();
$Statement = $dbh->prepare("select * from location");
While this is good advice, I fear the content might be too much for our
impatient petitioner. Learning to crawl before trying to walk or run can
be a poorly understood fact of life for some novices.
On Sat, 08 Jul 2006 11:23:03 +0100, Martin Jenkins wrote:
> You might find it useful to
>take a
Penso que el primer sitio es mas hoy en dia.
No necessita dar disculpa para tu ingles.
No tengamos problemas entender.
Vosotro facilidad con ingles es mejor que nuestro
espanol.
Disculpame, estudio el espanol desde dos anos y
no puedo hablar/escribir facilmente. :-)
On Sat, 8 Jul 2006 15:31:21
What is wrong with using:
select EventID, EventDate, EventTime
order by EventDate, EventTime
group by EventDate;
You have a separate display problem - you want
to put up to three records on the same line. This is
a language and application specific problem. In PHP,
using the PDO module and
the records to find the events, and group them by day. Is this right?
>"C.Peachment" <[EMAIL PROTECTED]> ha scritto: What is wrong with using:
>select EventID, EventDate, EventTime
> order by EventDate, EventTime
> group by EventDate;
>You have a separate disp
If understand your code correctly, this line creates a table with a single
column.
dbConn.createTable("CREATE TABLE " & tblName & "(" & fldName & " " &
fldAttribute & ")")
You describe a user interface to be used to create tables with multiple columns.
You must do one of two
from the listview?
>Many thanks for your help
>John
>On 11/07/06, C.Peachment <[EMAIL PROTECTED]> wrote:
>>
>> If understand your code correctly, this line creates a table with a
>> single column.
>>
>> dbConn.createTable("CREATE TA
Alimentation is the French word and alimentacion is the
Spanish word for "food" or "feed".
In this case the poster is referring to an electrical power failure
on the computer.
On Tue, 08 Aug 2006 11:38:09 +, [EMAIL PROTECTED] wrote:
>"zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL
On Tue, 30 Jan 2007 12:58:01 +, [EMAIL PROTECTED] wrote:
>Last night, a single user (or, at least, a single IP address)
>in China that self-identified as running windows98 and
>Mozilla 4.0 attempted to download sqlite-3.3.12.tar.gz
>24980 times and sqlite-source-3_3_12.zip 25044 times
>over
On Thu, 1 Feb 2007 10:41:25 +0100, anis chaaba wrote:
>I'm cross compiling sqlite3 for arm and there's errors in the
>configure and the makefile generated.
>Do anyone of you cross compiled sqlite3?
>thanks in advance
Using the preprocessed source code in sqlite-source-3_3_12.zip
lets you avoid
On Wed, 14 Jun 2006 03:34:04 -0700 (PDT), RohitPatel wrote:
>But like some other Databases, if SQLite does provide any way to set
>auto-increment for database file by some fixed percentage (say 20%, 40%
>etc.) such that everytime database file reaches some threashould size it
>automatically
35 matches
Mail list logo
