Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?
You can use sqlite-manager (http://code.google.com/p/sqlite-manager/). To copy select result into the clipboard : just select the rows, right-click on these rows and click on "Copy Row(s) as CSV". Thibaut. Gilles Ganault a écrit : > Hello > > I'm looking for a Windows alternative to the CLI sqlite.exe to manage > SQLite databases. > > SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it > won't let me copy the output of a SELECT into the clipboard so I can > paste it elsewhere. > > Are there better alternatives? > > Thank you. > > ___ > 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] "extension-functions.c" in windows mobile
I'm not familiar with MinGW and MSYS and with C/C++ in general. I don't know if a must do something special to build this dll for windows mobile application. Thibaut 2009/4/10 Jay A. Kreibich > On Thu, Apr 09, 2009 at 04:34:53PM +0200, Thibaut Gheysen scratched on the > wall: > > > I have found the "extension-functions.c" in the > > contrib page of the SQLite website but I'm not able to build it for > windows > > ce. Anybody can help me ? > > What specific problems are you having? I was able to compile this > file into a DLL and load it into sqlite3 without problems under > MinGW/MSYS for XP. > > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Our opponent is an alien starship packed with atomic bombs. We have > a protractor." "I'll go home and see if I can scrounge up a ruler > and a piece of string." --from Anathem by Neal Stephenson > ___ > 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] "extension-functions.c" in windows mobile
Hi, Yes, it's a solution but I want to test the two approachs (in VB and in SQLite with an extension) to choice the faster. Before, I worked with VB6 and Access and the faster way is to use the calculation possibilities of Access. I want just try it with VB .Net and SQLite. But I'm not able to build the extension and thus test the 2 approachs. Best regards, Thibaut. 2009/4/9 John Machin > On 10/04/2009 12:34 AM, Thibaut Gheysen wrote: > > Hi, > > > > I develop a windows mobile application in VB .Net (compact framework 2.0) > > with SQLite and the ADO.net provider. In this application, I must > calculate > > the distance between 2 points for all items of a table. For this I need > > "power" and "sqrt" function but these functions doesn't seem to be > include > > in SQLite core functions. > > That's why it has "Lite" in the name. > > > I have found the "extension-functions.c" in the > > contrib page of the SQLite website but I'm not able to build it for > windows > > ce. Anybody can help me ? > > > > DBMSs are for storing data and doing *elementary* calculations on the data. > > Why don't you do the calculation in VB? > > Cheers, > > John > ___ > 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] "extension-functions.c" in windows mobile
Hi, I develop a windows mobile application in VB .Net (compact framework 2.0) with SQLite and the ADO.net provider. In this application, I must calculate the distance between 2 points for all items of a table. For this I need "power" and "sqrt" function but these functions doesn't seem to be include in SQLite core functions. I have found the "extension-functions.c" in the contrib page of the SQLite website but I'm not able to build it for windows ce. Anybody can help me ? Best regards, Thibaut. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users