headers
bhaskarReddy | 1 Feb 07:11
Picon

Delete data base.


Hi Friends,

             is it possible to delete a database with DROP command.

           ex: DROP DATABASE dbName;

Regards,
Baskar Reddy.
--

-- 
View this message in context: http://old.nabble.com/Delete-data-base.-tp33241353p33241353.html
Sent from the SQLite mailing list archive at Nabble.com.
Permalink | Reply | 1 comment |
headers
Taleeb Anwar | 1 Feb 07:17
Picon

Re: Delete data base.

No!

Try deleting the database file instead (right click - delete)

Thanks & Regards
Taleeb bin Waquar

*Hum Mashriq Ke "Miskeenon" Ka Dil Maghrib men Ja Atka Hai!!*

On Wed, Feb 1, 2012 at 11:41 AM, bhaskarReddy <unix08@...> wrote:

>
> Hi Friends,
>
>             is it possible to delete a database with DROP command.
>
>           ex: DROP DATABASE dbName;
>
>
> Regards,
> Baskar Reddy.
> --
> View this message in context:
> http://old.nabble.com/Delete-data-base.-tp33241353p33241353.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@...
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
(Continue reading)

Permalink | Reply | 0 comments |
headers
Taleeb Anwar | 1 Feb 07:26
Picon

Re: SQLite on Visual Studio 2010

Hi Manish,

Try the following (it may work)

1. In Data Source Select "<Other>"
2. In Data Provider Select "..Provider for Ole Db"
3. Click Continue
4. In Ole Db Provider Select "SqlLite"

If this does not work (that is if there is no option for sqlLite in step 4)
then you will have to go for some third party tools...

Thanks & Regards
Taleeb bin Waquar

*Hum Mashriq Ke "Miskeenon" Ka Dil Maghrib men Ja Atka Hai!!*

On Wed, Feb 1, 2012 at 5:26 AM, Agrawal, Manish <magrawal@...> wrote:

> Thanks very much. I tested the first application at the site and it worked!
>
> How can I get the designer support though? I added a reference to
> SQLite.Designer.dll but that was not enough. I am a relative newbie to
> database design and the designer would greatly improve productivity.
>
> Thanks
> Manish
>
> -----Original Message-----
> From: sqlite-users-bounces@... [mailto:
(Continue reading)

Permalink | Reply | 0 comments |
headers
Alok Singh | 1 Feb 07:30
Picon

Re: SQLite on Visual Studio 2010

Don't know which connection provider you are going to use, but ADO.net
guideline is here:

1. Download Sqlite for windows, install it.
2.  Download  ADO.NET 2.0 Provider for SQLite from here and install it :
http://sourceforge.net/projects/sqlite-dotnet2/
3.  Added a reference to the System.Data.SQLite dll in the project on
VS2010.

optional::  you can also use FireFox AddsON and search for Sqlite -> add it
--> use as viewer page to play with Sqlite db or you can use others.

thanks, Alok

On 1 February 2012 04:22, Agrawal, Manish <magrawal@...> wrote:

> Hello
>
>        I am a newbie to both Visual Studio and SQLite, but have a few
> years of Java/ Netbeans/ Glassfish/ MySQL experience.
>
>        I am trying to get started with using SQLite on Visual Studio 2010
> (VS10) but am unable to get a SQLite Data Source type in my project. I
> created a WPF project in VS10 and as suggested in the SQLite FAQ:
>
> 1. Downloaded the pre-compiled binary from the SQLite website and unzipped
> it.
> 2. Created an Externals folder in the project
> 3. Copied the contents of the unzipped folder into Externals
> 4. Added a reference to the System.Data.SQLite dll in the project
(Continue reading)

Permalink | Reply | 1 comment |
headers
Guy Terreault | 1 Feb 08:41
Picon
Favicon

Re: PRAGMA journal_mode=WAL;

Hi, Simon.

I have been reading your back and forth answers like the next 4 responce.

And I am still waiting for the example that works in c code like the one 
that Bill McCormick that is wrong.

Why do you not include in your answer a working correction of the c code 
so that followers can
learn also and try it our selves.

Thanks Guy
On 12-01-31 09:34 AM, Simon Slavin wrote:
> On 31 Jan 2012, at 2:32pm, Bill McCormick wrote:
>
>> Where exactly to I put the PRAGMA journal_mode=WAL; line?
> You execute it as a SQL command, the same way you'd execute an INSERT command.
>
> You only need to do it once for the database file.  The setting is stored with the database and next time
SQLite opens the database file it will still be in WAL mode.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@...
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
Permalink | Reply | 6 comments |
headers
Larry Brasfield | 1 Feb 09:03
Favicon

Re: PRAGMA journal_mode=WAL;

Guy Terreault wrote:
> Hi, Simon.
>
> I have been reading your back and forth answers like the next 4 responce.
>
> And I am still waiting for the example that works in c code like the one
> that Bill McCormick that is wrong.
>
> Why do you not include in your answer a working correction of the c code
> so that followers can
> learn also and try it our selves.
>
> Thanks Guy

If you wish to learn how to drive SQLite from C code, you could peruse 
the API documentation, which is quite thorough. Or you could study the 
code in shell.c which comes with the amalgamation.  In particular, its 
routine known as
static int shell_exec(
   sqlite3 *db,
   const char *zSql,
   int (*xCallback)(void*,int,char**,char**,int*),
   struct callback_data *pArg,
   char **pzErrMsg
)
, and its calling sequence would show you what you seem to wish to learn.

I cannot answer why Simon does not write demo code at every opportunity, 
but I think I speak for more than just myself by revealing that I have 
other work, and a life, and consider time a scarce resource.
(Continue reading)

Permalink | Reply | 4 comments |
headers
bhaskarReddy | 1 Feb 09:07
Picon

File checking mechanism.


Hi Friends,

         Is there any File checking mechanism in sqilte3.

         Suppose i have a file ABCD.db, before i want to create the data
base file, i want to check whether it is already exit with the same or not.
If it is exist returns an error. 

         Is there any sqlite function to do file checking mechanism.

Regards,
Bhaskar Reddy
--

-- 
View this message in context: http://old.nabble.com/File-checking-mechanism.-tp33241633p33241633.html
Sent from the SQLite mailing list archive at Nabble.com.
Permalink | Reply | 2 comments |
headers
Abhinav Upadhyay | 1 Feb 09:08
Picon
Gravatar

Re: File checking mechanism.

On Wed, Feb 1, 2012 at 1:37 PM, bhaskarReddy <unix08@...> wrote:
>
> Hi Friends,
>
>         Is there any File checking mechanism in sqilte3.
>
>         Suppose i have a file ABCD.db, before i want to create the data
> base file, i want to check whether it is already exit with the same or not.
> If it is exist returns an error.
>
>         Is there any sqlite function to do file checking mechanism.
>
>
> Regards,
> Bhaskar Reddy

Just do a stat(2) on the file. (see man 2 stat)

--
Abhinav
Permalink | Reply | 0 comments |
headers
Guy Terreault | 1 Feb 09:32
Picon
Favicon

Re: PRAGMA journal_mode=WAL;

On 12-02-01 03:03 AM, Larry Brasfield wrote:
> Guy Terreault wrote:
>> Hi, Simon.
>>
>> I have been reading your back and forth answers like the next 4 
>> responce.
>>
>> And I am still waiting for the example that works in c code like the one
>> that Bill McCormick that is wrong.
>>
>> Why do you not include in your answer a working correction of the c code
>> so that followers can
>> learn also and try it our selves.
>>
>> Thanks Guy
>
> If you wish to learn how to drive SQLite from C code, you could peruse 
> the API documentation, which is quite thorough. Or you could study the 
> code in shell.c which comes with the amalgamation.  In particular, its 
> routine known as
> static int shell_exec(
>   sqlite3 *db,
>   const char *zSql,
>   int (*xCallback)(void*,int,char**,char**,int*),
>   struct callback_data *pArg,
>   char **pzErrMsg
> )
> , and its calling sequence would show you what you seem to wish to learn.
>
> I cannot answer why Simon does not write demo code at every
(Continue reading)

Permalink | Reply | 3 comments |
headers
Pawl | 1 Feb 10:18
Picon
Favicon

Re: joint two table


Thanks it work. 

I don't know  that sqllite save TIMESTEMP as string, problem is with
counting i have to use helpful function 
like as strftime('%s',timestampevar) .. but ... comparative operator <> =
BETWEEN is right. 

Thanks 

Igor Tandetnik wrote:
> 
> ...
> You probably want something like
> 
> select * from JX, JX_lim lim1 where lim1.rowid = (
>     select rowid from JX_lim lim2
>     where lim2.edittime <= JX.starttime
>     order by lim2.edittime desc limit 1
> );
> 
> But first you'd need to address the issue with data format that Simon
> pointed out. The way you have it, comparisons won't work right.
> -- 
> Igor Tandetnik
> 
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@...
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
(Continue reading)

Permalink | Reply | 3 comments |

Gmane