Hi,

When editing the field is read-only,

On insert I need the max of the last three accroding to the the sequence
represented by X00-00-... starting at 1
The field mask on insert lets the user enter the first part and the last
three are filled with *, again a guest is a trigger that looks at the last
three being *** to process. This was so easy in delphi but again it was not
very safe being done on the client. btw the sequence represent
"[A-Z]Year-Month-Sequencial number"


So if I have these

N00-12-001
Z01-03-001
A01-03-001
A01-03-002

The input of A01-03-*** from the field input mask should set the field to
A01-03-003
The input of Z01-03-*** from the field input mask should set the field to
Z01-03-002

Thank again

----- Original Message -----
From: "Ingo Jansen" <Ingo.Jansen@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 14, 2001 11:40 AM
Subject: AW: [IBO] Help on stored procedures/trigger


> Hello Tia,
>
> when (Insert, edit, ...?) you must calculate the value of the last 3
> numbers and how?
>
> -----Ursprungliche Nachricht-----
> Von: Marc Leclerc [mailto:mlpgr@...]
> Gesendet: Mittwoch, 14. Marz 2001 04:34
> An: IBObjects@yahoogroups.com
> Betreff: [IBO] Help on stored procedures/trigger
>
>
> Hi,
> I am not very well versed in stored procedure / trigger and wondering if
> someone could give me pointer on how to create the following.
>
> I have a field made like A00-00-000 where the 3 last number must be
> calcualted by the server before posting so the user enter A00-00- and I
have
> to come up with the last XXX. I had this made on the client side before
but
> I consider that the server should do this either by using a trigger or SP
> (My guess is a trigger may be the best place). In any case if anyone could
> give me pointers I would appreciate.
>
> TIA
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> Click Here to Find Software Faster
> Click Here to Find Software Faster
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>