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

te-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> > -- Thanks Alok Kumar Singh ___ 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

o 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 wrote: > Hello > >I am a n

Re: [sqlite] Can Anyone help me to make this Query Faster..!!!

= T2.docid and T1.docid = T3.docid and T1.docid = T4.docid" myparam.Value = Z + 1 mycommand.ExecuteNonQuery() tx.Commit() Next cons.close() its same speed and slow...not working, please guide On 21 July 2011 19:02, Simon Slavin wrote: > > On 21 Jul 2011, at 2:28pm, Alok Singh wrot

[sqlite] Can Anyone help me to make this Query Faster..!!!

count1 myparam.Value = Z + 1 mycommand.ExecuteNonQuery() Next tx.Commit() cons.close() while executing simple INSERT / SELECT command from Option1 on sqlite browser it's Faster there but excuting with VB.NET ,its

[sqlite] Export sqlite table in textpad/notepad

anyother way if anyone having please advice me. Kindly help me, its urgent for me, after 8 hour i am having demo presentation on my software. Thanks, Alok ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Using Bulk Insert in SQLite

strval strval = Replace(yarray(y) + vbTab + yarray1(y), "'", "''") strval = Replace(strval, vbTab, "','") myparam.Value = strval cmd.CommandText = "INSERT into " & ticket & "

Re: [sqlite] A kind help-request.

rray(y) + vbTab + yarray1(y), "'", "''") strval = Replace(strval, vbTab, "','") myparam.Value = strval cmd.CommandText = "INSERT into " & ticket & " VALUES('" & strval & "

Re: [sqlite] A kind help-request.

uot;''") strval = Replace(strval, vbTab, "','") myparam.Value = strval cmd.CommandText = "INSERT into " & ticket & " VALUES('" & strval & "')"

Re: [sqlite] A kind help-request.

take hardly a sec. but here i am some manipulation over that where i am killing some second of time. Thanks Simon ,Olaf and Garry. please update this email thread if we will have any faster processes than now. thanks a lot Guys.. :-) * Regards, Alok* On 7 January 2011 01:48, GS wrote: > O

Re: [sqlite] A kind help-request.

yeah that's correct Simon, its in 0.6 sec to insert for 10.5K rows with 20 columns (2 files both having 10.5k rows) Thanks alot :-) That was my Typo.. ;-) Perfect. On 6 January 2011 19:57, Olaf Schmidt wrote: > > "Alok Singh" schrieb > im Newsbeitrag >

Re: [sqlite] A kind help-request.

Hi Simon, Perfect, i followed as whatever you advised me, that's *PERFECT* , much faster than my expectation 0.6 min can able to access 10.5k row records. superb i like that. again many thanks,and i appreciate your kind support. * Regards, Alok * On 4 January 2011 04:32, GS wrote: &g

Re: [sqlite] A kind help-request.

please help me on this . Regards, Alok On 3 January 2011 22:46, GS wrote: > Simon Slavin wrote : > > Also you are still using a 2D array to store your values. This is slow > and > > requires a lot of memory. Instead, use one array to read in the first > row > > (wi

Re: [sqlite] A kind help-request.

Thanks alot Simon , let me do as you advised me, will update you if that help me. have a nice day again many thanks :-), Regards, Alok On 3 January 2011 04:18, Simon Slavin wrote: > > On 2 Jan 2011, at 10:33pm, Alok Singh wrote: > > > i am doing the same inserting lin

Re: [sqlite] A kind help-request.

etter solution for this. as my tab dilimited file norally will having 1 million of record. its deadly if we go through this. as for 6k for test its taking 30 min to insert. while if i am direct importing that into sqlite using user interface on firefox its completing that task in some sec. please h

[sqlite] A kind help-request.

command through sqlite console will work, but as i am using vb.net , its very difficult to me for now inserting each line by line. please guide me and advice me. thanks alot. -- Thanks Alok Kumar Singh ___ sqlite-users mailing list sqlite-users

Re: [sqlite] How to Embed SQLite in VC++

you forget to include defination of sqlite3_open and sqlite3_exec in your application if you like i can send you release version of sqlite.lib which you can easily include in your project With Regards Alok Gupta Visit me at http://alok.bizhat.com "I Believe this

Re: [sqlite] How to create Auto Increment Field in SQlite

Hain Thanks Very Much Sir!!! Thanks Once Again Alok Gupta - Original Message - From: "Witold Czarnecki" <[EMAIL PROTECTED]> To: Sent: Monday, April 04, 2005 4:01 PM Subject: Re: [sqlite] How to create Auto Increment Field in SQlite > http://www.sqlite.org/autoinc.ht

[sqlite] How to create Auto Increment Field in SQlite

I am knocking my head on door for doing this I try to create table with this feature Create table min1(slno interger auto_increment,name char(100)); but table doesn't create. any help or link relate to this is very helpful Thanks Alok Gupta

Re: [sqlite] HEllo All

Thanks very much Sir! - Original Message - From: "ëìê" <[EMAIL PROTECTED]> To: Sent: Thursday, March 31, 2005 10:29 AM Subject: Re: [sqlite] HEllo All > http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions > > alok wrote: > > >Thanks Mr George,

Re: [sqlite] HEllo All

Thanks Mr George, Thanks for reply, I will try that Activex Com wrapper.I have a very small query Sir, Is SQLITE support DATE/TIME base searching. Any example related to that is very great help. Thanks Alok Gupta - Original Message - From: "George Io

[sqlite] HEllo All

Hello All Great programmer, I amVery much Beginner to SQLITE, i have very simple query:- How to password protect the db file. Thanks Alok Gupta