Re: [sqlite] SQLite/LINQ?

[Taleeb Anwar]

Oh sorry! there is no update of dbLinq (as you noted) for some time now.
What about dotconnect for
sqlite<http://www.devart.com/dotconnect/sqlite/features.html>

Thanks & Regards
Taleeb Anwar

*Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*




On Thu, Apr 26, 2012 at 10:12 AM, Taleeb Anwar <taleeban...@gmail.com>wrote:

> I've never tried it - but dblinq <http://code.google.com/p/dblinq2007/>seems 
> to be one option worth trying.
>
> Thanks & Regards
> Taleeb Anwar
>
> *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
>
>
>
>
> On Thu, Apr 26, 2012 at 5:13 AM, Ken godee <k...@perfect-image.com> wrote:
>
>> Is there any way to use
>>
>> SQLite/LINQ/C# - programmatically?
>>
>> I'm new to the C# world and once I read
>> about LINQ it sure seemed the way to go.
>>
>> Maybe I'm missing something but I've really
>> beat this to death trying to find a solution.
>>
>> I'm not using Visual Studio.
>>
>> DBLing is dead.
>>
>> LingPad works great, not sure how. Builds it's own
>> connect.
>>
>> I can use ADO.Net no problem, just seems can't find
>> a Linq provider.
>>
>> So if my thinking is right buy Visual Studio
>> or use ADO.Net seems to be the choice or maybe ALing ($$)
>>
>> Thought I'd give the list a shot before I give up
>> and just resort to ADO.
>>
>> Ideas?
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> __**_
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite/LINQ?

[Taleeb Anwar]

I've never tried it - but dblinq
<http://code.google.com/p/dblinq2007/>seems to be one option worth
trying.

Thanks & Regards
Taleeb Anwar

*Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*




On Thu, Apr 26, 2012 at 5:13 AM, Ken godee <k...@perfect-image.com> wrote:

> Is there any way to use
>
> SQLite/LINQ/C# - programmatically?
>
> I'm new to the C# world and once I read
> about LINQ it sure seemed the way to go.
>
> Maybe I'm missing something but I've really
> beat this to death trying to find a solution.
>
> I'm not using Visual Studio.
>
> DBLing is dead.
>
> LingPad works great, not sure how. Builds it's own
> connect.
>
> I can use ADO.Net no problem, just seems can't find
> a Linq provider.
>
> So if my thinking is right buy Visual Studio
> or use ADO.Net seems to be the choice or maybe ALing ($$)
>
> Thought I'd give the list a shot before I give up
> and just resort to ADO.
>
> Ideas?
>
>
>
>
>
>
>
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue with Session while using SQLLITE database

[Taleeb Anwar]

As the error suggests you need to serialize you session object when using
"State Server". See an example here -
http://nareshkamuni.blogspot.in/2011/12/example-of-stateserver-session-mode-in.html(note
the [serializable] tag).

Maybe someone else may explain which will be a better option (to use state
server or to move the db out) - myself: am just a beginner in .NET and thus
will not try to answer that..

Hope it helps...
Taleeb Anwar

*Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*




On Wed, Apr 11, 2012 at 3:37 PM, Dorababu Meka <dora.m...@gmail.com> wrote:

> Ok but I am using Mysql too in my application if I use that I am getting an
> error as
>
> *Unable to serialize the session state. In 'StateServer' and 'SQLServer'
> mode, ASP.NET will serialize the session state objects, and as a result
> non-serializable objects or MarshalByRef objects are not permitted. The
> same restriction applies if similar serialization is done by the custom
> session state store in 'Custom' mode.*
> On Wed, Apr 11, 2012 at 1:32 PM, Taleeb Anwar <taleeban...@gmail.com>
> wrote:
>
> > Ok. Here's what I guess is happening. You are making changes in you db
> file
> > which is stored inside your bin directory. When there is a change in the
> > bin directory* the App pool recycles *and thus you loose the session
> > variable.
> >
> > There must be several ways of avoiding it - perhaps the following will
> work
> > In your web.config add the following
> >
> > 
> >
> >
> >
> > 
> >
> > Hope it helps...
> >
> > Thanks & Regards
> > Taleeb Anwar
> >
> > *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
> >
> >
> >
> >
> > On Tue, Apr 10, 2012 at 6:26 PM, Dorababu Meka <dora.m...@gmail.com>
> > wrote:
> >
> > > Yeah on Inserting or Updating the session is getting *NULL*
> > >
> > > On Tue, Apr 10, 2012 at 6:25 PM, Taleeb Anwar <taleeban...@gmail.com>
> > > wrote:
> > >
> > > > Of course the value will not be inserted - but just wanted to make
> sure
> > > > that the problem is occurring on insertion..!
> > > >
> > > > Thanks & Regards
> > > > Taleeb Anwar
> > > >
> > > > *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
> > > >
> > > >
> > > >
> > > >
> > > > On Tue, Apr 10, 2012 at 6:23 PM, Dorababu Meka <dora.m...@gmail.com>
> > > > wrote:
> > > >
> > > > > How Can I insert data in to the table if I comment that line as per
> > you
> > > > > said..
> > > > >
> > > > > Session value exists if I comment that line..
> > > > >
> > > > > On Tue, Apr 10, 2012 at 6:20 PM, Taleeb Anwar <
> taleeban...@gmail.com
> > >
> > > > > wrote:
> > > > >
> > > > > > Though I don't know much about .NET...still
> > > > > >
> > > > > > Try the following
> > > > > > Comment the execute non query. Now Click on button 1 (no values
> > will
> > > be
> > > > > > inserted) and then on button 2. Is session value retained or
> lost?
> > > > > >
> > > > > > Thanks & Regards
> > > > > > Taleeb Anwar
> > > > > >
> > > > > > *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > On Tue, Apr 10, 2012 at 5:40 PM, Dorababu Meka <
> > dora.m...@gmail.com>
> > > > > > wrote:
> > > > > >
> > > > > > > This is my code that I have written in .Net
> > > > > > >
> > > > > > > protected void Page_Load(object sender, EventArgs e)
> > > > > > >{
> > > > > > >
> > > > > > >if (!IsPostBack)
> > > > > > >{
> > > > > > >Session["x"] = "session value"; // assigning Session
> > > > > > >}
> > > > > > >}
> > > > > > >
> > > > > > > My code to insert data to the Database is as follows
> > > > > > >
> > > > > > > protected void Button1_Click(object sender, EventArgs e)
> > > > 

Re: [sqlite] Issue with Session while using SQLLITE database

[Taleeb Anwar]

Ok. Here's what I guess is happening. You are making changes in you db file
which is stored inside your bin directory. When there is a change in the
bin directory* the App pool recycles *and thus you loose the session
variable.

There must be several ways of avoiding it - perhaps the following will work
In your web.config add the following







Hope it helps...

Thanks & Regards
Taleeb Anwar

*Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*




On Tue, Apr 10, 2012 at 6:26 PM, Dorababu Meka <dora.m...@gmail.com> wrote:

> Yeah on Inserting or Updating the session is getting *NULL*
>
> On Tue, Apr 10, 2012 at 6:25 PM, Taleeb Anwar <taleeban...@gmail.com>
> wrote:
>
> > Of course the value will not be inserted - but just wanted to make sure
> > that the problem is occurring on insertion..!
> >
> > Thanks & Regards
> > Taleeb Anwar
> >
> > *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
> >
> >
> >
> >
> > On Tue, Apr 10, 2012 at 6:23 PM, Dorababu Meka <dora.m...@gmail.com>
> > wrote:
> >
> > > How Can I insert data in to the table if I comment that line as per you
> > > said..
> > >
> > > Session value exists if I comment that line..
> > >
> > > On Tue, Apr 10, 2012 at 6:20 PM, Taleeb Anwar <taleeban...@gmail.com>
> > > wrote:
> > >
> > > > Though I don't know much about .NET...still
> > > >
> > > > Try the following
> > > > Comment the execute non query. Now Click on button 1 (no values will
> be
> > > > inserted) and then on button 2. Is session value retained or lost?
> > > >
> > > > Thanks & Regards
> > > > Taleeb Anwar
> > > >
> > > > *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
> > > >
> > > >
> > > >
> > > >
> > > > On Tue, Apr 10, 2012 at 5:40 PM, Dorababu Meka <dora.m...@gmail.com>
> > > > wrote:
> > > >
> > > > > This is my code that I have written in .Net
> > > > >
> > > > > protected void Page_Load(object sender, EventArgs e)
> > > > >{
> > > > >
> > > > >if (!IsPostBack)
> > > > >{
> > > > >Session["x"] = "session value"; // assigning Session
> > > > >}
> > > > >}
> > > > >
> > > > > My code to insert data to the Database is as follows
> > > > >
> > > > > protected void Button1_Click(object sender, EventArgs e)
> > > > >{
> > > > >string path = Server.MapPath("bin/sampldb.db");
> > > > >SQLiteConnection conn = new SQLiteConnection("Data Source="
> +
> > > path
> > > > > + "");
> > > > >try
> > > > >{
> > > > >conn.Open();
> > > > >SQLiteCommand cmd = new SQLiteCommand();
> > > > >cmd.Connection = conn;
> > > > >string txt = "insert into stu values(" + TextBox1.Text +
> > > ",'"
> > > > +
> > > > > TextBox2.Text + "')";
> > > > >cmd.CommandType = CommandType.Text;
> > > > >cmd.CommandText = txt;
> > > > >cmd.ExecuteNonQuery();
> > > > >conn.Close();
> > > > >
> > > > >}
> > > > >catch (Exception ex)
> > > > >{
> > > > >Label1.Visible = true;
> > > > >Label1.Text = "Error:" + ex.Message;
> > > > >}
> > > > >}
> > > > >
> > > > > My code to test whether Session exists or not after Inserting data
> is
> > > as
> > > > > follows
> > > > >
> > > > > protected void Button2_Click(object sender, EventArgs e)
> > > > >{
> > > > >if (Session["x"] != null)  // Here after Inserting data and
> > > > > clicking on the next button available my Session value is getting
> > Null
> > > > >{
> > > > >Label1.Visible = true;
> > > > >Label1.Text = Session["x"].ToString();
> > > > > 

Re: [sqlite] Issue with Session while using SQLLITE database

[Taleeb Anwar]

Of course the value will not be inserted - but just wanted to make sure
that the problem is occurring on insertion..!

Thanks & Regards
Taleeb Anwar

*Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*




On Tue, Apr 10, 2012 at 6:23 PM, Dorababu Meka <dora.m...@gmail.com> wrote:

> How Can I insert data in to the table if I comment that line as per you
> said..
>
> Session value exists if I comment that line..
>
> On Tue, Apr 10, 2012 at 6:20 PM, Taleeb Anwar <taleeban...@gmail.com>
> wrote:
>
> > Though I don't know much about .NET...still
> >
> > Try the following
> > Comment the execute non query. Now Click on button 1 (no values will be
> > inserted) and then on button 2. Is session value retained or lost?
> >
> > Thanks & Regards
> > Taleeb Anwar
> >
> > *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
> >
> >
> >
> >
> > On Tue, Apr 10, 2012 at 5:40 PM, Dorababu Meka <dora.m...@gmail.com>
> > wrote:
> >
> > > This is my code that I have written in .Net
> > >
> > > protected void Page_Load(object sender, EventArgs e)
> > >{
> > >
> > >if (!IsPostBack)
> > >{
> > >Session["x"] = "session value"; // assigning Session
> > >}
> > >}
> > >
> > > My code to insert data to the Database is as follows
> > >
> > > protected void Button1_Click(object sender, EventArgs e)
> > >{
> > >string path = Server.MapPath("bin/sampldb.db");
> > >SQLiteConnection conn = new SQLiteConnection("Data Source=" +
> path
> > > + "");
> > >try
> > >{
> > >conn.Open();
> > >SQLiteCommand cmd = new SQLiteCommand();
> > >cmd.Connection = conn;
> > >string txt = "insert into stu values(" + TextBox1.Text +
> ",'"
> > +
> > > TextBox2.Text + "')";
> > >cmd.CommandType = CommandType.Text;
> > >cmd.CommandText = txt;
> > >cmd.ExecuteNonQuery();
> > >conn.Close();
> > >
> > >}
> > >catch (Exception ex)
> > >{
> > >Label1.Visible = true;
> > >Label1.Text = "Error:" + ex.Message;
> > >}
> > >}
> > >
> > > My code to test whether Session exists or not after Inserting data is
> as
> > > follows
> > >
> > > protected void Button2_Click(object sender, EventArgs e)
> > >{
> > >if (Session["x"] != null)  // Here after Inserting data and
> > > clicking on the next button available my Session value is getting Null
> > >{
> > >Label1.Visible = true;
> > >Label1.Text = Session["x"].ToString();
> > > }
> > > }
> > >
> > > This is the over all code I have written in my application
> > >
> > > On Tue, Apr 10, 2012 at 5:35 PM, TeDe <tede_1...@gmx.de> wrote:
> > >
> > > > Am 10.04.2012 11:17, schrieb Dorababu Meka:
> > > > > Hi I am using SQLLITE database in my .net application.
> Unfortunately
> > > if I
> > > > > perform any operation like Insert and performing other operations
> > like
> > > > > getting data from database my Session which was assigned before is
> > > > getting *
> > > > > NULL.* Is this a bug or what, have you fixed this in later
> versions,
> > if
> > > > so
> > > > > please let me know.
> > > > >
> > > > > I am using Visual Studio 2010..
> > > > >
> > > > We have been using System.Data.SQLite for many years, without major
> > > > bugs. So its unlikely you found one. Instead the way you are using
> the
> > > > Framework might be somehow erroneous.
> > > >
> > > > If you ask these kind of questions, please post some lines of
> relevant
> > > > code. With such an unspecific information, nobody is able to help
> you.
> > > >
> > > > Thomas
> > > > ___
> > > > sqlite-users mailing list
> > > > sqlite-users@sqlite.org
> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > > >
> > >
> > >
> > >
> > > --
> > > *Thanks & Regards,*
> > > **
> > > *M.Dorababu*
> > > **
> > > **
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> *Thanks & Regards,*
> **
> *M.Dorababu*
> **
> **
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue with Session while using SQLLITE database

[Taleeb Anwar]

Though I don't know much about .NET...still

Try the following
Comment the execute non query. Now Click on button 1 (no values will be
inserted) and then on button 2. Is session value retained or lost?

Thanks & Regards
Taleeb Anwar

*Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*




On Tue, Apr 10, 2012 at 5:40 PM, Dorababu Meka <dora.m...@gmail.com> wrote:

> This is my code that I have written in .Net
>
> protected void Page_Load(object sender, EventArgs e)
>{
>
>if (!IsPostBack)
>{
>Session["x"] = "session value"; // assigning Session
>}
>}
>
> My code to insert data to the Database is as follows
>
> protected void Button1_Click(object sender, EventArgs e)
>{
>string path = Server.MapPath("bin/sampldb.db");
>SQLiteConnection conn = new SQLiteConnection("Data Source=" + path
> + "");
>try
>{
>conn.Open();
>SQLiteCommand cmd = new SQLiteCommand();
>cmd.Connection = conn;
>string txt = "insert into stu values(" + TextBox1.Text + ",'" +
> TextBox2.Text + "')";
>cmd.CommandType = CommandType.Text;
>cmd.CommandText = txt;
>cmd.ExecuteNonQuery();
>conn.Close();
>
>}
>catch (Exception ex)
>{
>Label1.Visible = true;
>Label1.Text = "Error:" + ex.Message;
>}
>}
>
> My code to test whether Session exists or not after Inserting data is as
> follows
>
> protected void Button2_Click(object sender, EventArgs e)
>{
>if (Session["x"] != null)  // Here after Inserting data and
> clicking on the next button available my Session value is getting Null
>{
>Label1.Visible = true;
>Label1.Text = Session["x"].ToString();
> }
> }
>
> This is the over all code I have written in my application
>
> On Tue, Apr 10, 2012 at 5:35 PM, TeDe <tede_1...@gmx.de> wrote:
>
> > Am 10.04.2012 11:17, schrieb Dorababu Meka:
> > > Hi I am using SQLLITE database in my .net application. Unfortunately
> if I
> > > perform any operation like Insert and performing other operations like
> > > getting data from database my Session which was assigned before is
> > getting *
> > > NULL.* Is this a bug or what, have you fixed this in later versions, if
> > so
> > > please let me know.
> > >
> > > I am using Visual Studio 2010..
> > >
> > We have been using System.Data.SQLite for many years, without major
> > bugs. So its unlikely you found one. Instead the way you are using the
> > Framework might be somehow erroneous.
> >
> > If you ask these kind of questions, please post some lines of relevant
> > code. With such an unspecific information, nobody is able to help you.
> >
> > Thomas
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> *Thanks & Regards,*
> **
> *M.Dorababu*
> **
> **
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Doing an UPDATE after an INSERT

[Taleeb Anwar]

In Sql Server 2005+ you can retrieve the primary key of the last inserted
record by using
SELECT @@IDENTITY

This can then be used to update the row

Thanks & Regards
Taleeb Anwar

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




On Fri, Mar 9, 2012 at 4:57 PM, Christoph P.U. Kukulies
<k...@kukulies.org>wrote:

> I'm using System.Data.SQLite and the following problem comes up:
>
> I'm doing an INSERT of some columns in a TABLE. I have to determine now if
> the INSERT was successful. I'm doing this by putting the INSERT in a try {
> do the insert...and try the UPDATE } catch { do nothing};
>
> In case the INSERT fails because of a KEY clash the UPDATE isn't executed
> either.
> But in case the INSERT is successful I would like to do the UPDATE right
> afterwards on the same ROW that has been inserted last.
> You may argue, why I don't try the full INSERT right away. Reason: a large
> BLOB has to be read inand the statement be prepared.
> And I could safe that, if the INSERT would fail anyway.
>
> Is there something like UPDATE into last ROW that has  been inserted?
>
> --
> Christoph
>
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Relative path to sqlite database

[Taleeb Anwar]

Hi,

Your exe from desktop, perhaps, crashes because it can no longer find the
resources referenced by it (and present in debug folder)

For test purpose you can try ../../db/test.db3

But this will fail on deployment. You need to programmatically find the exe
location. One of the following may help:
1. Appliaction.StartupPath
2. Application.ExecutablePath
3. System.Reflection.Assembly.GetExecutingAssembly()

Thanks and Regards
Taleeb Anwar

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




On Tue, Feb 21, 2012 at 7:02 PM, Pavel Ivanov <paiva...@gmail.com> wrote:

> > Just a quick note though, when I move the .exe file to the desktop and
> double-click on it, it crashes, which suggests that the bin/debug location
> is only applicable when the application is run from within the IDE.
>
> Crash is probably because your desktop folder doesn't have db
> subdirectory where you want your database to be created. All relative
> paths are always relative to the current directory, not to the place
> where EXE file is located or where it was built.
>
>
> Pavel
>
>
> On Mon, Feb 20, 2012 at 10:11 PM, Agrawal, Manish <magra...@usf.edu>
> wrote:
> > Ah, I should have thought of that.
> >
> > When I run the application (Ctrl+F5), the path is created in bin/debug.
> This is also the folder where the .exe file is created.
> >
> > Just a quick note though, when I move the .exe file to the desktop and
> double-click on it, it crashes, which suggests that the bin/debug location
> is only applicable when the application is run from within the IDE.
> >
> > Thanks
> > Manish
> >
> > -Original Message-
> > From: sqlite-users-boun...@sqlite.org [mailto:
> sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
> > Sent: Monday, February 20, 2012 9:51 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] Relative path to sqlite database
> >
> >
> > On 21 Feb 2012, at 2:49am, "Agrawal, Manish" <magra...@usf.edu> wrote:
> >
> >> All the sqlite examples I see use absolute paths to the sqlite database
> in Visual Studio projects, e.g. "C:\users\test\apps\db\test.db3".
> >>
> >> How can I specify the path to the sqlite database relative to the
> application root folder, e.g. "db\test.db3"?
> >
> > Have you tried specifying a filename without a path, just to see where
> the file ends up ?
> >
> > Simon.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_step getting core dumbed.

[Taleeb Anwar]

/*  A Query to find types of each column. */
 str = (char *)malloc(sizeof(char) * 255);
  memset(str, 0, 255);
  strcat(str, "SELECT ");
  for(loopVar = 0; loopVar < noOfColumns; loopVar++)
  {
strcat(str, colNames[loopVar]);
if(loopVar < (noOfColumns -1))
  strcat(str,",");
  }

The problem is, perhaps, in the query created through this loop. An extra
',' will get appended after the last column name. that is if you have two
columns called column1 and column2 so your query will be
SELECT column1,column2, FROM... //(note ',' after column2)

I may be wrong for more or less I've forgotten "C"; but personally I think
the sqlite should be throwing exception...

Thanks & Regards
Taleeb bin Waquar

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




On Thu, Feb 9, 2012 at 3:51 PM, bhaskarReddy  wrote:

>
> HI Friends,
>
>  I dont know why the sqlite3_step getting core dumped.
>
>  #include 
>  #include 
>  #include "sqlitedb1.h"
>  #include 
>  #include 
>  #include 
>  #include 
>  #include 
>
>  int db_retrieve_row(char *db_name, char *table_name, int num_of_keys, char
> * col_names[],column_value_t * col_values);
>
> int main(void)
> {
>  column_type_t enm[2];
>   //   int retVal;
>  char *col_name[3];
>  char *db_name = "LR6002.db";
>  char *table_name = "ONTTable";
>  column_value_t col_val[3];
>
>  enm[0] = COLUMN_TYPE_INT;   // slotId
>  enm[1] = COLUMN_TYPE_STRING;
>
>  col_val[0].number = 1;
>  col_val[1].number = 2;
>  col_val[2].number = 3;
>/* Array of Column Names. */
> col_name[0] = "slotId";
> col_name[1] = "ponChannelId";
> col_name[2] = "onuType";
>
>   db_retrieve_row(db_name, table_name, 3,  col_name,col_val);
>   return 0;
>  }
>  int db_retrieve_row(char *db_name, char *table_name, int num_of_keys, char
> * col_names[],column_value_t * col_values)
>  {
> sqlite3 *db;
> sqlite3_stmt *stmt;
> int status = 0,loopVar,noOfColumns;
> char *query = NULL,**colNames,*str;
> int  retVal,*colType;
>
> retVal = sqlite3_open(db_name, );
> if(retVal) {
> fprintf(stderr,"Can't  open database: %s\n",sqlite3_errmsg(db));
> sqlite3_close(db);
> exit(1);
> }
>/* A Query to find the number  of columns in the table. */
>query = (char *)malloc(sizeof(char) * 255);
>memset(query,0,255);
>strcat(query, "SELECT * FROM ");
>strcat(query, table_name);
>strcat(query, ";");
>
>status = sqlite3_prepare_v2(db,query,strlen(query) + 1, , NULL);
>if(status != SQLITE_OK) {
>printf("Prepare error: %s\n", sqlite3_errmsg(db));
>exit(1);
>}
>noOfColumns = sqlite3_column_count(stmt);
>if(SQLITE_OK != sqlite3_finalize(stmt))
>{
> printf("The prepared statement is Not deleted.\n");
>}
>free(query);
>query = NULL;
>
>  /* A Query to find the Names of each column. */
>  query = (char *)malloc(sizeof(char) * 255);
> memset(query,0,255);
>  strcat(query, "SELECT * FROM ");
>  strcat(query, table_name);
>  strcat(query, ";");
>
>  //stmt = NULL;
>  status = sqlite3_prepare_v2(db,query,strlen(query) + 1, , NULL);
> if(status != SQLITE_OK) {
> printf("Prepare error: %s\n", sqlite3_errmsg(db));
>  exit(1);
>  }
>
>  colNames = (char **)malloc(sizeof(char));
>  memset(colNames,0,1);
>
>   for(loopVar = 0; loopVar < noOfColumns; loopVar++)
>   {
>   colNames[loopVar] = (char *)malloc(sizeof(char) * 20);
>   memset(colNames[loopVar], 0, 20);
>strcat(colNames[loopVar],sqlite3_column_name(stmt, loopVar));
>   }
>   if(SQLITE_OK != sqlite3_finalize(stmt))
>   {
>  printf("The prepared statement is Not deleted.\n");
>   }
>   free(query);
>  query = NULL;
>
>  /*  A Query to find types of each column. */
>  str = (char *)malloc(sizeof(char) * 255);
>   memset(str, 0, 255);
>   strcat(str, "SELECT ");
>   for(loopVar = 0; loopVar < noOfColumns; loopVar++)
>   {
> strcat(str, colNames[loopVar]);
> if(loopVar < (noOfColumns -1))
>   strcat(str,",");
>   }
>   strcat(str, " FROM ");
>   strcat(str, table_name);
>   strcat(str, ";");
>
>   status=sqlite3_prepare_v2(db,str,strlen(str)+1, , NULL);
>   if (status != SQLITE_OK) {
>  printf("prepare error:%s\n",sqlite3_errmsg(db));
>  exit(1);
>  }
>  sqlite3_step(stmt);   //Causing Segmentation Fault. //
>  colType = (int *)malloc(sizeof(int) * noOfColumns);
>  for(loopVar = 0; loopVar < noOfColumns; loopVar++){
>  colType[loopVar] = sqlite3_column_type(stmt, loopVar);
>  printf("Column Types = %d\n",colType[loopVar]);
>   }
>  if(SQLITE_OK != sqlite3_finalize(stmt))
>  {
> printf("The prepared statement is Not deleted.\n");
>  }
>  free(query);

Re: [sqlite] How to drop a table using sqlite API

[Taleeb Anwar]

Hi,

Generally the sql query works just fine in sqlite. Accordingly try the
normal sql queries

Drop table [table_name] should do
http://www.sqlite.org/lang_droptable.html

Thanks & Regards
Taleeb bin Waquar

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




On Thu, Feb 2, 2012 at 4:56 PM, bhaskarReddy  wrote:

>
> HI Friends,
>
>How can i drop a table using sqlite API.
>
> Regards,
> Bhaskar.
> --
> View this message in context:
> http://old.nabble.com/How-to-drop-a-table-using-sqlite-API-tp33249550p33249550.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Visual Studio 2010

[Taleeb Anwar]

Hi Manish,

Try the following (it may work)

1. In Data Source Select ""
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  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-boun...@sqlite.org [mailto:
> sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
> Sent: Tuesday, January 31, 2012 6:01 PM
> To: 'General Discussion of SQLite Database'
> Subject: Re: [sqlite] SQLite on Visual Studio 2010
>
>
> Agrawal, Manish wrote:
> >
> > At this point I should get a SQLite DatSource type in VS10, but I do not.
> > I was wondering if someone would know what I am missing.
> >
>
> It sounds like you want the Visual Studio Designer support; however, the
> steps you mention are for simply setting up System.Data.SQLite so that it
> can be referenced by (C# or VB) code in your project.
>
> Personally, I would recommend that you start out by learning the classes
> exposed by System.Data.SQLite (e.g. SQLiteConnection) and coding to them
> rather than using the designer.
>
> Here is a link to some tutorials to get you started:
>
> http://sqlite.phxsoftware.com/forums/p/76/266.aspx
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Delete data base.

[Taleeb Anwar]

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  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@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] installation for .NET use

[Taleeb Anwar]

It looks like the .net runtime version running in your system is older
compared to the version with which the assembly was built (and which you
are trying to install in GAC)

Regards
Taleeb bin Waquar

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




On Wed, Jan 18, 2012 at 6:19 PM,  wrote:

> Trying to use the .NET support but not able to see the entry in the GAC.
> Ran the gacutil and it told me the assembly had been built with a later
> runtime.
> I am running windows 7 with all fixes.
> Anyone have the .net version running?
> Regards, Major.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Followup: Added Missing error message to past post.

[Taleeb Anwar]

Download the x64 mixed-mode assembly compiled statically against the .NET
Framework 3.5 (as you are using VS2010 on a 64 bit computer). Regarding
targetting x86 users you can control this by using the property of the
project...

Thanks & Regards
Taleeb Anwar

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




On Mon, Nov 21, 2011 at 7:17 PM, Dave <thesche...@cox.net> wrote:

>
>
> On 11/21/2011 3:53 PM, Joe Mistachkin wrote:
>
>> I am running my Visual Studio on Win 7 64 Bit Pro but my database needs
>>> are simple for now so I am not sure which download I need or which
>>> framework to target. I want XP users to be able to use my software so I
>>> am guessing I should go with the 3.5 framework. And I also am guessing
>>> 32 Bit would be the best choice as it will work on both 32 and 64 bit
>>> platforms. I tried to run a few of the installers and kept getting the
>>> following error message:
>>>
>>> Failed to Install Microsoft Visual C++ Runtime
>>> vcredist_x64_2010_SP1.exe, Asia
>>>
>>> Which download would be the correct one for me?
>>>
>>> The installers on the web site are primarily intended for users that do
>> not already have the necessary Microsoft Visual C++ runtime installed.
>>
>> For development machines, it would be far better to simply download the
>> ZIP file(s) containing the pre-compiled binaries you need.
>>
>> In your case, it sounds like you will want to download the x86 mixed-mode
>> assembly compiled statically against the .NET Framework 3.5, available
>> here:
>>
>> https://system.data.sqlite.**org/sqlite-netFx35-static-**
>> binary-bundle-Win32-200<https://system.data.sqlite.org/sqlite-netFx35-static-binary-bundle-Win32-200>
>> 8-1.0.76.0.zip
>>
>> --
>> Joe Mistachkin
>>
>> Thanks Joe,
>  I am coming from VB6 Classic and finally making the move to .NET as I
> didn't like the looks of it when it came out and I actually bought it. It
> should have settled down by now.
> Dave
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using SQLite on Windows 64bit

[Taleeb Anwar]

Not sure what is causing the problem..and thus my suggestion(s) can be
labelled as trial and error ---
1. Check the target platform (try with x64 if it is 'any cpu').

Thanks & Regards
Taleeb Anwar

*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*




On Wed, Oct 26, 2011 at 11:09 PM, J Trahair <j.trah...@foreversoftware.co.uk
> wrote:

> HI.
>
> There's no SQLite.Interop.dll, anywhere.
>
> I downloaded sqlite-netFx40-setup-bundle-x64-2010-1.0.76.0.exe which gave
> me System.Data.SQLite.dll.
>
> Works on my development 64bit machine, not on the customer's 64bit.
>
> How do I get the interop?
>
> Thank you.
>
> Jonathan Trahair
>
>  - Original Message -
>  From: Joe Mistachkin
>  To: 'General Discussion of SQLite Database'
>  Sent: Wednesday, October 26, 2011 3:20 PM
>  Subject: Re: [sqlite] Using SQLite on Windows 64bit
>
>
>
>  J Trahair wrote:
>  >
>  > However, I have installed the same installation setup.exe on a separate
>  Windows
>  > 64bit computer, and it comes up with the error message 'Could not load
>  file or
>  > assembly System.Data.SQLite.dll or one of its dependencies, the
> specified
>  module
>  > could not be found.' However, the System.Data.SQLite.dll IS there
>  (v.1.0.76).
>  > What dependencies does it need (64bit)?
>  >
>
>  Is the SQLite.Interop.dll file in the same directory as the
>  System.Data.SQLite.dll
>  (or somewhere along the system PATH)?  Alternatively, you could use the
>  mixed-mode
>  assembly, which contains both the native and managed code required for
> using
>  SQLite
>  (i.e. it is more suitable for GAC'ing without having to alter the system
>  PATH, etc).
>
>  --
>  Joe Mistachkin <j...@mistachkin.com>
>
>  ___
>  sqlite-users mailing list
>  sqlite-users@sqlite.org
>  http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Where is my posting?

[Taleeb Anwar]

In-fact there is at-least one more post from you (other than this one),
regarding the best way to add sqlite to your app (Sorry I am not sure of the
answer). I think that confirms that your mails are being received..

Regards
Taleeb Anawr

*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*




On Wed, Oct 19, 2011 at 4:59 PM, Taleeb Anwar <taleeban...@gmail.com> wrote:

> Now that is a difficult question (in fact one of the most difficult
> questions of all) -- why nobody replies to your posts.
>
> Well, I don't know the answer - but am replying - to confirm that your
> posts are being received by others. And for the questions you didn't get any
> answer -- try rephrasing them or adding some code or something to make them
> more clear (for I can't think of any other reason for such an active group
> to remain unresponsive to your questions)
>
> Regards
> Taleeb Anwar
>
> *Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*
>
>
>
>
> On Wed, Oct 19, 2011 at 4:48 PM, Arbol One <arbol...@gmail.com> wrote:
>
>> Hey boys and girls!
>>
>> Anyone knows why is it that I cannot see my own postings, worst yet!
>> Nobody
>> replies to my postings?!
>>
>> How can I know if my email actually is being considered by other members
>> of
>> the list or if it was never posted?
>>
>>
>>
>> TIA
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Where is my posting?

[Taleeb Anwar]

Now that is a difficult question (in fact one of the most difficult
questions of all) -- why nobody replies to your posts.

Well, I don't know the answer - but am replying - to confirm that your posts
are being received by others. And for the questions you didn't get any
answer -- try rephrasing them or adding some code or something to make them
more clear (for I can't think of any other reason for such an active group
to remain unresponsive to your questions)

Regards
Taleeb Anwar

*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*




On Wed, Oct 19, 2011 at 4:48 PM, Arbol One <arbol...@gmail.com> wrote:

> Hey boys and girls!
>
> Anyone knows why is it that I cannot see my own postings, worst yet! Nobody
> replies to my postings?!
>
> How can I know if my email actually is being considered by other members of
> the list or if it was never posted?
>
>
>
> TIA
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] new user

[Taleeb Anwar]

No, not me! At least not at this stage -- will go through various options
when (and if) I decide to develop something (right now am just learning for
the sake of knowledge). Anyway thanks for the info!

Thanks & Regards
Taleeb Anwar

*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*




On Sun, Oct 9, 2011 at 8:40 PM, Tim Streater <t...@clothears.org.uk> wrote:

> On 09 Oct 2011 at 10:40, saeed ahmed <mycomputerbo...@gmail.com> wrote:
>
> > i am a new to sqlite. i want to know how can i make sqlite looking like
> > microsoft access? similar working environment, like making tables,
> queries
> > etc. actually i find it difficult to work in writing commands mode. any
> help?
>
> Have you looked at Navicat for SQLite?
>
> --
> Cheers  --  Tim
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] new user

[Taleeb Anwar]

No I'm not from Pakistan; but that should not be a reason for not helping
you out...And no I'm not an expert (not even near one).

OK. Let me try to explain again. To use sqlite like we all use
access/sql-server, we need to have some tool (management studio or IDE or
whatever you call it). If you have no idea and are just a beginner (like me)
then go ahead and download sqlite expert (there are other options - but I'm
using it and it is good enough to at least learn the concepts) from
http://www.sqliteexpert.com/download.html. You can download the personal
edition.

Install and run it and you will find a friendly interface (and sqlite will
look worth using). Now you just need to "click" to create tables and add
columns, indexes etc.

Now comes the next question, why do you want to use sqlite. Do you want to
use it with java, .net, C++ or just the database, or what..?
Taleeb bin Waquar

*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*




On Sun, Oct 9, 2011 at 7:45 PM, saeed ahmed <mycomputerbo...@gmail.com>wrote:

> brother it seems you are from pakistan like me.help me if you are wxpert
> user.i want to use sqlite but i dont know where to start?
>
> 2011/10/9 Taleeb Anwar <taleeban...@gmail.com>
>
> > If you don't want to work using command line - then you will have to
> > download some management tools. Visit
> > http://www.sqlite.org/cvstrac/wiki?p=ManagementTools to see a list of
> > tools.
> >
> > Personally I'm using sqlite expert. It has got its own advantages and
> > limitations (but anyway I've not used sqlite much).
> >
> > Hope this helps.
> >
> > Thanks & Regards
> > Taleeb (bin Waquar) Anwar
> >
> > *Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*
> >
> >
> >
> >
> > On Sun, Oct 9, 2011 at 3:10 PM, saeed ahmed <mycomputerbo...@gmail.com
> > >wrote:
> >
> > > i am a new to sqlite.i want to know how can i make sqlite looking like
> > > microsoft access?simmilar working environment,likemaking tables,queries
> > > etc.actually i find it difficult to work in writing commands mode.any
> > help?
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] new user

[Taleeb Anwar]

When I said advantages and limitations -- I meant philosophically and not
literally. In today's technology there is always scope for improvement,
irrespective of how great the product is.

I must also "repeat" that I've not used sqlite much. Just read about it
while browsing about .NET windows forms and decided to see and use it (and
thus am using the personal edition of "expert").

Hope this clarifies my stand...:-)
Taleeb Anwar

*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*




On Sun, Oct 9, 2011 at 6:47 PM, Jean-Christophe Deschamps
<j...@antichoc.net>wrote:

> Hi Taleeb,
>
> Just curious, what are the limitations in SQLite Expert you've found?
>
> I'm a long-term user of Expert and Bogdan (Expert's author) become close to
> a friend to me.  I'd like to see his product even more useful as I found it
> fairly complete and, above all, Bogdan is very responsive to
> issues/questions/request from users.
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] new user

[Taleeb Anwar]

If you don't want to work using command line - then you will have to
download some management tools. Visit
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools to see a list of tools.

Personally I'm using sqlite expert. It has got its own advantages and
limitations (but anyway I've not used sqlite much).

Hope this helps.

Thanks & Regards
Taleeb (bin Waquar) Anwar

*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*




On Sun, Oct 9, 2011 at 3:10 PM, saeed ahmed wrote:

> i am a new to sqlite.i want to know how can i make sqlite looking like
> microsoft access?simmilar working environment,likemaking tables,queries
> etc.actually i find it difficult to work in writing commands mode.any help?
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users