[sqlite] Fwd: Having trouble using sqlite to handle query that contains Chinese characters

ndle query that contains Chinese characters. > > When I debug the code, the strSQL variable looks correct to me. > > SQLite.SQLiteAsyncConnection _dbConnection = new > SQLite.SQLiteAsyncConnection(_dbPath); > ObservableCollection result = new > ObservableCollection(); &g

[sqlite] Enforcing SQLite column type

You can enforce a column's TYPE using CHECK() and/or TRIGGER. It might be expensive if used on all columns for large inserts or updates; depends on what the priorities are. INTEGER, REAL and BLOB are easy to enforce with triggers. typeof( NEW.cEnforceReal ) <> 'real' typeof( NEW.cEnforceInteger

[sqlite] [ANN]SQLight v2 - complete Manager/Browser/Editor for SQLite Databases

http://www.sqlight.com/ Complete Rewrite. The only database manager for SQLite that allows query results to be edited in a meaningful order! Try editing the data returned from a simple query like this in any other SQLite manager. "SELECT rowid,Product,Name,Description,Price,SKU FROM

Re: [sqlite] Announce: SQL Maestro Group SQLite tools introduction

Hi Maestro Group, NOT linked with SQLight team I guess that's a dig on me. They were FREE little tools I had laying around. Thought someone might get some use out of them. They won't know if I don't tell them. StanD http://www.sqlight.com/ IS linked with SQLight team. :) Lots of free SQLite

Re: [sqlite] Grabbing "default values" from the database...

different BindingSource objects, and I would like to populate the DataGridView columns with the default values that are set within the database itself, so that I don't have to set each column manually... Does anyone know how I would do this? If not, could someone tell me how to grab the "defaul

Re: [sqlite] [ANN]SQLtNoCase - convert SQLite TEXT columns to TEXT COLLATE NOCASE

Probably. Then again, it's was done. - Original Message - I don't mind receiving occasional announcements on new programs using SQLite (even if I'll never use them), but don't you think one per day is just too much? Regards, ~Nuno Lucas

[sqlite] [ANN]SQLtNoCase - convert SQLite TEXT columns to TEXT COLLATE NOCASE

FREE - SQLtNoCase - convert TEXT columns to TEXT COLLATE NOCASE SQLite handles text columns different, depending on how COLLATE is defined when the column is created. The default is COLLATE BINARY. TEXT or TEXT COLLATE BINARY - columns will be treated case sensitive for ORDER BY and WHERE

[sqlite] ANN:SQLtTableImprot - Free SQLite to SQLite Table Import Tool

SQLtTableImprt is a little tool for importing a table from one SQLite database into another SQLite database. - This can easily be done in SQL with ATTACH DATABASE. - SQLtTableImprt automates the process. - Windows only. - Should work with any SQLite Type 3 database that the Window's file system

Re: [sqlite] primary key information

another way "SELECT rowid FROM MyTable LIMIT 1" the column name returned will be the Integer Primary Key StanD sd at sqlight.com - Original Message - From: "Mario Frasca" <[EMAIL PROTECTED]> To: Sent: Monday, August 07, 2006 9:33 AM Subject: Re: [sqlite]

[sqlite] ANN: SQLtAlarm - Alarm monitor for SQLite Databases

SQLtAlarm - Alarm system for SQLite Databases. - Set an alarm on any piece of data in an SQLite database. - Turn any table into a to-do list. - No limitations , no time-limit, no nags - donationware. - Built-in tool to add alarm column. - Requirements, Windows OS. -

[sqlite] [ANN] SQLite Manager - Browser - Editor + Deep SQL

[ANN] SQLite Manager - Browser - Editor + Deep SQL Windows/UTF-8 only. www.sqlight.com Four query views. Transactions supported. Table Edit - complete editing flexibility. No limitation how a table is arranged for editing as long as Primary Key present. - Lookup List - Save Queries - Save

Re: [sqlite] SQLite browser/manager + Deep SQL - testers please

thanks - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, July 28, 2006 12:00 PM Subject: Re: [sqlite] SQLite browser/manager + Deep SQL - testers please On 7/28/06, Me <[EMAIL PROTECTED]> wrote: A

[sqlite] SQLite browser/manager + Deep SQL - testers please

Windows SQLite browser/manager. Four query views. View/Edit four simultaneous queries or same table in various sort orders. No limitation how a table is arranged for editing as long as the Primary Key is in the query. Transactions supported. Deep SQL: Work on blob-stored SQLite databases -