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
-MM-DD HH:MM:SS
behaves as expected on queries
no manipulation necessary
you can set a validation mask
CREATE TABLE [tEnforceTimestamp2] (
[cTimestamp] TEXT CHECK (cTimestamp LIKE'-__-__ __:__:__')
)
or
CREATE TABLE [tEnforceTimestamp2] (
[cTimestamp] TEXT CHECK(cTimestamp > '1900-01-01'
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 )
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 Produc
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
ols which are bound to 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
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
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 com
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
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] primary key information
Nem
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.
- http://www.sqlight.com/sqltalar
[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 De
thanks
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To:
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:
Also - How do I get
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 - do
14 matches
Mail list logo