Re: [sqlite] Getting Started with Sqlite

On Wed, May 22, 2013 at 7:06 PM, wrote: > > (I think Fehmi diagnosed the problem, that you should not use the "sqlite3" > command when you are already in the "sqlite3" program. This is about > something completely different.) > > If you are using a recent version of

Re: [sqlite] Getting Started with Sqlite

General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Getting Started with Sqlite Message-ID: <capdp6w+fnhiejkvukn7cukg8hyp1umrhgeop1u0bg8lrnvh...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Wed, May 22, 2013 at 11:17 AM, Fehmi Noyan ISI &l

Re: [sqlite] Getting Started with Sqlite

ytes free > > D:\Dev\sqlite3>sqlite3.exe test.db > SQLite version 3.7.14.1 2012-10-04 19:37:12 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> > > > > From: Sean Dzafovic <sdzafo...@gm

Re: [sqlite] Getting Started with Sqlite

Regarding: Either way when I open the shell it gives me a sqlite> prompt, not sqlite3> Yes, I suspect Igor intended sqlite> But to his larger point, am I close to correct in replicating your error below? I strongly suspect you're typing "sqlite3" when you are already inside

Re: [sqlite] Getting Started with Sqlite

On Wed, May 22, 2013 at 10:16 AM, Sean Dzafovic wrote: > > I only downloaded 2 files. The Sqlite shell and the Sqlite .dll listed > under precompiled binaries for windows on the download page. I did not > compile anything. I moved the .dll to the system32 folder and tried to

Re: [sqlite] Getting Started with Sqlite

afovic <sdzafo...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, May 22, 2013 11:38 PM Subject: Re: [sqlite] Getting Started with Sqlite On Wed, May 22, 2013 at 10:59 AM,  <fnoyan...@yahoo.com> wrote: > The dll and exe shou

Re: [sqlite] Getting Started with Sqlite

On Wed, May 22, 2013 at 11:07 AM, Fehmi Noyan ISI wrote: > I think it depends on how you compiled sqlite. I my case, it is dynamically > linked to dll, so I do need the dll file (with a smaller exe size). However, > a static link seems suites better the case for sqlite (how

Re: [sqlite] Getting Started with Sqlite

On Wed, May 22, 2013 at 10:59 AM, wrote: > The dll and exe should be sufficient to run sqlite. > > What version of sqlite are you using? > sqlite3 --version > > Not sure about this, but may it be something related to user privilages? When I start the shell i see SQLite

Re: [sqlite] Getting Started with Sqlite

<adev...@verifeye.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, May 22, 2013 11:31 PM Subject: Re: [sqlite] Getting Started with Sqlite When you open the command prompt you will see something like this: c:\PINTS>sqlite3.exe SQLite versi

Re: [sqlite] Getting Started with Sqlite

When you open the command prompt you will see something like this: c:\PINTS>sqlite3.exe SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> The above clearly indicates version 3.6.10. Others on the list will correct me if I am wrong, but the

Re: [sqlite] Getting Started with Sqlite

The dll and exe should be sufficient to run sqlite. What version of sqlite are you using? sqlite3 --version Not sure about this, but may it be something related to user privilages? On 22/05/2013, at 11:21 PM, Sean Dzafovic wrote: > On Wed, May 22, 2013 at 10:30 AM, Igor

Re: [sqlite] Getting Started with Sqlite

On Wed, May 22, 2013 at 10:30 AM, Igor Tandetnik wrote: > On 5/22/2013 8:58 AM, Sean Dzafovic wrote: >> >> I downloaded the shell and the dll from the sqlite.org site. I put the >> .dll in the windows/system32 folder. However, when I try to create a >> test db using the

Re: [sqlite] Getting Started with Sqlite

On 5/22/2013 8:58 AM, Sean Dzafovic wrote: I downloaded the shell and the dll from the sqlite.org site. I put the .dll in the windows/system32 folder. However, when I try to create a test db using the command "sqlite3 test.db" as per the example, I get "Error: near "sqlite3" :syntax error. What

Re: [sqlite] Getting Started with Sqlite

On Wed, May 22, 2013 at 10:06 AM, Fehmi Noyan ISI wrote: > I do not have this issue with my sqlite 3.7.14 installation in Win7. > > Any more details? Windows XP SP2. Did I forget to download some files? Sean ___ sqlite-users

Re: [sqlite] Getting Started with Sqlite

I do not have this issue with my sqlite 3.7.14 installation in Win7. Any more details? From: Sean Dzafovic To: sqlite-users@sqlite.org Sent: Wednesday, May 22, 2013 10:28 PM Subject: [sqlite] Getting Started with Sqlite I downloaded