Yes Ann... I had thought about something like your sugestion before but was
trying to find an easier solution (easier = less code) since there are
many tables and many fields on them ;)

THANKS !

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com

AWH> At 02:49 PM 5/12/2001 -0300, Carlos H. Cantu wrote:

>>I need to call an UDF to parse every field in a table, extracting the words
>>in every field value and storing that words in another table in the same
>>database. Is this possible ? Any better way to do the same thing ?

AWH> Yes, it's possible, but I'm not convinced that it's wise. That
AWH> really sounds like a program more than a UDF. You might do it
AWH> as a stored procedure / UDF combination. The stored procedure
AWH> reads the data, sending each field to the UDF. The UDF returns
AWH> the first word in the string, plus the rest of the string. The
AWH> procedure stores the first bit, then calls the UDF with the
AWH> remainder until the UDF returns an empty string, then moves on
AWH> to the next field.


AWH> Or is that not what you had in mind?

AWH> Regards,

AWH> Ann


AWH> To unsubscribe from this group, send an email to:
AWH> ib-support-unsubscribe@egroups.com



AWH> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/