Board index Database

Need help, Transfer record with several infos in several records

Need help, Transfer record with several infos in several records

Post by a.. » Sat, 06 Dec 1997 04:00:00



Hy File Maker Cracks
Does anybody know, how to transfer records with several information into
individual records.
See following example:

Records I have:  

auto    |       tour
-----------------------
592             |       76, 93, 220             (this is one record)
593             |       22, 998, 45             (this is the next record)   and so on...

-------->   transfer into following kind of records:

auto    |       tour    
-----------------------
592             |       76
592             |       93
592             |       220
593             |       22
593             |       998
593             |       45

Do you have an idea     how to create a script in File Maker Pro 3.0?

Ideas, please send to

Thanks a lot for your help.

 
 
 
Top

1. 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

2. MSSQL Server DBA Position in NY

3. Copying a record in a field to several records in same field

4. SQL7 Beta3 DSS - How can I save and restore defined dimensions/cubes ?

5. Adding text from several records to one record

6. How to run dynamic SQL statement w/ cursor?

7. Passing several times a table without repeating records

8. ! How to duplicate database structure

9. storing several records in a variable

10. Using one or several tables for several cust.

11. Several tables or Several databases?!

12. inserting several new records within insert trigger

13. Several DBs vs. One DB with several schemas


All times are UTC
Board index