|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Using d_boolean domain to return in stored procedure
Hi, I'm using the following domain which i found in the net to be used as a bool datatype:
create domain "D_BOOLEAN" as smallint default 0 check (value between 0 and 1); I have a stored procedure that i would like to return a 1/0 so i have the following: RETURNS ( Success D_BOOLEAN ) But i receive an error: Token unknown -line 9, char 10 D_BOOLEAN Am i using a domain wrong? Thanks |
|
#2
|
||||
|
||||
|
I think that you can't assign a domain to "Success" ... try:
RETURNS ( Success INTEGER ) and set it to 0 or 1 depending on the result.
__________________
If i've been helpful, please add to my reputation. My unfinished site: http://www.dever.ro |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Using d_boolean domain to return in stored procedure |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|