Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Beginners";
Current archive: 2010.02.07;
Download: [xml.tar.bz2];

Down

An interesting problem with related tables Find similar branches


koha!   (2009-11-26 06:18) [0]

There is a pivot table, it is filled with codes (keys) from other tables, then if one device is deleted in one of the linked tables (for example, devices), then it turns out that these devices will disappear in the whole summary table, since the code of this device has already been entered everywhere.
And what if the device was really incorrectly recorded and it really needs to be removed from the table and, for example, make a sudden table? How do such problems usually solve?



Anatoly Podgoretsky ©   (2009-11-26 09:06) [1]

> koha! (26.11.2009 06: 18: 00) [0]

Really remove.



Sergey13 ©   (2009-11-26 09:08) [2]

> [0] koha! (26.11.09 06: 18)
> What to do

Maybe try to invite a programmer?



Сергей М. ©   (2009-11-26 09:31) [3]


> how do they usually solve such problems?


Usually they are not solved in any way, because no one simply has such “problems”.



Виталий Панасенко   (2009-11-26 09:51) [4]

Why move to another table? Isn’t it easier to store everything in one, and if you made a mistake in the additional details, simply fix them? while you do not need to delete anything, but everything will fall into place



Anatoly Podgoretsky ©   (2009-11-26 10:21) [5]

> Sergey13 (26.11.2009 09: 08: 02) [2]

Tried, does not help



zorik ©   (2009-12-10 15:44) [6]

Show DB structure



Pages: 1 whole branch

Forum: "Beginners";
Current archive: 2010.02.07;
Download: [xml.tar.bz2];

Top





Memory: 0.56 MB
Time: 0.016 c
15-1259935064
@ !! ex
2009-12-04 16:57
2010.02.07
How to change the path to make?


2-1260456442
Proxytel
2009-12-10 17:47
2010.02.07
How to read the read / write indicator of a hard disk?


2-1260544819
Vol4
2009-12-11 18:20
2010.02.07
Work traffic light help


15-1259875818
Jury
2009-12-04 00:30
2010.02.07
Happy Birthday ! 4 December 2009 Friday


2-1260346855
Andrewtitoff
2009-12-09 11:20
2010.02.07
Tidhttp.post





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic Indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish ภาษาไทย turkish Ukrainian urdu Tiếng Việt welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada Khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish