Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Bob Gailer
On Oct 18, 2018 5:59 AM, "Maziar Parsijani" 
wrote:
>
> Hi,
> how could I ignore syntax errors like this?
>
> > *SELECT *,*
> >
> > * highlight(searchsimpleenhanced, 2, '', '') text*
> >
> > * FROM searchsimpleenhanced*
> >
> > * WHERE searchsimpleenhanced MATCH 'sth][';*

As I understand the documentation match must be defined someplace what is
the definition of match in your case? Or what are you trying to accomplish
by using match?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Fill empty space with random

2018-10-14 Thread Bob Gailer
On Oct 14, 2018 7:57 AM, "J Decker"  wrote:
>
> Is there maybe a compile option for sqlite to fill empty space in a db
with
> random data rather than 0 ?

I don't know about compile options.

You could do a 1 time update to set all 0 columns to random(1,99), and
create a trigger to do the same on insert.

This, of course is on a table-by-table basis.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: Fw: [sqlite] TWS for Windows - link

2004-03-26 Thread Bob Gailer
At 04:47 AM 3/26/2004, Borivoj wrote:
Hi Tom.

The best example is the admin module of TWS it is written in TWS itself.
Download the source and take a look at the code.
[snip]

A Google search for TWS has nothing promising. Where does one go to 
download it?

Bob Gailer
[EMAIL PROTECTED]
303 442 2625 home
720 938 2625 cell 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]