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

Down

Current record value Find similar branches


Hermit   (2001-12-05 13:22) [0]

Каким образом в триггере можно узнать значение определенного поля текущей записи другой таблицы.
Есть две таблицы: Clients and Contacts, завязанные один ко многим. Необходимо в триггере перед добавлением новой записи присвоить полю IDCLIENT номер текущего Clients.IDCLIENT



Ra   (2001-12-05 13:37) [1]

никаким..такое присвоение в триггере невозможно



User_OKA   (2001-12-05 14:25) [2]

Forget about the cursor in the database. In a trigger, you can program an action using SQL statements, and any query operates with a set of records, the concept of a database cursor is not applicable to it, =>, in a trigger you cannot find out which record has a cursor in the master table.



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top









Memory: 0.81 MB
Time: 0.03 c
4-22461
ShaH
2001-10-29 11:08
2002.01.08
problem with LogonUser (ERROR_PRIVILEGE_NOT_HELD)


1-22220
Kandyl
2001-12-16 15:10
2002.01.08
How to prevent deleting a folder without hanging in the tray?


1-22195
Lnix
2001-12-15 20:00
2002.01.08
string


14-22354
Nemesis
2001-10-08 13:02
2002.01.08
Mobile


14-22390
Hedgehog
2001-11-08 12:54
2002.01.08
Listen Merlin, do you ever sleep? In a sense, relaxing?





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 Español swahili Swedish thai turkish Ukrainian urdu vietnamese 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