|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 30th, 2006, 04:27 PM
|
|||
|
|||
|
Computed column and stored procedure
I know you can use an UDF as part of a computed column.
Can you also use a stored procedure? I have tried every sytax combination I can think of without getting the "Computed By" calculation to compile. Thanks, Clive.
|
|
#2
May 31st, 2006, 03:24 AM
|
||||
|
||||
|
I would not use a computed column as it is not portable, can't you use a view or a trigger to get the same result?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
May 31st, 2006, 11:38 AM
|
|||
|
|||
|
Quote:
Of course. The application is highly unlikely to transfer from Firebird and "Computed By" just seemed quicker than creating a view plus the triggers on the view needed to make it editable. As no-one has answered the original question, I will just do the view+triggers or handle it on the client. Thanks, Clive.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Computed column and stored procedure |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
