Re: [sqlite] SqLite - Help

> Is it possible to create Storedprocedure or Functions in Sqlite. ? No. > Since i am new to Sqlite. Can u suggest some best sites or links to learn > Sqlite (ofcourse i saw Sqlite.org site) Other than sqlite.org you can look at google.com. It is usually very good at finding answers on

[sqlite] SqLite - Help

Hi, I am new to Sqlite. I need to develop a Desktop windows application C# with Sqlite. Is it possible to create Storedprocedure or Functions in Sqlite. ? If so, can you send me an example for both. Since i am new to Sqlite. Can u suggest some best sites or links to learn Sqlite

Re: [sqlite] Sqlite help

On Tue, Jul 05, 2011 at 00:30:31 +0200, Wolfgang Enzinger wrote: > Am Mon, 4 Jul 2011 14:45:07 -0700 (PDT) schrieb ceekayCK: > > unfortunately send me a .doc file > > You're at a loss there. Your friend could as well print this file and send > you the printer output, essentially that would make

Re: [sqlite] Sqlite help

>Unfortunately, I'm not too familiar with SQLite Manager. well it's quite cool you know, try one day :) It's kind of WYSIWYG -:) Ok so unfortunatelly my database is in .gll file but when i use FF SQLite Manager in FF i can see all my tables. So i Imported my csv file to my database :-) very

Re: [sqlite] Sqlite help

Am Mon, 4 Jul 2011 16:10:10 -0700 (PDT) schrieb ceekayCK: > It was quite easy to export to csv (using excel) :) > Now i have in one column Artist , and in second column Title Fine. :-) > Ok So i use sqlite Manager in Firefox Unfortunately, I'm not too familiar with SQLite Manager. > What

Re: [sqlite] Sqlite help

*If* you can manage a reasonable export to .csv (using Excel, if needed, or not), then, yes, that would be a way to go IMHO. Lookup the .import command in the CLI (command line interface). OK Wolfgang It was quite easy to export to csv (using excel) :) Now i have in one column Artist , and

Re: [sqlite] Sqlite help

Am Mon, 4 Jul 2011 15:39:30 -0700 (PDT) schrieb ceekayCK: > If i changed .doc file to .txt or csv, will this help? > Or put all data from .doc to excel, and then split Artist and title to > separate columns and export to csv? *If* you can manage a reasonable export to .csv (using Excel, if

Re: [sqlite] Sqlite help

>A .doc file is basically a load of printer instructions, but generally it doesn't hold any structured data. The latter, however, is what a database needs and is made for. If i changed .doc file to .txt or csv, will this help? Or put all data from .doc to excel, and then split Artist and title

Re: [sqlite] Sqlite help

Am Mon, 4 Jul 2011 14:45:07 -0700 (PDT) schrieb ceekayCK: > unfortunately send me a .doc file You're at a loss there. Your friend could as well print this file and send you the printer output, essentially that would make no difference. A .doc file is basically a load of printer instructions,

[sqlite] Sqlite help

Hi, At the beginning I will say that I am not a specialist in databases. I have the following problem to figure out: I have a database (sqlite). In it, about 8800 records (lyrics) I have received from a friend list (selected about 800 songs), but unfortunately send me a .doc file Is there a magic

Re: [sqlite] sqlite help requested to support this requirement

On Fri, Dec 4, 2009 at 8:01 AM, Pronab Ganguly wrote: > Thanks a lot for all help suggestion.Let me know if you have any experience > on file parsing using sqlite. .. SQLite doesn't do any "file parsing." You have to do the file parsing, and then stick the v -- Puneet

Re: [sqlite] sqlite help requested to support this requirement

You don't need any file parsing with SQLite and SQLite is not a file-parsing utility. SQLite is a database engine. It creates file of its own format and parses it without user noticing it. All you have to do is issue necessary SQL commands to work with your database. You definitely need to read

Re: [sqlite] sqlite help requested to support this requirement

Thanks a lot for all help suggestion.Let me know if you have any experience on file parsing using sqlite. -P On Fri, Dec 4, 2009 at 6:15 PM, Pavel Ivanov wrote: > > SQLite is an implementation of SQL. SQL is used to store information in > a way that allows you to look

Re: [sqlite] sqlite help requested to support this requirement

> SQLite is an implementation of SQL. SQL is used to store information in a > way that allows you to look things up more quickly than searching a flat > file. If you can search for data your flat files fast enough to make your > software work acceptably, you do not need SQL and your project

Re: [sqlite] sqlite help requested to support this requirement

On 4 Dec 2009, at 11:50am, Pronab Ganguly wrote: > I am newbie to sqlite.Would like to is sqlite is better than flat file > parsing? > > We have platform specific files of different formats to be read so our > code is complex and difficult for maintenance considering support for > newer

[sqlite] sqlite help requested to support this requirement

Hi All, I am newbie to sqlite.Would like to is sqlite is better than flat file parsing? We have platform specific files of different formats to be read so our code is complex and difficult for maintenance considering support for newer platforms and backward compatibility. We are planning for a