On Fri, Aug 1, 2008 at 4:03 PM, Rich Shepard <[EMAIL PROTECTED]>wrote:
> On Fri, 1 Aug 2008, Dwight Ingersoll wrote:
>
> > I have a slew of newbie type questions, ...
>
> Er, what sort of questions? SQL, specific to SQLite, or something else?
>
> Rich
>
SQLite
I have a slew of newbie type questions, and was wondering if there were
other resources (preferably searchable) I could go look at before I start
asking here. I'm pretty sure my questions are of the sort that makes people
roll their eyes thinking "if I see that question one more time"
I'd
On 10/1/07, Olaf Schmidt <[EMAIL PROTECTED]> wrote:
<>
>
> @ Dwight:
> The wrapper at phxsoftware is not ADO-compatible AFAIK.
> (ADO and ADO.NET are two different animals, since
> ADO is part of the COM-world as is VB6)
My bad. I've been using C# lately and didn't realize there was a
>
> I was wondering if SQLite supports the command
> SELECT ... INTO OUTFILE ...
Can't you accomplish this in the programming language you're using to access
the SQLite database? The SQLite command line utility (
http://www.sqlite.org/sqlite.html) has an option for specifying an output
file.
>
> I would lige to give a datagrid.datasource a recordset resulting
> from a query of SQLite, but I do not know how to do, since SQLite
> cannot give me a RecordSet as result (I guess...)
The SQLite wrapper at http://sqlite.phxsoftware.com/ provides ADO access (
i.e. records sets) to SQLite
On 9/7/07, Yves Goergen <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> in a scenario when multiple operations need to be transactionally
> synchronised, I have a file that must be deleted when the database
> records are added successfully, but the database operations must be
> rolled back, if the file
On 9/7/07, Brad Stiles <[EMAIL PROTECTED]> wrote:
>
> Anyway, if I understand what you're saying, I believe what you want is an
> OUTER JOIN.
>
> SELECTT1.COLUMN, T2.COLUMN
> FROM TABLE2 T2
> outer join TABLE1 T1 on T2.COLUMN = T1.COLUMN
>
> That will get all rows from T2, and
On 9/7/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Its to get involved in the development of sqlite.If possible
> move to contrib section.a dream.
If that's the case, I think the first step is to post your proposal, and get
input from the SQLite community as to whether the
I learned SQL before the SQL-92 standard was in place. The database
engines I used (SQL Server and Oracle) have their own proprietary
methods for indicating forced inner outer joins. I haven't looked at
this code in over 10 years, so I'm a little unclear about exactly what
the result set
On 9/6/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
> Im importing data
>
> The data has a unique value, call it MD5 for now that could be a unique
> value for the data.
>
>
>
> Each record that gets imported is converted to MD5, a lookup is done on
> the table for that MD5,
>
> if found it
On 8/23/07, Dennis Achá <[EMAIL PROTECTED]> wrote:
> I cannot open a new SQLite3 database file through the command prompt. In
> the
> windows "run" window, I type "SQLite3 mydatabase.db3" and I get the
> following error
> message:
<>
Using Start Menu/Run is not the most flexible way of
On 8/21/07, Preston, Brian <[EMAIL PROTECTED]> wrote:
<>
> Does anyone have an example of doing an import from a .sql file into an
> existing sqlite3 db? I've tried:
>
> sqlite3 .import
>
> sqlite3 .import |
>
> sqlite3 .import
>
> sqlite3 | .import
>
> and various other permutations.
On 8/20/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
<>
>
> I want to restrict the Artist range to 100 to 199 so that with the id
> I can make my search fast and also I knew with unique id that I need to
> search for the Artist alone.
<>
Considering the small range of data it appears you want to
--- Kiran <[EMAIL PROTECTED]> wrote:
> This make me suspect that there is some point which
> I am missing or may be it is a defect in SQLite.
I wouldn't necessarily call a product defective simply
because it didn't behave in the manner you expected or
wished it to. Considering what I've seen
> Anyone know a simple Windows command line equivalent
> of the cat to dev null command above to put a file
> into OS cache?
The command would be:
type filename.db > nul
but I'm pretty sure that this does not work the same
way under Windows as it does in *Nix.
--- Lee Crain <[EMAIL PROTECTED]> wrote:
> I am working on an application where I am importing
> data for which great care has NOT been taken to
> ensure uppercase and lowercase letters have been
> entered appropriately.
Just a suggestion: This sounds like it's a candidate
for some data
> Is there any way to request the digest form of the
> mailing list?
Subscribe to the digest using:
[EMAIL PROTECTED]
Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
17 matches
Mail list logo
