user defined type problem 
Author Message
 user defined type problem

Hi all,

I'm trying to create a user defined type (dir_type) to map a set of strings to a
set of numbers
eg:

'entrata' => 0
'uscita' => 1
'anyotherstring' => ERROR

so my users can write something like this:

direzione is a dir_type
insert into foo(direzione) values('entrata')
or
select * from foo where direzione='entrata'

you can check

http://www.***.com/
for the sql commands

and

http://www.***.com/
for the shared library code

the functions dir_toint() and dir_tochar() work properly:
eg select dir_toint('entrata');
but if I try to select
dir_eqop('entrata','entrata')

the backend crashses
checking the log I notice that the backend crash
after the second elog() in dir_toint()

any ideas?

thank you



Sun, 25 Jul 2004 18:28:18 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. User-defined type problem

2. Weird VB problem: User-defined type not defined!

3. User-defined data type not defined

4. User defined type not defined

5. Help!!-NEWBIE - Application Wizard -(WROX BOOK) Error- User defined type not defined

6. db As Database = User-defined type not defined

7. User-defined type not defined

8. Compile error: User-defined type not defined

9. Compile error: User-defined data type not defined!

10. "Database - user defined type not defined"????

11. User defined type not defined

12. User defined type not defined


 
Powered by phpBB® Forum Software