Re: [QSQLite-users] Hi, bug solved

[AgarFu <ag...@so...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

El S=E1bado, 19 de Julio de 2003 09:20, Dominik Seichter escribi=F3:

> Account created. Sorry for the long delay.

there isn't any problem, yesterday I'v solved one more bug.

If you use triggers on tables or views you can use a function named RAISE. =
If=20
you use something like:

CREATE TRIGGER update_sexo BEFORE UPDATE OF sexo ON paloma
=46OR EACH ROW
BEGIN
   SELECT RAISE (ABORT, "Paloma con descendencia, no se le puede cambiar el=
=20
sexo.")
   FROM paloma
   WHERE madreID =3D old.palomaID OR padreID =3D old.palomaID;
END;

and you try to update an ilegal row, sqlite compiles the query without any=
=20
problem but when the firs step is done an error code is returned. I've catc=
h=20
this code and set LastError.

>
> CU Dom

=2D --=20
   --------------------------=B7=3D{  AgarFu  }=3D=B7-------
 |       ._aasuas,.                                 |
 |    .adZ#X"!""!!X#Xc      Ren=E9  Mart=EDn  Rodr=EDguez |
 |  ._#X?`     .   ~4XXc    Centro    Superior   de |
 | .jZ'      _ss,    ]b/j   Inform=E1tica Universidad |
 | jX(     .7    ..  )X[]   De La Laguna.           |
 | 3X      3      -  ]X(]   Grupo Usuarios Linux de |
 | 3o     .],. _, '  2':    Canarias: www.gulic.org |
 | ]X;     -]5s,_sa2"`      Sitio    en   internet: |
 |  4Z>  .     ""                                   |
 |   {q,      .     croasanaso.sytes.net (difunto)  |
 |   ."Xa                                           |
 |      -9as         ag...@gu...               |
   -------------------------------------------------
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/Gd2cHfyGHDFT1lYRAqO2AKCRrq3jj0R3xi1j6tzJhuo2rpOqQgCcChNO
Lky0bqlM3SOwHfUOuOko468=3D
=3Dog1o
=2D----END PGP SIGNATURE-----