Michael Scharf <[EMAIL PROTECTED]> writes:
> Jim C. Nasby wrote:
>> On Thu, Jan 05, 2006 at 01:39:02PM -0600, Kurt Welgehausen wrote:
>>
>>> create trigger EnumTrg before insert on MainTbl for each row
>>> when (select count(*) from EnumVals where val = new.EnumCol) = 0 begin
>>> select
Hi,
I am trying the following program and it fails with 'database is locked'. I
have set the 'insecure_locks' option in /etc/exports of the NFS server (RH 7.3,
2.4.18-3 kernel).
It only fails for HP-UX clients (11iv1 aka 11.11).
Anybody has success with this combo?
thanks
bal
#include
#include
Ah, thanks for the tip. I'll have a look.
Steve
Simon Posnjak wrote:
Hi,
I do not now if you found it but there is another port of sqlite to
WinCE. You can find it at http://sqlite-wince.sourceforge.net/.
Would it be possible if your port and the sf port could be merged
together in main
> ... you'll also need to write an update trigger ...
True, and you may want to protect EnumVals with triggers after
you populate it, or put EnumVals is a separate read-only
database and attach it. On the other hand, being able to change
the allowed values without changing the schema may be an
On Thu, Jan 05, 2006 at 01:39:02PM -0600, Kurt Welgehausen wrote:
> create trigger EnumTrg before insert on MainTbl for each row
> when (select count(*) from EnumVals where val = new.EnumCol) = 0 begin
>select raise(rollback, 'foreign-key violation: MainTbl.EnumCol');
> end;
Wouldn't that
Kurt Welgehausen said:
>> SQLite doesn't support enums natively. You could emulate it using
>> triggers, although it would be somewhat hidden and definitely a pain in
>> the tucus to use.
>
> It's not really so hard.
>
> create table MainTbl (
> ...
> EnumCol SomeType references EnumVals,
>
> SQLite doesn't support enums natively. You could emulate it using
> triggers, although it would be somewhat hidden and definitely a pain in
> the tucus to use.
It's not really so hard.
create table MainTbl (
...
EnumCol SomeType references EnumVals,
...);
create table EnumVals (val
On Wed, 4 Jan 2006, Steve Lhomme wrote:
>[EMAIL PROTECTED] wrote:
>> Peter Bierman <[EMAIL PROTECTED]> wrote:
>>
>>>Related to a project I'm working on, it would be useful for me to be
>>>able to open a database file via passing an already open file
>>>descriptor to the sqlite open() call.
Rajan, Vivek K said:
> I would like to know the following:
>
> *Does SQLite support enum like MySQL? If yes, how to use it
>
> *If not, is there another way to model enumeration in SQLite?
> And/or any plans going forward to support enums natively in SQLite?
SQLite doesn't
I would like to know the following:
*Does SQLite support enum like MySQL? If yes, how to use it
*If not, is there another way to model enumeration in SQLite?
And/or any plans going forward to support enums natively in SQLite?
Rajan
If you have "dot zero(s)" values (such as, 4.0) do not save them in an
INTEGER column because then they will lose their float characteristics.
insert into students values(John, 4.0)
select age from students where first_name = 'John'
4 <-- got converted to integer
Regards
/sd
You will need to be clearer on what error message you are seeing.
AFAIK SQLite does not display any error messages, is this a feature of
your development environment?
On 02/01/06, Tsolakos Stavros <[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I am new both to this list and sqlite. Great tool.
>
> I
sorry ,maked an mistake.
actually,the data size is 805 vars, 118519 obs.
2006/1/5, ronggui wong <[EMAIL PROTECTED]>:
> Thanks to all give response to help.
> This is my solution using the luanguage I familiar.(http://www.r-project.org).
>
> I use the code to read a 11819x807 csv file and it takes
thnx
my queries are running in 1/3rd the time now!!
ritesh
On Mon, 2006-01-02 at 22:22, Dennis Cote wrote:
> Ritesh Kapoor wrote:
>
> >Hi,
> >
> >I need to optimize/speed up my 'select' queries. The query creates
> >about 3 to 6 left joins from 7 different tables depending on the
> >different
Hi,
I do not now if you found it but there is another port of sqlite to
WinCE. You can find it at http://sqlite-wince.sourceforge.net/.
Would it be possible if your port and the sf port could be merged
together in main line src tree?
Regards Simon
On sre, 2006-01-04 at 10:13 -1000, Steve
15 matches
Mail list logo