| Subject | Re: Dirty read? |
|---|---|
| Author | johnsparrowuk |
| Post date | 2004-06-05T11:56:17Z |
That would be interesting to see! LOL.
How about something like :
create trigger something on mytable active before insert as
declare i integer;
begin
select count(*) from mytable where intcolumn = new.intcolumn into :i;
if (i > 3) then
exception too_many_items;
end!!
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
How about something like :
create trigger something on mytable active before insert as
declare i integer;
begin
select count(*) from mytable where intcolumn = new.intcolumn into :i;
if (i > 3) then
exception too_many_items;
end!!
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
> Add expression indices then :-)& MS SQL
>
> You can SUBSTRING an index value - just like in MySQL.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL
> Server.
> Upscene Productions
> http://www.upscene.com