Break a record up into several record

Hello everyone

I want to do the following:

I have a table long_table

long_table
id number
txt long

The contents of de files txt can be very long (only text). I want to break the long text up into several short record.

If it is possible I want to create a view to that does this function, so i can use this view in a mutil-record block. (forms30)

long_view
id number
row number
txt (max 20 characters)

So if the contents of a record of the long_table is

1,'1234567889012345678890123456788901234567889012345678890'

the view contents must be

1,1,'1234567889012345678890'
1,2,'1234567889012345678890'
1,3,'12345678890'

Does anybody know how to do this?

Thanks,

Guido Reulen
G.Reulen_at_vir.revalidatie.nl Received on Sun Nov 09 1997 - 00:00:00 CST