If you don't mind requiring that the value being inserted be typed
integer, you can use:
create table t1 (c1 integer check (typeof(c1) = 'integer'));
But this means that values that could be converted to integers by the
integer affinity of the column, like 4.0 or '1' will be cause a check
con
Whilst any type going into a field is often seen as a big plus, there are
occasions where this may be undesirable.
For such occasions, I'm currently thinking that:
NOT NULL CHECK( ROUND(fieldname)=fieldname )
looks ok, but I'm wondering if there's a case that still gets through or if
there's a be
Hi,
Thanks to those who gave feedback. It looks like that it will be best left
to business rules. In the event that enrolmentItems are attached to leaver
enrolments (due to a coding error), they will be ignored.
Thanks.
___
sqlite-users mailing list
s
Keith,
I got apsw to work, but it had a curious side-effect
-- it clobbered my IPython prompt (replaced prompt with smiley faces).
For those who are interested.
1. downloaded apsw -- does not work with Python's package manager pip
http://apidoc.apsw.googlecode.com/hg/download.html#source-and-binar
I assume you know about the timezone (tz) database maintained by the
Internet Assigned Numbers Authority (IANA) -- it is sometimes referred as
the Eggert/Olson database -- after its code and data maintainers.
http://www.iana.org/time-zones
"The tz database is published as a set of text files
hi , Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for Vxworks6.8 ?
When I compile them , there have so many problems .
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
THANK YOU!!!
On Fri, Aug 1, 2014 at 6:17 PM, Keith Medcalf wrote:
> Works just fine. The SQL adaption layer in your chosen Python -> SQLite
> interface must be doing something wacky.
Thank you for demonstrating that alternative packages do work.
apsw looks good and a search of GitHub suggest
On 02 Aug 2014 at 00:27, Stephen Chrzanowski wrote:
> I understand that with routing and such, you can end up outside where you
> really are (With my IP, I'm shown just outside of Toronto when I'm actually
> two hours out), but the chances of showing up in Taiwan when you're in
> Tennessee is do
8 matches
Mail list logo