[sqlite] Leading spaces in columns
I have a number of leading spaces in one of my sqlite columns, but SELECT result suppresses them. Yet I see that the SqliteManager add-on for Firefox displays them quite nicely. What is the secret of retrieving those leading spaces? Kind regards, ~ Paul Claessen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] What is a Relation?
So .. would anyone know a good book for seasoned programmers, who are new to databases, that addresses all these issues? ~ Paul Claessen > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon > Slavin > Sent: Monday, July 27, 2009 12:34 PM > To: j...@kreibi.ch; General Discussion of SQLite Database > Subject: Re: [sqlite] What is a Relation? > > > On 27 Jul 2009, at 2:49pm, Jay A. Kreibich wrote: > > > That's because most people are, unfortunately, taught SQL in a vacuum > > with none of the theory or background. > > > Yes yes. Hence the recent rash of people on this list who can't dry- > run their software, don't understand what an index is, have no > appreciation of how to guess him much work a computer is doing, etc.. > This is a big problem in the industry in general: they teach you how > to declare an index without explaining why or what kind of index will > help you. > > I keep wanting to scream "If you don't grok the need you shouldn't be > a programmer to start with.". But it's not their fault, it's their > bosses' fault. > > 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
Re: [sqlite] .lib file?
Thank A.J. Milan! Forcing VS2008 to compile the amalgamation as C (as opposed to the default C++) took care of everything. I also had the comment-out the #include sqlite3.h header file, and let it use all the 'built-in' stuff (else you get an undefined for the _sqlite3_version extern!) Works fine now too. Great forum! > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of A.J.Millan > Sent: Sunday, July 26, 2009 12:19 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] .lib file? > > Basides the mentioned option of build a .lib file and link it statically > against your code, or a dinamic library, there are the option of include the > sqlite3.c file in your code without so many problems with the casting of > pointers -and some others-. > > If you are using a C++ project in MS Visual Studio, the sqlite3.c file must > be compiled as "C". > > See in: File-Properties > C/C++ > Advanced > Compile As > > Select "Compile as C Code (/TC)" > > The rest of the project can remain compiled as usual C/C++ files. > > Probably you must disable the use of precompiled headers also. > > HTH. > > A.J.Millan > > > > -Original Message- > > From: Paul Claessen paul at claessen.com > > Sat Jul 25 15:48:37 GMT 2009 > > To: paul at claessen.com; General Discussion of SQLite Database > > Subject: Re: [sqlite] .lib file? > >> Two points though: > > > 1. The amalgated sources were, apparently, not written with MS Visual > > Study in mind, since compiling it results in over 100 errors > > (mostly invalid pointer conversions) > > 2. If I have a number of apps, it would really be more efficient to use > > the DLL. > > > I'm sure I can fix all the pointer casts (shouldn't be necessary if the > > code used more consistent types!), but that would take me a > > lot of time, plus, there should be a way to simply use the .dll: since > > there IS a windows console app, there must be either a .lib > > file somewhere, or there is an alternative way of using DLL's from a > > windows console app, that I'm not aware of. > > ___ > 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] .lib file?
Actually, I was able to generate a .lib file from the DLL using Doug's suggesting (link /lib /def:sqlite3.def). Works fine now! Thanks all! ~ Paul Claessen > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fred > Williams > Sent: Saturday, July 25, 2009 4:44 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] .lib file? > > Hum. So Mickeysoft does not supply a lib converter/creator utility? I even > have a "Make" and "Grep" utility when I get nostalgic for my limited Unix > days. > > My generator has an "-a" option to, "Add '_' alias for MS flavor cdecl > functions." > > Is that what you mean? > > Someday if I can find someone to hold a big enough caliber gun to my head, > I'm going to learn something about the "Visual" development world. I > installed the C++ "Express" version and was so underwhlmed by the > performance I started look for that person with a giant gun :-( > > Fred > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Mihai Limbasan > Sent: Saturday, July 25, 2009 1:13 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] .lib file? > > > Fred, > > Unfortunately, .lib (or, for that matter, .obj) files created by Borland > compilers are not compatible with the Microsoft toolchain, and > vice-versa. Borland uses a variant of the OMF object format, and > Microsoft uses a variant of COFF. > > On 07/25/2009 08:09 PM, Fred Williams wrote: > > Paul, > > > > If you wish I can send yoou a SQLite3.lib file I just generated using my > old > > Borland C++ Builder 5 Lib utility. Can't attach it here so contact me: > > > > fwillia...@gmail.com > > > > And I'll attach it to a reply. > > > > Fred > > > > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org > > [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug > > Sent: Saturday, July 25, 2009 11:24 AM > > To: 'General Discussion of SQLite Database' > > Subject: Re: [sqlite] .lib file? > > > > > > Hi Paul -- > > > > When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier > > as I recall) automatically creates an import library in the same directory > > as the .DLL file. I also _used_ to run the following command separately > to > > create the import lib: > > > > link /lib /def:sqlite3.def > > > > I haven't kept my sqlite3.def file up to date, but it's fairly recent if > you > > want to use it. Since we can't post files to the newsgroup, I'll append > it > > here. > > > > Doug > > > > > > EXPORTS > > sqlite3_aggregate_context > > sqlite3_aggregate_count > > sqlite3_auto_extension > > sqlite3_bind_blob > > sqlite3_bind_double > > sqlite3_bind_int > > sqlite3_bind_int64 > > sqlite3_bind_null > > sqlite3_bind_parameter_count > > sqlite3_bind_parameter_index > > sqlite3_bind_parameter_name > > sqlite3_bind_text > > sqlite3_bind_text16 > > sqlite3_bind_value > > sqlite3_bind_zeroblob > > sqlite3_blob_bytes > > sqlite3_blob_close > > sqlite3_blob_open > > sqlite3_blob_read > > sqlite3_blob_write > > sqlite3_busy_handler > > sqlite3_busy_timeout > > sqlite3_changes > > sqlite3_clear_bindings > > sqlite3_close > > sqlite3_collation_needed > > sqlite3_collation_needed16 > > sqlite3_column_blob > > sqlite3_column_bytes > > sqlite3_column_bytes16 > > sqlite3_column_count > > sqlite3_column_decltype > > sqlite3_column_decltype16 > > sqlite3_column_double > > sqlite3_column_int > > sqlite3_column_int64 > > sqlite3_column_name > > sqlite3_column_name16 > > sqlite3_column_text > > sqlite3_column_text16 > > sqlite3_column_type > > sqlite3_column_value > > sqlite3_commit_hook > > sqlite3_complete > > sqlite3_complete16 > > sqlite3_create_collation > > sqlite3_create_collation16 > > sqlite3_create_collation_v2 > > sqlite3_create_function > > sqlite3_create_function16 > > sqlite3_create_module > > sqlite3_create_module_v2 > > sqlite3_data_count > > sqlite3_db_handle > > sqlite3_declare_vtab > > sqlite3_enable_load_extension > > sqlite3_enable_shared_cache > > sqlite3_errcode > > sqlite3_errmsg > > sqlite3_errmsg16 > > sqlite3_exec > > sqlite3_exp
Re: [sqlite] .lib file?
Thanks Pavel. Two points though: 1. The amalgated sources were, apparently, not written with MS Visual Study in mind, since compiling it results in over 100 errors (mostly invalid pointer conversions) 2. If I have a number of apps, it would really be more efficient to use the DLL. I'm sure I can fix all the pointer casts (shouldn't be necessary if the code used more consistent types!), but that would take me a lot of time, plus, there should be a way to simply use the .dll: since there IS a windows console app, there must be either a .lib file somewhere, or there is an alternative way of using DLL's from a windows console app, that I'm not aware of. Kind regards, ~ Paul Claessen > -Original Message- > From: Pavel Ivanov [mailto:paiva...@gmail.com] > Sent: Saturday, July 25, 2009 11:31 AM > To: p...@claessen.com; General Discussion of SQLite Database > Subject: Re: [sqlite] .lib file? > > You can take sqlite3.c from amalgamation package and include it into > your project. This way SQLite will be included into your application > and you won't need any .dll or .lib files. > > Pavel > > On Sat, Jul 25, 2009 at 10:41 AM, Paul Claessen<p...@claessen.com> wrote: > > Greetings, > > > > > > > > I'm trying to build and use the short sample C code on the quick start page > (http://www.sqlite.org/quickstart.html) for windows as a > > simple win32 console app, using Visual Studio 2008. > > > > In order to provide linkage to the DLL, I need to link with the .lib file > > that is usually created > when creating a DLL. Where can I > > find that file? > > > > Or are there other ways to actually build the above mentioned app, without > > such a library? > > > > There is a windows test console app, but I can't find the project files for > > it. Does anyone have > them, and knows how to build a > > simple console app, using the dell, in Visual Studio? > > > > > > > > Kind regards, > > > > > > > > ~ Paul Claessen > > > > > > > > > > > > ___ > > 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] Sqlite from ASP?
Greetings, Does anyone have any (simple) examples on how to use sqlite from .ASP scripts for me? Or C# code, for that matter? ~ Paul Claessen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] .lib file?
Greetings, I'm trying to build and use the short sample C code on the quick start page (http://www.sqlite.org/quickstart.html) for windows as a simple win32 console app, using Visual Studio 2008. In order to provide linkage to the DLL, I need to link with the .lib file that is usually created when creating a DLL. Where can I find that file? Or are there other ways to actually build the above mentioned app, without such a library? There is a windows test console app, but I can't find the project files for it. Does anyone have them, and knows how to build a simple console app, using the dell, in Visual Studio? Kind regards, ~ Paul Claessen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users