I didn't know it is possible to insert multiple rows into a table using a
command like this. Is this just an SQLite feature, or is this part of the
SQL standard?
RobR
On Mon, Sep 2, 2019 at 8:14 AM Dominique Devienne
wrote:
> On Mon, Sep 2, 2019 at 12:52 PM Simon Slavin wrote:
>
> > > One
Why are you storing first_seen in every record? To avoid searching for it
when reports are generated?
On Sat, Aug 31, 2019 at 6:24 AM Rob Willett
wrote:
> Hi,
>
> We have a very similar system that captures traffic incident information
> such as accidents, roadworks, traffic jams and sends
I don't think the cast rounds, though. It just truncates. Am I wrong?
RobR
On Thu, Oct 18, 2018 at 4:13 PM Richard Hipp wrote:
> On 10/18/18, John Harney wrote:
> > Recently figured this out. Seems to work fine
> >
> > trim(trim(round(1.111,0),'0'),'.') = 1
> >
>
> CAST(1.111 AS integer)
What target platforms have you found on which it is unreliable? I haven't
had problems on Win7, but I haven't used it all that much.
RobR
On Thu, Oct 18, 2018 at 2:57 PM Jordy Deweer wrote:
> Larry Brasfield wrote: "Jordy Deweer asks: “Is there a way to use a
> SQLite database in a C#
Why don't you want to use System.Data.SQLite?
On Thu, Oct 18, 2018 at 11:04 AM Jordy Deweer wrote:
> Dear all
>
> I am new to this group and this is my first question here.
>
> My question is as follows:
>
> Is there a way to use a SQLite database in a C# project, without
> installing /
Dumb question: are you sure you're only inserting one record at a time?
Is it possible you're inserting records so fast that the timestamp is the
same for two of them?
On Fri, Sep 14, 2018 at 3:30 PM Andrew Stewart
wrote:
> Hi,
> I am having problems with a database reporting
o have some specific
meaning inside SQL (or at least, inside PostgreSQL). So, although the
query
SELECT * FROM cycle
works, we should probably use
SELECT * FROM "cycle"
to avoid any possible ambiguity.
RobR
On Fri, Sep 14, 2018 at 2:12 PM Rob Richardson
wrote:
> The use of singl
The use of single quotes instead of double quotes in database queries is
not limited to SQLite. That's part of the SQL standard.
RobR
On Fri, Sep 14, 2018 at 2:05 PM David Raymond
wrote:
> Small typo:
>
> SELECT * FROM table2 JOIN table1
> ON table1.rowid = table2.rowid
> WHERE
I have a program reads data from 17 PLCs and writes it into SQLite databases
every minutes. Every midnight, it deletes old data and vacuums the databases.
It's behaving strangely after that. I think the problem begins because the
vacuum operation is still going on at 12:01, when the next
e and adjusts
that string to be in UTC. If the prior string is not in localtime, then the
result of "utc" is undefined.
On Fri, Apr 21, 2017 at 4:24 PM, Stephen Chrzanowski <pontia...@gmail.com>
wrote:
> Because you're converting your UTC time to UTC.
>
> On Fri, Apr 21, 2017 at
Hello!
I'm in the Eastern US time zone, in daylight savings time. I am four hours
earlier than UTC time. I have a column that stores UTC times as Julian times
(floating-point numbers). The latest data point in the table was stored at
about 8:41 this morning (4/21).
I am getting strange
users-boun...@mailinglists.sqlite.org] On
Behalf Of Rob Richardson
Sent: Monday, March 13, 2017 2:23 PM
To: General Discussion of SQLite Database (sqlite-users@mailinglists.sqlite.org)
Subject: [sqlite] How to use parameterized queries in SQLite.Net
Hello again.
Since my attempt to find the official answer for
Sent from my Samsung Galaxy S7 - powered by Three
Original message From: Rob Richardson
<rdrichard...@rad-con.com> Date: 13/03/2017 18:14 (GMT+00:00) To: "General
Discussion of SQLite Database (sqlite-users@mailinglists.sqlite.org)"
<sqlite-users@mailinglists.sqli
Hello again.
Since my attempt to find the official answer for myself has hit a snag, I'll
just ask here.
The examples I've seen for parameterized queries used with the SQLiteCommand
class have shown named parameters, and the names usually begin with an "@"
character. Is that character
The help file that is linked from the System.Data.SQLite home page appears to
have a table of contents but no information. No matter what page I select, the
page does not appear.
RobR
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
Of Donald Griggs
Sent: Monday, March 13, 2017 1:57 PM
To: SQLite mailing list
Subject: Re: [sqlite] Where is the official document for System.Data.SQLite?
On Mon, Mar 13, 2017 at 1:44 PM, Rob Richardson <rdrichard...@rad-con.com>
wrote:
> Where is the official document for
Thank you.
The https://www.sqlite.org/lang_datefunc.html page doesn't seem to make it
clear what strftime() returns. The specification it gives for strftime() is:
strftime(format, timestring, modifier, modifier, ...)
Given the lack of an indication of the return type, it seemed to me to be
-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Richard Hipp
Sent: Wednesday, March 08, 2017 2:28 PM
To: SQLite mailing list
Subject: Re: [sqlite] Why isn't my time formatting working?
On 3/8/17, Rob Richardson <rdrichard...@rad-con.com> wrote:
> Hel
Hello!
I have a table with times stored as strings. I massaged them into a form that
strftime() should be able to work with, but it's not working. Here's a little
query using the string as it is currently formatted:
select strftime('%d/%m/%Y %H:%M:%S', '03/07/2017 13:06:03')
This query
need to do to get this little test program to run?
Thank you very much.
Rob Richardson
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I have to challenge one of your statements. Adobe Camera Raw is not
nearly identical to Lightroom. ACR is Lightroom's editing engine.
When you are editing an image in Lightroom, you are using ACR. ACR
has no need for a database of any kind, unless the XMP file contains a
very tiny database.
A Google search for "USS Yorktown" turned up the following:
"On September 21, 1997, a division by zero error on board the USS Yorktown
(CG-48) Remote Data Base Manager brought down all the machines on the network,
causing the ship's propulsion system to fail."
RobR
-Original Message-
This doesn't sound like an SQLite problem to me. Instead it sounds like a
problem with whatever visualization tool you are using. What tool are you
using? If you can find a user's group for that tool, you may get more helpful
answers there.
RobR
-Original Message-
From:
Igor,
It took me a bit of looking, but I think I understand your query. One question
remains: why did you use the max() function?
Thanks!
RobR
-Original Message-
update adla1 set PFLOPF=(
select case count(*)=1 then max(adl.pflopf) else adla1.pflopf end
from adl where
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
In Igor's post below, what is the meaning of the colon in front of mypid?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Igor Tandetnik
Sent: Wednesday, November 06, 2013 8:45 AM
To: sqlite-users@sqlite.org
Subject:
Thank you. Now, can you show us sample data from your tables before this query
is run?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of dean gwilliam
Sent: Monday, October 07, 2013 10:45 AM
To: sqlite-users@sqlite.org
Your query looks good to me, which probably means I'm missing the same thing
you are. What happens when you run this query?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of dean gwilliam
Sent: Monday, October 07, 2013
Not all of us. Thanks for the list.
RobR, SQLiteSpy user and about to find Navicat.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Simon,
Is there a danger here if firstname is NULL and the LENGTH() function is called
first?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Thursday, May 23, 2013 2:54 PM
To: General Discussion
First idea: include a subject line.
I'm not 100% clear on your message. You said:
" For those entries in table1 where there is a null in t2..."
I'm guessing you wanted to say:
" For those entries in table1 where there is a null in t1..."
Is that right?
RobR
I think you need wildcards:
SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE %T2.Terms%
RobR, not guaranteeing correct syntax
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Gert Van Assche
Sent: Tuesday, March 26,
Seems like a strange thing for VS Designer to do. NULL is not 0.
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Quanren Xiong
Sent: Thursday, January 03, 2013 12:30 PM
To: General Discussion of SQLite Database
There's several GUI-based SQLite tools available now. Maestro was already
mentioned. My favorite is SQLiteSpy because it's fast, even though you can't
insert or update data in its grid view (you have to write insert or update
queries to do that, which I admit is a pain, but most of the time
Do you have your inserts wrapped in a single transaction? It used to be that I
wasn't worrying about transactions in my projects, but I noticed things were
very slow. I realized that it was creating and committing one transaction for
each insert I was doing. When I wrapped all inserts into a
I always turn pre-compiled headers off for every VC++ project. In my opinion,
they are artifacts from a time when processors were a few hundred times slower
than they are now. The benefit in time saved now is far less than the
confusion they cause when something goes wrong.
RobR
Select id, eventdate, eventtype, FROM eventlog WHERE eventtype in
('special') order by eventdate desc limit 3
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of deltagam...@gmx.net
Sent: Thursday, November 08, 2012 3:10 PM
To:
Igor, you didn't read ArbolOne's incomprehensible code correctly. Here it is
with reasonable formatting:
void mySQLite3::setStmt(const Glib::ustring& s)
{
SQLStatement = s;
if (mystmt == NULL)
{
rc =
Why are you concerned about the size of sqlite3.o?
RobR
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Discussion of SQLite Database'
Subject: Re: [sqlite] C++ - WHERE clause - update
Is this a tricky question?
int sqlite3_step(sqlite3_stmt*);
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Richardson
Sent: Thursday, September
What is the value returned from sqlite3_step()?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Arbol One
Sent: Thursday, September 06, 2012 12:14 PM
To: 'General Discussion of SQLite Database'
Subject: [sqlite] C++ -
Many thanks to all of you who took the time to correct my misunderstanding of
basic SQL.
I ran a little test in PostgreSQL (which is the quickest thing I have to play
with), and of course, you are all correct and the query does work as designed.
I was trying to figure out how to think about
Well, I think you want a where clause on your main UPDATE query. What you
wrote will set the frequency of every record in the alpha table to the value
from the beta table, for every record in the beta table that matches an alpha
record. (It's late, I'm tired and that's incoherent. I hope you
Put single quotes around Testitem:
sprintf( sqlquery, "INSERT INTO tblTest ( CINDEX, CDATE, CDESCR, CAMOUNT
) VALUES ( 5, 2012-08-29, 'Testitem', 300 )");
RobR
___
sqlite-users mailing list
sqlite-users@sqlite.org
Are you certain there exist rows in tb1 and tb2 that satisfy the condition?
What happens when you try? Is any error message or number returned? Can you
run the same query inside an SQLite management tool like SQLite Spy? Does it
work there? Please provide us ALL of the relevant information
Igor,
Which of those would be fastest? Or don't you have enough information to tell?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Igor Tandetnik
Sent: Monday, August 06, 2012 9:14 AM
To: sqlite-users@sqlite.org
Don't you have to specify a column type for test_1?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Brandon Pimenta
Sent: Friday, August 03, 2012 9:09 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] AUTO_INCREMENT
OK for now, but for how long? I still think that 140 is going to come back and
bite you in the rear end sometime when you're not expecting it. As I
understand it, you have a short collection of bytes that is the result of
encrypting a short string. You have much less than 140 bytes of data
Is "acceptable" good enough? I admit I haven't played with this function
(actually, I never heard of it until today), but from what I read in the
documentation, the case described looked dangerous to me. SQLITE_STATIC seemed
to me to imply that the contents of the memory used by the sqlite
Return values are your friends. Use them. Store the error code from every
sqlite function call, and if the error code is not SQLITE_OK (NOTE: Check that
that is the correct name.), then display what the error code is. In
particular, what is the return value of your sqlite3_bind_text()
This is a C question, not an SQLite question. But I'll answer it anyway.
You included the function call in your quoted string, so your compiler thinks
it's just random text. You need:
sprint(sql, "insert into student select 3, %s, 22;", ldll("bb"));
RobR
See below.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Thursday, July 26, 2012 8:47 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] MIN() for a timedelta?
On 27 Jul 2012, at
I have some vague memory that exception handling is screwy inside constructors,
and it's better to create a naked object and then fill it in in an Init()
method. But I have no idea where I read that, if it's correct, or even which
language it applies to.
Good luck!
RobR
Does SQLite care about the use of double quotes instead of single quotes?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Davies
Sent: Wednesday, July 11, 2012 5:10 AM
To: General Discussion of SQLite Database
-Original Message-
The System.Data.SQLite managed-only assembly, when the native library
pre-loading code is enabled (which it is by default starting with release
1.0.80.0), will now attempt to detect the processor architecture of the process
it is being loaded into and then it will
The other thing you are not thinking about is that you never know the order of
data in a set. You may think that you want the 5th record that was ever
inserted into the table, but you have no guarantee that a select statement will
return records in the order in which they were inserted. The
Gabor Grothendieck mentioned a new feature of SQLite in 3.7.11:
Queries of the form: "SELECT max(x), y FROM table" returns the value of
y on the same row that contains the maximum x value.
Is that standard SQL behavior? I'd have expected that to return one row for
every row in the
If you deleted record on New Year's Day, you want a query for data on New
Year's Eve to find the record but you don't want a query for data on January
2nd to find it.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Pavel
Disclaimer: I am not in any way an expert!
As I understand things, in SQLite, any value can be stored in any column,
regardless of type. But in C#, the System.Data.SQLite library isn't that
flexible. If the table definition says the column contains integers, then all
data in the table is
In SQLite Expert, I created table "12-345" with no problem, but I noted that
when the new table was displayed, its name was wrapped in square brackets:
"[12-345]". Perhaps you could wrap numeric names in brackets similarly.
Good luck!
RobR
___
This leads me to agree with the person who suggested that a #define someplace
is telling the precompiler to change "not" to something else. There is a
compiler setting that will generate a file with an extension of ".i" that is
the output of the precompiler. You could try doing that and
You may want to add "FailIfMissing=true" to your connection string. It always
surprises me when I successfully connect to a database and then an attempt to
read from a table that I know durn well is there fails.
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org
Thank you, Dr. Hipp. I understand.
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Richard Hipp
Sent: Tuesday, March 13, 2012 7:07 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] No error message
: [sqlite] No error message generated by sqlite_exec()
On Tue, Mar 13, 2012 at 6:43 PM, Rob Richardson <rdrichard...@rad-con.com>wrote:
> Hello!
>
> I am sending a badly formed query string to sqlite_exec(). It is
> giving me error 21 (misuse of library), but it is not
Hello!
I am sending a badly formed query string to sqlite_exec(). It is giving me
error 21 (misuse of library), but it is not giving me an error message. The
value of the pointer sent as the fifth argument of sqlite_exec() is not
changed. Is this expected behavior? Is there something I
Greetings!
What is the best LINQ provider for SQLite?
I'm sorry for posting a question that must have been asked several times in the
past, but the archives of this group do not appear to be searchable. If there
is a way to search the archives, could someone please show me?
RobR
[mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Ralf Junker
Sent: Monday, March 05, 2012 10:37 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] What do people think of SQLite Root?
On 05.03.2012 16:11, Rob Richardson wrote:
> With the latest version, I think you can.
SQLiteSpy g
[mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Ralf Junker
Sent: Monday, March 05, 2012 9:48 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] What do people think of SQLite Root?
On 05.03.2012 14:50, Rob Richardson wrote:
> I keep hoping to find something better, beca
Our company typically uses SQLite Spy for managing SQLite databases. I keep
hoping to find something better, because SQLite Spy does not offer the ability
to edit a table inside a grid. The only way to update data is to use an SQL
UPDATE statement. But nothing else offers the speed of
What kind of JOIN is used when it a type (INNER, OUTER, etc.) is not specified?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Duquette, William H (318K)
Sent: Friday, March 02, 2012 11:23 AM
To: Discussion of
IIRC, there's a connection string option that will choose between creating an
empty database and throwing an exception if you try opening a database that
doesn't exist. Perhaps if that option is set to throw an exception, then the
ATTACH command would fail. Or not.
RobR
In another library, I had to specify "x86" processor because it wasn't designed
for 64-bit machines. Might you need to do that?
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Electric Eddy
Sent: Monday, February 20,
PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] A faster way to insert into a keyless table?
On Feb 14, 2012, at 8:01 PM, Rob Richardson wrote:
> What would be the best way to speed this up?
wrap all your inserts in one transaction. commit at the
Greetings!
I am working on updating an application that has been around for years,
originally written by someone who knew SQLite exists but had very little idea
of how to use it. The application monitors OPC information for 124 bases, with
7-10 tags per base. (Don't worry about what a base
-Original Message
Also, Stephan is quite right: it's not the columns but the values which have
datatypes, and if you're looking at some random SQLite database that wasn't
carefully created the value in r1c1 may be an integer but the value in r2c1 may
be text.
Simon.
Isn't it almost a requirement of a transaction that only one be open at a time
in a database? If there could be more than one transaction, then transaction 1
might start, transaction 2 starts, transaction 1 fails, transaction 1 is rolled
back, and what happens to transaction 2? One could
My deepest apologies for forgetting to change the subject line in my
last post, and thus accidentally hijacking a thread. Here is the
message again, this time with the correct subject.
On Wed, Feb 8, 2012 at 8:44 AM, Rob Richardson <cedriccic...@gmail.com> wrote:
> Greetings!
>
>
The example of a CREATE TRIGGER statement from the help page is:
CREATE TRIGGER update_customer_address UPDATE OF address ON customers
BEGIN
UPDATE orders SET address = new.address WHERE customer_name = old.name;
END;
The use of BEGIN and END to wrap the statement leads me to believe
.
RobR
On 3/23/08, Christian Smith <[EMAIL PROTECTED]> wrote:
> On Fri, Mar 21, 2008 at 10:41:10AM -0400, Rob Richardson wrote:
> > My SQLite library is built from the single translation unit
> > sqlite.c/sqlite.h. That file contains the version number 3.3.17.
> >
My SQLite library is built from the single translation unit
sqlite.c/sqlite.h. That file contains the version number 3.3.17.
I do not have valgrind, but circumstantial evidence that this is a
SQLite problem is strong. When stepping through my code, I see that
my application's memory jumps by
Greetings!
I must be doing something wrong. I've got a simple table with three
columns, a key column, a value column and a timestamp column. There
are 357,000 rows. The timestamps are stored as floating-point numbers
(Julian dates), and the other two fields contain integers. I open the
table,
Greetings!
I must be doing something wrong. I've got a simple table with three
columns, a key column, a value column and a timestamp column. There
are 357,000 rows. The timestamps are stored as floating-point numbers
(Julian dates), and the other two fields contain integers. I open the
table,
imal
point is getting truncated when I read it. Can anyone tell me why
SQLite suddenly thinks this column of floating-point data holds only
integers?
Thanks very much!
Rob Richardson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.or
the idea)
statements.
Thank you very much.
Rob Richardson
RAD-CON INC.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
-prone to me. While I am quite confident that you and your
collaborators checked this code carefully, I would like to see an
explanation of this algorithm to understand it more fully. Maybe I'll
see if I can get the book through an inter-library loan someplace.
Rob Richardson
All right. Smack me upside the head again. I deserve it. SQLite is
open source, so I just had to look in the source code.
RobR
-
To unsubscribe, send email to [EMAIL PROTECTED]
oing to do?
Thank you very much.
Rob Richardson
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
It seems this was discussed just a few days ago. A recent upgrade to
SQLite allows inserts, updates and deletes on tables that are also open
for selection. The changes may or may not appear as I call
sqlite3_step(), but I can live with that.
RobR
? Will the repeated
sqlite3_step() calls on the first statement eventually get the new
record? Or do I just need to be careful that I never have two active
sqlite statements referencing the same table?
Rob Richardson
n clean up by calling sqlite_finalize?
Rob Richardson
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
API that does have that method?
Thank you very much.
Rob Richardson
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
river was specified.
I downloaded and installed the ADO.Net provider, but I did not see
anywhere anything telling me what provider name to use with it.
I can't use a DSN because the database to be opened must be selected by
the user at run time.
How d
Greetings!
I am trying to talk to a small SQLite database through ADO and an ODBC
driver. I want to convert a date to a Julian day before using the date
in a query of a table that could have over a million records. In
SQliteSpy, the query "SELECT julianday('2007-06-05 12:34:56',
'localtime')
e the same trick?
Also, my version of the sqlite library code only has an
sqlite3_get_table() method that uses single-byte characters. Does the
latest code have a Unicode version of this method?
Thank you very much.
Rob Richardson
-Original Message-
From: Will Leshner [mailto:[EMAIL
For the life of me, I can't figure out how to open a database in
DBManager. I looked at it before, tried for an hour, and erased it. I
just tried again, with the same result. If I can't figure out how to do
such an easy thing, I can't trust the program.
RobR
-Original Message-
From:
I can't get SQLiteExplorer to work with my databases. It always gives
me an "unknown file format" error. I believe it's been quite a while
since it was updated.
RobR
-Original Message-
From: Griggs, Donald [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 3:14 PM
To:
somebody please point me to one or the other?
Thank you very much.
Rob Richardson
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
bles in my
database?
Thank you very much.
Rob Richardson
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
won't work from a DOS prompt, I'm
sure it won't work from my program. So, what is the recommended way to
create a new database and its schema from inside a program? In case it
matters, I'll be using Visual C# 2005 and the SQLite.net.dll file from
SourceForge.
Thank you very much!
Rob Ric
not possible to alter a
column at all. There's no ALTER COLUMN clause available for the ALTER
TABLE statement. Is that correct?
Thank you.
Rob Richardson
RAD-CON INC.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
1 - 100 of 121 matches
Mail list logo
