[Ticket #70] [firebird-support] Detecting default values

2014-03-07 Thread Desarrollo
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:25 pm, d...@tetram.org wrote: Hi, I have a table with a field for which i need a default value. My problem is the default value can change at any time. So the solution I found is to use a before insert trigger. But now, i'm

[Ticket #73] [firebird-support] Detecting default values

2014-03-07 Thread Desarrollo
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:26 pm, mil...@panonnet.net wrote: Tetram Corp wrote: I thought about this solution but hoped there was a better one because of, you're right, in my case the field has a restricted range but i've an other similar case where

[Ticket #70] [firebird-support] Detecting default values

2014-03-07 Thread Desarrollo
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:25 pm, ism...@citricos.co.cu wrote: In the trigger: if (new.myfield is null) then Best Regards = || ISMAEL || = ==Ticket History== On Mar 07, 2014 @ 03:25 pm, chamberlin.d...@gmail.com wrote: No Comment.

Re: [firebird-support] Detecting default values

2011-11-04 Thread Milan Babuskov
Tetram Corp wrote: I thought about this solution but hoped there was a better one because of, you're right, in my case the field has a restricted range but i've an other similar case where there's no limit in value range too bad. I will use this trick for my first case, and think again

Re: [firebird-support] Detecting default values

2011-11-04 Thread Tetram Corp
yes, i have full control about app and database the datatype for the limited range is numeric and varchar for the unlimited one i will think about your idea, it's interesting, thx Le 04/11/2011 16:40, Milan Babuskov a écrit : Tetram Corp wrote: I thought about this solution but hoped there

Re: [firebird-support] Detecting default values

2011-11-03 Thread Ismael L. Donis Garcia
In the trigger: if (new.myfield is null) then Best Regards = || ISMAEL || = - Original Message - From: Tetram Corp To: firebird-support@yahoogroups.com Sent: Thursday, November 03, 2011 1:04 PM Subject: [firebird-support] Detecting default values Hi

Re: [firebird-support] Detecting default values

2011-11-03 Thread Tetram Corp
I thought about this solution but hoped there was a better one because of, you're right, in my case the field has a restricted range but i've an other similar case where there's no limit in value range too bad. I will use this trick for my first case, and think again about app design for the