Tom, As John mentioned below, you need to distinguish between sqlite, the db library, and sqlite3(.exe)?, the shell program commonly used to access the data held in sqlite format via the sqlite db library. Unfortunately, the names are similar, and that can be a source of confusion.
Your problem lies in that, as far as I can tell, you are building an application that seems to depend on sqlite3, the shell program. What you should do instead is that you should ditch it, and use your preferred method of accessing "the data held in sqlite format via the sqlite db library." For example, my preferred method of building applications with sqlite data is via Perl. All I want to do I can do via Perl. Likewise, you pick your tool of choice. If you know that tool well enough, you can do anything with it. All sqlite, the db library, does is that it allows you to manage the data held in sqlite format. Don't mess with sqlite3, the shell program, else you will forever be limited by what it can do. On 1/6/07, John Stanton <[EMAIL PROTECTED]> wrote:
The sqlite3 program is just an application program using the sqlite lbrary. If you have your own version of it is will be compatible with all Sqlite V3 databases. What changes with an Sqlite release is the library that you link into your application. T&B wrote: > Hi John, > >>> But, then I need an alternate way to convert a few characters (at >>> least & and <) in the fields in my output into the correct html >>> codes. How can I do this? > > >> Why not just make a simple change to sqlite3.exe? You have the source. > > > Um, where do I start? Because I want to work with SQLite, not redefine > it. I don't want to have to add my changes and recompile it every time > there's a new version. I don't want to have my version produce > different results to everyone else. I want to be able to move my > specific program from one machine to another, without having to > recompile SQLite on the other machine. I want to be able to swap a > SQLite library in and out of my software and have it produce the same > results. I want to be able to raise bug reports or query approaches > knowing that everyone's using the same version as me. Because I'm not > on a ".exe" OS ;-) > > ;-) > > Also, there's a broader question here. Can I, within SQLite (eg a > SELECT statement) replace all occurrences of string 1 with string 2? > For instance, if in the Description column output I want to change any > occurrence of "&" to "&", can it be done? I imagine something like: > > SELECT Replace(Description, '&', '&') FROM MyTable > > Thanks, > Tom > > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------