convert database entrys

[Ruslan Zasukhin]

on 11/23/03 5:38 PM, Jonathan Fiagbedzi at j.fiagbedzi at e-novum.com wrote:

Hi Jonathan, 

> I have the following datas in my valentina database:
> 
> Maufa; Sub1; Sub2...
> -------------------
> BMW; Wheel; Tire
> BMW; Wheel; Rim
> BMW; Window; Front
> Audi; Wheel; Tire
> Audi; Wheel; Rim
> Audi; Window; Front
> ...


You keep all this in one table?

In fact not good design because your table is not normalized


> i want to convert the datas into an textfile like this:
> 
> BMW
> Wheel
>   Tire
>   Rim
> Window
>   Front
> Audi
> Wheel
>   Tire
>   Rim
> Window
>   Front
> ...
> 
> how do i manage it, that "BMW" or "Wheel" is not twice in my textfile.

You can create cursor that ORDER BY by all fields.

Now you can iterate records, can compare values with prev record,
If they are the same then do not print them.

You see idea?


> my database has alot of entrys and one record has up to 7 submenus (manufa;
> sub1; sub2; sub3; sub4; sub5; sub6; sub7).
> 
> how do you would make that?
> i use valentina with macromedia director. but i think the solution should be
> everywhere the same.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------