[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [GNUe] generate primary key

From: Jason Cater
Subject: Re: [GNUe] generate primary key
Date: Thu, 3 Jun 2004 15:36:21 -0500
User-agent: KMail/1.6.2

Here is an example out of one of my forms:

     <field name="fldId" field="id" typecast="number">
        <trigger type="PRE-INSERT" name="fldId_PreInsert"><![CDATA[
# Set default value
if self.isEmpty():

order_seq is the sequence name. Designer adds this trigger automatically if 
dragging from the Schema Navigator to the Layout Editor. 

-- Jason 

On Thursday 03 June 2004 03:30 pm, Erik Dalén wrote:
> Hi
> I'm wondering how you make a Pre-Insert trigger on a field that
> generates a new unique number for that field? For a numeric primary key
> in a SQL table. Should be a quite common thing in 2-tier apps.
> /Erik
> _______________________________________________
> Gnue mailing list
> address@hidden

reply via email to

[Prev in Thread] Current Thread [Next in Thread]