Hello,
in advance, many thanks!
I would like to combine all properties like this:
Property1 Property2 Property3
Property4..
IP54 Yellow With lamp 30W
IP20 Blue Without lamp 40W
Red
50W
60W
In the first step I would like get this:
IP54-Yellow-With lamp-30W
IP54-Yellow-With lamp-40W
IP54-Yellow-Without lamp-30W.
(in the next step, I would like to set Properties which are not possible,
for example 60W is not possible if the Color is red)
For this, I have two tables:
Table A
ID Property (color could be value 1, lamp, IPXX, Watt..) integer
POS (in this sequence I would like to generatet he result) integer
ID itself, Integer, self generated.
Table B
ID itself auto generated integer
ID_Table A references to Table A
Property (yellow, red..)
For example,
Table A
ID Property POS ID itself
1 (Color) 1 10
2(lamp) 2 11
3(Watt) 3 12
Table B
ID itself ID_Table_A Property
101 10 RED
102 10 BLUE
103 10 White
104 11 With Lamp
105 11 Without Lamp
105 12 30 Watt
105 12 40 Watt
105 12 50 Watt
Now I would get:
Red-With Lamp-30 Watt
Red-With Lamp-40 Watt
Red-With Lamp-50 Watt
Red-Without Lamp-30 Watt
Red-Without Lamp-40 Watt
Red-Without Lamp-50 Watt
Blue-With Lamp-30 Watt.. and so on
How can I realize with firebird?
Thank you.
Best regards
Olaf
Mit freundlichen Grüßen / with best regards
Olaf Kluge
S A T R O N Sachsen
Steuerungstechnik GmbH
Johann-Gottlob-Pfaff Straße 7
D-09405 Zschopau
Tel: +49 (0) 3725 / 3506-31
Fax: +49 (0) 3725 / 3506-12
Mobil: +49 (0) 170 / 9292375
E-Mail: <mailto:olaf.kl...@satron.de> olaf.kl...@satron.de
Internet: <http://www.satron.de/> http://www.satron.de/
............................................................................
................
Geschäftsführer: Bernd Grötzschel, Gerd Kaden
Amtsgericht: Chemnitz HRB1218
Ust-ID-Nr: DE141294791
............................................................................
................
Diese E-Mail ist vertraulich. Wenn Sie nicht der beabsichtigte Empfänger
sind, dürfen Sie die Informationen nicht offen legen oder benutzen. Wenn Sie
diese E-Mail durch einen Fehler bekommen haben, teilen Sie uns dies bitte
mit, indem Sie die E-Mail an den Absender zurücksenden. Bitte löschen Sie
danach diese E-Mail.
This email is confidential. If you are not the intended recipient, you must
not disclose or use the information contained in it.
If you have received this mail in error, please tell us immediately by
return email and delete the document.
[Non-text portions of this message have been removed]
