Мезенцев А.А. Павлов В.М., Байструков К.И. Техническое и программное обеспечение лабораторного комплекса Организация пультов управления современных АСУ ТП

Подождите немного. Документ загружается.

2.6. ʽ̨̨̛̭̖̦̦̭̯̍ ̡̪̱̭̌̌̚ ̨̨̛̥̦̯̬̌ ̨̨̬̖̣̦̌̽̐ ̛̬̖̥̖̦̏

TRACE MODE

ɋɢɫɬɟɦɚ ɪɚɛɨɬɚɟɬ ɜ ɪɟɚɥɶɧɨɦ ɜɪɟɦɟɧɢ, ɟɫɥɢ ɟɟ ɛɵɫɬɪɨɞɟɣɫɬɜɢɟ

ɚɞɟɤɜɚɬɧɨ ɫɤɨɪɨɫɬɢ ɩɪɨɬɟɤɚɧɢɹ ɮɢɡɢɱɟɫɤɢɯ ɩɪɨɰɟɫɫɨɜ ɧɚ ɨɛɴɟɤɬɚɯ

ɤɨɧ-

ɬɪɨɥɹ ɢɥɢ ɭɩɪɚɜɥɟɧɢɹ. Ɍɨ ɟɫɬɶ ɫɢɫɬɟɦɚ ɭɩɪɚɜɥɟɧɢɹ ɞɨɥɠɧɚ ɫɨɛɪɚɬɶ ɞɚɧ-

ɧɵɟ, ɩɪɨɢɡɜɟɫɬɢ ɢɯ ɨɛɪɚɛɨɬɤɭ ɜ ɫɨɨɬɜɟɬɫɬɜɢɢ ɫ ɡɚɞɚɧɧɵɦɢ ɚɥɝɨɪɢɬɦɚɦɢ

ɢ ɜɵɞɚɬɶ ɭɩɪɚɜɥɹɸɳɢɟ ɜɨɡɞɟɣɫɬɜɢɹ ɡɚ ɬɚɤɨɣ ɩɪɨɦɟɠɭɬɨɤ ɜɪɟɦɟɧɢ, ɤɨ-

ɬɨɪɵɣ ɨɛɟɫɩɟɱɢɜɚɟɬ ɭɫɩɟɲɧɨɟ ɪɟɲɟɧɢɟ ɩɨɫɬɚɜɥɟɧɧɵɯ ɩɟɪɟɞ ɫɢɫɬɟɦɨɣ

ɡɚɞɚɱ. Ⱦɥɹ ɷɬɨɣ ɰɟɥɢ ɜ ɫɨɫɬɚɜɟ TRACE MODE ɢɦɟɸɬɫɹ ɫɩɟɰɢɚɥɶɧɵɟ

ɦɨɞɭɥɢ – ɦɨɧɢɬɨɪɵ ɪɟɚɥɶɧɨɝɨ ɜɪɟɦɟɧɢ (ɆɊȼ).

ȼɫɟ ɦɨɧɢɬɨɪɵ

TRACE MODE ɰɢɤɥɢɱɟɫɤɢ ɜɵɩɨɥɧɹɸɬ ɨɩɪɟɞɟɥɟɧ-

ɧɵɣ ɧɚɛɨɪ ɨɩɟɪɚɰɢɣ. ɋɬɪɭɤɬɭɪɚ ɡɚɞɚɱ, ɢɫɩɨɥɧɹɟɦɵɯ ɆɊȼ, ɨɩɪɟɞɟɥɹɟɬɫɹ

ɜ ɛɚɡɟ ɤɚɧɚɥɨɜ. ɆɊȼ ɪɚɛɨɬɚɸɬ ɤɚɤ ɢɧɬɟɪɩɪɟɬɚɬɨɪɵ ɛɚɡɵ ɤɚɧɚɥɨɜ. Ʉɚɠ-

ɞɵɣ ɰɢɤɥ ɫɢɫɬɟɦɵ ɜɤɥɸɱɚɟɬ ɧɟɫɤɨɥɶɤɨ ɨɫɧɨɜɧɵɯ ɨɩɟɪɚɰɢɣ. Ⱦɥɹ ɪɟɲɟ-

ɧɢɹ ɡɚɞɚɱ, ɡɚɞɚɧɧɵɯ ɜ ɭɡɥɟ, ɦɨɧɢɬɨɪ ɦɨɠɟɬ ɫɨɡɞɚɜɚɬɶ ɞɨ 24 ɩɨɬɨɤɨɜ.

ɉɪɢɨɪɢɬɟɬɵ ɩɨɬɨɤɨɜ ɡɚɞɚɧɵ ɩɨ ɭɦɨɥɱɚɧɢɸ, ɨɞɧɚɤɨ ɢɯ ɦɨɠɧɨ ɢɡɦɟɧɢɬɶ

ɧɚ

ɜɤɥɚɞɤɟ Ⱦɨɩɨɥɧɢɬɟɥɶɧɨ ɪɟɞɚɤɬɨɪɚ ɭɡɥɚ. ɉɪɢ ɪɟɞɚɤɬɢɪɨɜɚɧɢɢ ɩɪɢ-

ɨɪɢɬɟɬɨɜ ɨɧɢ ɜɵɛɢɪɚɸɬɫɹ ɢɡ ɫɥɟɞɭɸɳɟɝɨ ɫɩɢɫɤɚ.

–1 – Default;

0 – IDLE;

2 – LOWEST;

4 – BELOW_NORMAL;

6 – NORMAL;

10 – ABOVE_NORMAL;

12 – HIGHEST;

14 – TIME_CRITICAL;

77 – STOP

ɇɢɠɟ ɭɤɚɡɚɧɵ ɡɚɞɚɱɢ, ɜɵɩɨɥɧɹɟɦɵɟ ɜ ɩɨɬɨɤɚɯ:

1 – ɨɫɧɨɜɧɨɣ ɩɨɬɨɤ, ɜɵɩɨɥɧɹɟɦɵɣ ɦɨɧɢɬɨɪɨɦ ɰɢɤɥɢɱɟɫɤɢ. Ɉɞɢɧ

ɰɢɤɥ ɜɤɥɸɱɚɟɬ ɫɥɟɞɭɸɳɢɟ ɩɨɫɥɟɞɨɜɚɬɟɥɶɧɨ ɜɵɩɨɥɧɹɟɦɵɟ ɷɬɚɩɵ:

ɩɨɫɥɟɞɨɜɚɬɟɥɶɧɵɣ ɚɧɚɥɢɡ ɜɫɟɯ ɜɤɥɸɱɟɧɧɵɯ ɤɚɧɚɥɨɜ ɭɡɥɚ (ɩɨ

ɜɨɡɪɚɫɬɚɧɢɸ ɩɨɪɹɞɤɨɜɨɝɨ ɧɨɦɟɪɚ), ɩɟɪɟɫɱɟɬ ɜɫɟɯ ɤɚɧɚɥɨɜ (ɤɪɨɦɟ ɤɚɧɚ-

ɥɨɜ CALL) ɬɢɩɚ INPUT, ɤɨɬɨɪɵɟ ɞɨɥɠɧɵ ɩɟɪɟɫɱɢɬɵɜɚɬɶɫɹ ɜ ɨɫɧɨɜɧɨɦ

ɩɨɬɨɤɟ;

ɩɟɪɟɫɱɟɬ ɢ ɨɬɪɚɛɨɬɤɚ ɤɚɧɚɥɨɜ ɤɥɚɫɫɚ CALL ɨɫɧɨɜɧɨɝɨ ɩɨɬɨɤɚ;

ɩɟɪɟɫɱɟɬ ɤɚɧɚɥɨɜ ɬɢɩɚ OUTPUT, ɤɨɬɨɪɵɟ ɞɨɥɠɧɵ ɩɟɪɟɫɱɢɬɵ-

ɜɚɬɶɫɹ ɜ ɨɫɧɨɜɧɨɦ ɩɨɬɨɤɟ, ɢ ɚɧɚɥɢɡ ɢɯ ɜɵɯɨɞɧɨɝɨ ɡɧɚɱɟɧɢɹ.

ȿɫɥɢ ɢɫɩɨɥɶɡɭɸɬɫɹ ɩɪɢɨɪɢɬɟɬɵ ɩɨɬɨɤɨɜ ɩɨ ɭɦɨɥɱɚɧɢɸ ɢ ɞɥɹ ɰɢɤ-

ɥɚ ɆɊȼ ɭɫɬɚɧɨɜɥɟɧɨ ɜɪɟɦɹ, ɧɟɞɨɫɬɚɬɨɱɧɨɟ ɞɥɹ ɜɵɩɨɥɧɟɧɢɹ ɜɫɟɯ ɟɝɨ ɡɚ-

ɞɚɱ, ɫɢɫɬɟɦɚ ɛɭɞɟɬ ɪɚɛɨɬɨɫɩɨɫɨɛɧɨɣ (ɛɭɞɟɬ ɢɞɬɢ ɨɛɦɟɧ ɩɨ ɩɨɫɥɟɞɨɜɚ-

ɬɟɥɶɧɨɦɭ ɢɧɬɟɪɮɟɣɫɭ ɢ ɫɟɬɢ, ɜɵɩɨɥɧɹɬɶɫɹ ɩɪɨɝɪɚɦɦɵ ɢ ɬ

. ɩ.), ɨɞɧɚɤɨ

ɡɚɞɚɧɧɵɟ ɜɪɟɦɟɧɧɵɟ ɯɚɪɚɤɬɟɪɢɫɬɢɤɢ ɩɟɪɟɫɱɟɬɚ/ɨɬɪɚɛɨɬɤɢ ɤɚɧɚɥɨɜ ɛɭ-

ɞɭɬ ɧɚɪɭɲɚɬɶɫɹ (ɬ. ɟ. ɛɵɫɬɪɨɞɟɣɫɬɜɢɟ ɫɢɫɬɟɦɵ ɫɧɢɡɢɬɫɹ).

2 – ɩɪɢɟɦ ɞɚɧɧɵɯ ɩɨ ɫɟɬɢ IP;

3 – ɩɟɪɟɞɚɱɚ ɞɚɧɧɵɯ ɩɨ ɫɟɬɢ IP;

4 – ɞɟɣɫɬɜɢɟ – ɩɟɱɚɬɶ, ɜɵɜɨɞ ɜ ɮɚɣɥ ɢ ɬ. ɩ.;

5 – ɜɵɩɨɥɧɟɧɢɟ ɡɚɞɚɱ ɜ ɤɚɱɟɫɬɜɟ ɫɟɪɜɟɪɚ DDE, NetDDE;

6 – T-FACTORY (ɪɟɲɟɧɢɟ ɡɚɞɚɱ ɭɩɪɚɜɥɟɧɢɹ ɩɪɟɞɩɪɢɹɬɢɟɦ);

7 – ɨɛɦɟɧ ɩɨ ɩɪɨɬɨɤɨɥɭ MODBUS TCP/IP;

8 – ɜɟɞɟɧɢɟ ɨɬɱɟɬɚ ɬɪɟɜɨɝ;

9 – ɤɨɩɢɪɨɜɚɧɢɟ ɨɬɱɟɬɚ ɬɪɟɜɨɝ;

10 – ɞɚɦɩ ɚɬɪɢɛɭɬɨɜ ɤɚɧɚɥɚ ɞɥɹ ɩɨɫɥɟɞɭɸɳɟɝɨ ɛɟɡɭɞɚɪɧɨɝɨ ɪɟɫ-

ɬɚɪɬɚ ɆɊȼ;

11 – ɨɛɪɚɛɨɬɤɚ ɛɵɫɬɪɵɯ ɤɚɧɚɥɨɜ;

12 – TCP/IP (TCP ɞɥɹ ɭɞɚɥɟɧɧɨɣ ɨɬɥɚɞɤɢ);

13 – ɜɵɡɨɜ ɞɪɚɣɜɟɪɚ t12;

14 – ɜɵɩɨɥɧɟɧɢɟ ɮɭɧɤɰɢɣ MASTER

ɩɪɢ ɨɛɦɟɧɟ ɩɨ ɩɨɫɥɟɞɨɜɚ-

ɬɟɥɶɧɨɦɭ ɢɧɬɟɪɮɟɣɫɭ;

15 – ɜɵɩɨɥɧɟɧɢɟ ɮɭɧɤɰɢɣ SLAVE ɩɪɢ ɨɛɦɟɧɟ ɩɨ ɩɨɫɥɟɞɨɜɚɬɟɥɶ-

ɧɨɦɭ ɢɧɬɟɪɮɟɣɫɭ;

16 – ɨɛɦɟɧ ɫ ɢɫɩɨɥɶɡɨɜɚɧɢɟɦ ɦɨɞɟɦɚ;

17 – ɨɬɨɛɪɚɠɟɧɢɟ ɝɪɚɮɢɱɟɫɤɢɯ ɷɤɪɚɧɨɜ;

18 – ɜɟɞɟɧɢɟ ɛɚɡɵ ɞɚɧɧɵɯ ɪɟɚɥɶɧɨɝɨ ɜɪɟɦɟɧɢ SIAD;

19 – ɝɟɧɟɪɚɰɢɹ ɞɨɤɭɦɟɧɬɨɜ; ɜɵɛɨɪɤɚ ɢɯ ɚɪɯɢɜɨɜ ɫ ɩɨɦɨɳɶɸ ɤɚɧɚ-

ɥɨɜ ɤɥɚɫɫɚ CALL; ɜɵɩɨɥɧɟɧɢɟ ɩɪɨɝɪɚɦɦ, ɜɵɡɵɜɚɟɦɵɯ ɤɚɧɚɥɚɦɢ ɤɥɚɫɫɚ

CALL;

20 – ɜɵɩɨɥɧɟɧɢɟ ɡɚɞɚɱ ɜ ɤɚɱɟɫɬɜɟ ɤɥɢɟɧɬ DDE, NetDDE;

21 – ɨɛɦɟɧ

ɞɚɧɧɵɦɢ ɩɨ ɫɟɬɢ ɫɨɬɨɜɨɣ ɫɜɹɡɢ GSM.

ȼɪɟɦɹ ɰɢɤɥɚ ɦɨɧɢɬɨɪɚ. ɉɪɢ ɤɨɧɮɢɝɭɪɢɪɨɜɚɧɢɢ ɭɡɥɚ ɧɟɨɛɯɨɞɢɦɨ

ɡɚɞɚɬɶ ɜɪɟɦɹ, ɨɬɜɨɞɢɦɨɟ ɦɨɧɢɬɨɪɭ ɧɚ ɰɢɤɥ (ɨɞɧɨɤɪɚɬɧɨɟ ɜɵɩɨɥɧɟɧɢɟ ɡɚ-

ɞɚɱ ɨɫɧɨɜɧɨɝɨ ɩɨɬɨɤɚ). ɍɩɪɚɜɥɹɹ ɜɪɟɦɟɧɟɦ ɰɢɤɥɚ ɢ ɩɪɢɨɪɢɬɟɬɚɦɢ ɩɨɬɨ-

ɤɨɜ ɦɨɧɢɬɨɪɚ, ɚ ɬɚɤɠɟ ɜɪɟɦɟɧɧɵɦɢ ɯɚɪɚɤɬɟɪɢɫɬɢɤɚɦɢ ɩɟɪɟɫɱɟɬɚ ɨɬɞɟɥɶ-

ɧɵɯ ɤɚɧɚɥɨɜ, ɦɨɠɧɨ ɨɩɬɢɦɢɡɢɪɨɜɚɬɶ ɛɵɫɬɪɨɞɟɣɫɬɜɢɟ ɫɢɫɬɟɦɵ. ȼɪɟɦɹ

ɰɢɤɥɚ ɧɚɫɬɪɚɢɜɚɟɬɫɹ ɫ ɩɨɦɨɳɶɸ ɞɜɭɯ ɩɚɪɚɦɟɬɪɨɜ, ɤɨɬɨɪɵɟ ɡɚɞɚɸɬɫɹ ɜ

ɪɚɡɞɟɥɟ

ɉɟɪɟɫɱɟɬ ɜɤɥɚɞɤɢ Ɉɫɧɨɜɧɵɟ ɪɟɞɚɤɬɨɪɚ ɩɚɪɚɦɟɬɪɨɜ ɭɡɥɚ. ɉɚɪɚ-

ɦɟɬɪ

Ɋɚɡɪɟɲɟɧɢɟ ɡɚɞɚɟɬ ɪɚɡɪɟɲɟɧɢɟ ɬɚɣɦɟɪɚ tick (ɜ ɫɟɤɭɧɞɚɯ), ɩɚɪɚɦɟɬɪ

ɉɟɪɢɨɞ – ɩɟɪɢɨɞ ɩɟɪɟɫɱɟɬɚ ɜ ɟɞɢɧɢɰɚɯ tick: ɉɪɨɢɡɜɟɞɟɧɢɟ ɷɬɢɯ ɩɚɪɚɦɟɬ-

ɪɨɜ ɨɩɪɟɞɟɥɹɟɬ ɜɪɟɦɹ ɰɢɤɥɚ ɦɨɧɢɬɨɪɚ ɜ ɫɟɤɭɧɞɚɯ. Ɋɚɡɪɟɲɟɧɢɟ ɬɚɣɦɟɪɚ

(tick) ɦɨɠɟɬ ɜɚɪɶɢɪɨɜɚɬɶɫɹ ɜ ɩɪɟɞɟɥɚɯ, ɭɤɚɡɚɧɧɵɯ ɜ ɫɩɢɫɤɟ.

ɜ MS Windows – ɧɟ ɦɟɧɟɟ 0,01 c;

ɜ MS WinCE – ɧɟ ɦɟɧɟɟ 0,001 ɫ;

ɜ MS DOS – ɜ ɞɢɚɩɚɡɨɧɟ

0,001 ɫ – 0,055 ɫ;

ɜ MinOS7 ɢ ROM-DOS –

ɧɟ ɦɟɧɟɟ 0,055. ɫ

ɉɨ ɭɦɨɥɱɚɧɢɸ ɪɚɡɪɟɲɟɧɢɟ ɬɚɣɦɟɪɚ ɪɚɜɧɨ 0,055 ɫ, ɩɟɪɢɨɞ – 10.

Ɋɟɚɥɶɧɨɟ ɜɪɟɦɹ ɰɢɤɥɚ ɦɨɠɟɬ ɛɵɬɶ ɧɟɦɧɨɝɨ ɛɨɥɶɲɟ ɭɫɬɚɧɨɜɥɟɧɧɨɝɨ ɡɧɚ-

ɱɟɧɢɹ.

ɉɪɢ ɤɨɧɮɢɝɭɪɢɪɨɜɚɧɢɢ ɆɊȼ ɦɨɠɟɬ ɛɵɬɶ ɨɩɪɟɞɟɥɟɧ ɮɚɣɥ ɜɨɫɫɬɚ-

ɧɨɜɥɟɧɢɹ (ɞɚɦɩ). ȼ ɷɬɨɬ ɮɚɣɥ ɦɨɧɢɬɨɪ ɡɚɩɢɫɵɜɚɟɬ ɩɨɫɥɟɞɧɢɟ ɡɧɚɱɟɧɢɹ

ɚɬɪɢɛɭɬɨɜ ɤɚɧɚɥɨɜ ɭɡɥɚ. Ⱦɚɧɧɵɟ ɡɚɧɨɫɹɬɫɹ ɜ ɞɚɦɩ ɩɨ ɤɚɧɚɥɚɦ, ɞɥɹ ɤɨɬɨ-

ɪɵɯ ɭɫɬɚɧɨɜɥɟɧ ɫɨɨɬɜɟɬɫɬɜɭɸɳɢɣ ɮɥɚɝ, ɚ ɬɚɤɠɟ

ɩɨ ɤɚɧɚɥɚɦ, ɫɨɡɞɚɧɧɵɦ

ɩɪɢ ɪɚɛɨɬɟ ɜ ɪɟɚɥɶɧɨɦ ɜɪɟɦɟɧɢ. Ⱦɚɦɩ ɢɫɩɨɥɶɡɭɟɬɫɹ ɞɥɹ ɜɨɫɫɬɚɧɨɜɥɟɧɢɹ

ɡɧɚɱɟɧɢɣ ɤɚɧɚɥɨɜ ɭɡɥɚ ɩɨɫɥɟ ɪɟɫɬɚɪɬɚ ɦɨɧɢɬɨɪɚ.

2.7. ˁ̨̛̦̖̔̌̚ ̵̬̭̪̬̖̖̣̖̦̦̼̌̔ ̛̭̭̯̖̥ ̛̱̪̬̣̖̦̌̏́

Ɋɚɫɩɪɟɞɟɥɟɧɧɵɟ ɫɢɫɬɟɦɵ ɜ ɢɧɬɟɝɪɢɪɨɜɚɧɧɨɣ ɫɪɟɞɟ TRACE MODE

6 ɪɚɡɪɚɛɚɬɵɜɚɸɬɫɹ ɦɟɬɨɞɨɦ ɤɨɧɮɢɝɭɪɢɪɨɜɚɧɢɹ ɢɧɮɨɪɦɚɰɢɨɧɧɵɯ ɩɨɬɨ-

ɤɨɜ. Ɉɫɧɨɜɧɨɣ ɩɪɢɧɰɢɩ ɤɨɧɮɢɝɭɪɢɪɨɜɚɧɢɹ ɢɧɮɨɪɦɚɰɢɨɧɧɨɝɨ ɩɨɬɨɤɚ ɜ

ɂɋ ɡɚɤɥɸɱɚɟɬɫɹ ɜ ɧɟɡɚɜɢɫɢɦɨɦ ɨɩɢɫɚɧɢɢ ɡɜɟɧɶɟɜ ɩɨɬɨɤɚ ɫ ɞɚɥɶɧɟɣɲɢɦ

ɡɚɞɚɧɢɟɦ ɫɜɹɡɟɣ ɦɟɠɞɭ ɡɜɟɧɶɹɦɢ.

Ⱦɨ ɬɟɯ ɩɨɪ, ɩɨɤɚ ɪɟɱɶ ɢɞɟɬ ɨ ɫɜɹɡɢ ɦɟɠɞɭ ɤɨɦɩɨɧɟɧɬɚɦɢ ɨɞɧɨɝɨ

ɭɡɥɚ, ɧɟ ɜɨɡɧɢɤɚɟɬ ɜɨɩɪɨɫ ɨɛ ɚɩɩɚɪɚɬɧɨ/ɩɪɨɝɪɚɦɦɧɨɦ ɢɧɬɟɪɮɟɣɫɟ, ɤɨɬɨ-

ɪɵɣ ɞɨɥɠɟɧ ɛɵɬɶ ɡɚɞɟɣɫɬɜɨɜɚɧ ɞɥɹ ɨɛɟɫɩɟɱɟɧɢɹ ɫɜɹɡɢ, – ɜ ɷɬɨɦ ɫɥɭɱɚɟ

ɞɨɫɬɚɬɨɱɧɨ ɜɵɩɨɥɧɢɬɶ ɤɨɧɮɢɝɭɪɢɪɨɜɚɧɢɟ ɫɜɨɣɫɬɜ

ɫɜɹɡɶ/ɜɵɡɨɜ ɤɨɦɩɨ-

ɧɟɧɬɨɜ. ȿɫɥɢ ɜɡɚɢɦɨɞɟɣɫɬɜɭɸɳɢɟ ɤɨɦɩɨɧɟɧɬɵ ɨɬɧɨɫɹɬɫɹ ɤ ɪɚɡɧɵɦ ɭɡ-

ɥɚɦ, ɢɧɬɟɪɮɟɣɫ ɫɜɹɡɢ, ɤɚɤ ɩɪɚɜɢɥɨ, ɞɨɥɠɟɧ ɛɵɬɶ ɭɤɚɡɚɧ ɢ ɫɤɨɧɮɢɝɭɪɢ-

ɪɨɜɚɧ. ɇɚɩɪɢɦɟɪ, ɩɪɢ ɡɚɞɚɧɢɢ ɫɜɹɡɢ ɞɜɭɯ ɤɚɧɚɥɨɜ ɪɚɡɧɵɯ ɭɡɥɨɜ ɩɨ ɩɨ-

ɫɥɟɞɨɜɚɬɟɥɶɧɨɦɭ ɢɧɬɟɪɮɟɣɫɭ ɧɟɨɛɯɨɞɢɦɨ ɫɨɡɞɚɬɶ ɜ ɭɡɥɚɯ ɤɨɦɩɨɧɟɧɬɵ

COM-ɩɨɪɬ, ɡɚɞɚɬɶ ɞɥɹ ɧɢɯ ɧɟɨɛɯɨɞɢɦɵɟ ɩɚɪɚɦɟɬɪɵ ɢ ɭɤɚɡɚɬɶ ɞɥɹ ɤɚɧɚ-

ɥɚ-ɩɪɢɟɦɧɢɤɚ ɢɫɩɨɥɶɡɭɟɦɵɣ ɢɧɬɟɪɮɟɣɫ ɫɜɹɡɢ.

ɋɜɨɣɫɬɜɨ

ɫɜɹɡɶ ɦɨɠɟɬ ɛɵɬɶ ɡɚɞɚɧɨ ɞɥɹ ɤɨɦɩɨɧɟɧɬɚ ɩɪɢ ɤɨɩɢɪɨ-

ɜɚɧɢɢ ɢ ɜɫɬɚɜɤɟ ɜ ɨɤɧɟ ɫɜɨɣɫɬɜ, ɚ ɜ ɫɥɭɱɚɟ ɤɚɧɚɥɚ – ɢ ɜ ɟɝɨ ɪɟɞɚɤɬɨɪɟ.

ɋɜɨɣɫɬɜɨ

ɜɵɡɨɜ ɦɨɠɟɬ ɛɵɬɶ ɡɚɞɚɧɨ ɞɥɹ ɤɨɦɩɨɧɟɧɬɚ ɩɪɢ ɤɨɩɢɪɨɜɚɧɢɢ ɢ

ɜɫɬɚɜɤɟ ɢ ɜ ɨɤɧɟ ɫɜɨɣɫɬɜ.

2.7.1. ʽ̶̛̛̬̦̐̌̌́̚ ̨̨̭̖̯̖̏̐ ̨̛̛̥̖̜̭̯̏̌̔̏́̚ ̥̖̙̱̔ ʺˀʦ

ɋɭɳɟɫɬɜɭɸɬ ɬɪɢ ɨɫɧɨɜɧɵɟ ɚɪɯɢɬɟɤɬɭɪɵ ɫɟɬɟɜɨɝɨ ɨɛɦɟɧɚ, ɤɨɬɨɪɵɟ

ɢɫɩɨɥɶɡɭɸɬɫɹ ɜ Ⱥɋɍ Ɍɉ: «Ʉɥɢɟɧɬ/ɋɟɪɜɟɪ», «Master/Slave» (ɜɟɞɭɳɢɣ /

ɜɟɞɨɦɵɣ) ɢ ɨɛɦɟɧ ɫ ɩɨɦɨɳɶɸ ɲɢɪɨɤɨɜɟɳɚɬɟɥɶɧɵɯ ɩɚɤɟɬɨɜ.

Ⱥɥɝɨɪɢɬɦ Ʉɥɢɟɧɬ/ɋɟɪɜɟɪ ɜ ɨɫɧɨɜɧɨɦ ɢɫɩɨɥɶɡɭɟɬɫɹ ɜ ɨɮɢɫɧɵɯ

ɩɪɢɥɨɠɟɧɢɹɯ, ɢɧɢɰɢɚɬɨɪɨɦ ɨɛɦɟɧɚ ɹɜɥɹɟɬɫɹ ɤɥɢɟɧɬ. ȼ ȺɋɍɌɉ ɷɬɨɬ ɚɥ-

ɝɨɪɢɬɦ ɦɨɠɟɬ ɢɫɩɨɥɶɡɨɜɚɬɶɫɹ ɬɨɥɶɤɨ ɧɚ ɜɟɪɯɧɟɦ ɭɪɨɜɧɟ, ɝɞɟ ɧɟ ɪɟɲɚ-

ɸɬɫɹ ɡɚɞɚɱɢ ɧɟɩɨɫɪɟɞɫɬɜɟɧɧɨɝɨ

ɭɩɪɚɜɥɟɧɢɹ ɨɛɴɟɤɬɨɦ ɢɥɢ ɩɪɨɰɟɫɫɨɦ.

Ɍɚɤ ɤɚɤ ɩɨɬɨɤ ɡɚɩɪɨɫɨɜ ɤɥɢɟɧɬɨɜ ɧɟ ɞɟɬɟɪɦɢɧɢɪɨɜɚɧ, ɜ ɫɟɪɜɟɪɟ ɫɨɡɞɚɟɬ-

ɫɹ ɨɱɟɪɟɞɶ ɡɚɩɪɨɫɨɜ. ɉɨɷɬɨɦɭ ɜɪɟɦɹ ɩɨɥɭɱɟɧɢɹ ɨɬɜɟɬɚ ɧɟɞɟɬɟɪɦɢɧɢɪɨ-

ɜɚɧɨ. ȼ ɫɥɭɱɚɟ ɛɨɥɶɲɨɝɨ ɤɨɥɢɱɟɫɬɜɚ ɡɚɩɪɨɫɨɜ ɫɟɪɜɟɪ ɦɨɠɟɬ ɧɟ ɭɫɩɟɜɚɬɶ

ɨɛɪɚɛɚɬɵɜɚɬɶ ɡɚɩɪɨɫɵ, ɚ ɡɧɚɱɢɬɟɥɶɧɨɟ ɜɪɟɦɹ ɡɚɧɢɦɚɬɶɫɹ ɨɛɫɥɭɠɢɜɚɧɢ-

ɟɦ ɨɱɟɪɟɞɢ.

ȼ ɚɥɝɨɪɢɬɦɟ «Master/Slave» ɨɞɧɚ ɜɟɞɭɳɚɹ ɫɬɚɧɰɢɹ ɜ ɪɚɫɩɪɟɞɟɥɟɧ-

ɧɨɣ Ⱥɋɍ Ɍɉ ɭɩɪɚɜɥɹɟɬ ɨɛɦɟɧɨɦ. ɉɪɨɰɟɫɫ ɨɛɦɟɧɚ ɨɩɢɫɵɜɚɟɬɫɹ ɩɚɪɚɦɢ

ɫɟɬɟɜɵɯ ɫɨɨɛɳɟɧɢɣ «Ɂɚɩɪɨɫ ɞɚɧɧɵɯ ĺ Ɉɬɜɟɬ»; «Ʉɨɦɚɧɞɚ ĺ

ɉɨɞɬɜɟɪ-

ɠɞɟɧɢɟ». Ɂɚɩɪɨɫɵ ɜɵɞɚɸɬɫɹ ɩɨɫɥɟɞɨɜɚɬɟɥɶɧɨ ɜɨ ɜɪɟɦɟɧɢ, ɬ. ɟ. ɜɟɞɭɳɢɣ

ɭɡɟɥ ɜɵɞɚɟɬ ɡɚɩɪɨɫ ɢ ɠɞɟɬ ɨɬɜɟɬ, ɚ ɡɚɬɟɦ ɜɵɞɚɟɬ ɡɚɩɪɨɫ ɞɪɭɝɨɦɭ ɩɨɞɱɢ-

ɧɟɧɧɨɦɭ ɭɡɥɭ. Ⱥɥɝɨɪɢɬɦ ɩɨɡɜɨɥɹɟɬ ɨɰɟɧɢɬɶ ɬɨɱɧɨɟ ɜɪɟɦɹ, ɡɚɬɪɚɱɢɜɚɟ-

ɦɨɟ ɧɚ ɨɛɦɟɧ. ɗɬɨ ɜɪɟɦɹ ɪɚɫɬɟɬ ɫ ɪɨɫɬɨɦ ɱɢɫɥɚ ɩɨɞɱɢɧɟɧɧɵɯ ɭɡɥɨɜ ɭɱɚ-

ɫɬɜɭɸɳɢɯ ɜ ɨɛɦɟɧɟ.

ɒɢɪɨɤɨɜɟɳɚɬɟɥɶɧɵɟ ɪɚɫɫɵɥɤɢ ɫɨɨɛɳɟɧɢɣ ɢɫɩɨɥɶɡɭɸɬɫɹ ɩɪɢ

ɧɟ-

ɨɛɯɨɞɢɦɨɫɬɢ ɨɞɧɨɜɪɟɦɟɧɧɨɣ ɪɚɫɫɵɥɤɚ ɢɧɮɨɪɦɚɰɢɢ ɦɧɨɝɢɦ ɩɨɬɪɟɛɢɬɟ-

ɥɹɦ. ɉɪɢ ɬɚɤɨɦ ɫɩɨɫɨɛɟ ɨɛɦɟɧɚ ɢɧɮɨɪɦɚɰɢɟɣ ɜɨɡɧɢɤɚɟɬ ɧɟɨɛɯɨɞɢɦɨɫɬɶ

ɫɨɡɞɚɧɢɹ ɨɱɟɪɟɞɟɣ ɫɨ ɫɬɨɪɨɧɵ ɤɥɢɟɧɬɚ.

ȼ ɌRACE ɆODE ɢɫɩɨɥɶɡɭɸɬɫɹ ɞɜɚ ɚɥɝɨɪɢɬɦɚ ɫɟɬɟɜɨɝɨ ɜɡɚɢɦɨ-

ɞɟɣɫɬɜɢɹ «Master/Slave» ɢ ɲɢɪɨɤɨɜɟɳɚɬɟɥɶɧɵɣ (ɜ ɬɟɪɦɢɧɚɯ ɌRACE

ɆODE – «Ⱥɜɬɨɩɨɫɵɥɤɚ ɜ ɫɟɬɶ»).

ɉɪɢ ɫɜɹɡɢ ɤɚɧɚɥɨɜ ɜ ɤɚɱɟɫɬɜɟ

ɢɧɬɟɪɮɟɣɫɚ ɜɡɚɢɦɨɞɟɣɫɬɜɢɹ ɦɨɝɭɬ

ɛɵɬɶ ɡɚɞɚɧɵ:

CHNET – ɩɨ ɫɟɬɢ ɩɨ ɩɪɨɬɨɤɨɥɭ IP;

CHMLINK – ɩɨ ɩɨɫɥɟɞɨɜɚɬɟɥɶɧɨɦɭ ɢɧɬɟɪɮɟɣɫɭ ɩɨ ɩɪɨɬɨɤɨɥɭ

M-LINK.

ɉɪɢ ɜɡɚɢɦɨɞɟɣɫɬɜɢɢ ɫ ɞɪɭɝɢɦ ɭɡɥɨɦ ɜɨ ɜɫɟɯ ɫɥɭɱɚɹɯ (ɤɪɨɦɟ

ɩɪɢɟɦɚ ɫɟɬɟɜɵɯ ɚɜɬɨɩɨɫɵɥɨɤ) ɤɚɧɚɥ ɫ ɧɚɫɬɪɨɟɧɧɵɦ ɫɜɨɣɫɬɜɨɦ

ɫɜɹɡɶ

ɩɨɫɵɥɚɟɬ ɡɚɩɪɨɫ (ɜ ɫɥɭɱɚɟ ɢɧɬɟɪɮɟɣɫɚ CHNET – ɧɚ IP-ɚɞɪɟɫ ɭɞɚɥɟɧɧɨɝɨ

ɫɟɬɟɜɨɝɨ ɭɡɥɚ), ɫɨɞɟɪɠɚɳɢɣ ɭɤɚɡɚɧɢɟ ɭɞɚɥɟɧɧɨɦɭ ɤɚɧɚɥɭ ɩɟɪɟɞɚɬɶ ɫɜɨɟ

ɡɧɚɱɟɧɢɟ ɢɥɢ ɢɡɦɟɧɢɬɶ ɟɝɨ, ɢ ɩɪɢɧɢɦɚɟɬ ɨɬɜɟɬ, ɫɨɞɟɪɠɚɳɢɣ ɢɧɮɨɪɦɚ-

ɰɢɸ ɨ ɜɵɩɨɥɧɟɧɢɢ ɡɚɩɪɨɫɚ. ɉɪɢ ɩɪɢɟɦɟ ɫɟɬɟɜɨɣ ɚɜɬɨɩɨɫɵɥɤɢ ɨɬɜɟɬ ɧɟ

ɝɟɧɟɪɢɪɭɟɬɫɹ.

Ⱥɜɬɨɩɨɫɵɥɤɚ – ɷɬɨ ɫɩɨɫɨɛɧɨɫɬɶ ɦɨɧɢɬɨɪɚ ɩɟɪɟɞɚɜɚɬɶ ɜ ɫɟɬɶ ɪɟ-

ɚɥɶɧɵɟ ɡɧɚɱɟɧɢɹ ɤɚɧɚɥɨɜ ɜ ɜɢɞɟ ɲɢɪɨɤɨɜɟɳɚɬɟɥɶɧɵɯ ɫɨɨɛɳɟɧɢɣ

(ɜ ɫɟɬɢ

TCP/IP ɲɢɪɨɤɨɜɟɳɚɬɟɥɶɧɵɟ ɫɨɨɛɳɟɧɢɹ ɨɬɩɪɚɜɥɹɸɬɫɹ ɩɨ ɫɩɟɰɢɚɥɶɧɨɦɭ

IP-ɚɞɪɟɫɭ, ɜɫɟ ɛɢɬɵ ɤɨɬɨɪɨɝɨ ɪɚɜɧɵ ɟɞɢɧɢɰɟ). Ɇɨɧɢɬɨɪ ɝɟɧɟɪɢɪɭɟɬ ɬɚ-

ɤɢɟ ɫɨɨɛɳɟɧɢɹ ɩɨ ɤɚɧɚɥɚɦ ɥɸɛɨɝɨ ɬɢɩɚ (ɤɚɤ INPUT, ɬɚɤ ɢ OUTPUT) ɫ

ɭɫɬɚɧɨɜɥɟɧɧɵɦ ɮɥɚɝɨɦ

ɚɜɬɨɩɨɫɵɥɤɚ ɩɪɢ ɤɚɠɞɨɦ ɢɡɦɟɧɟɧɢɢ ɢɯ ɪɟɚɥɶ-

ɧɨɝɨ ɡɧɚɱɟɧɢɹ.

ȼɢɞ ɜɡɚɢɦɨɞɟɣɫɬɜɢɹ ɤɚɧɚɥɨɜ ɡɚɞɚɟɬ ɯɚɪɚɤɬɟɪɢɫɬɢɤɚ

ɜɢɞ ɫɜɹɡɢ:

CHCOPY – ɤɨɩɢɪɨɜɚɧɢɟ/ɭɫɬɚɧɨɜɤɚ ɡɧɚɱɟɧɢɹ ɭɞɚɥɟɧɧɨɝɨ

ɤɚɧɚɥɚ (ɡɚɩɪɨɫ/ɨɬɜɟɬ);

x CHASEND – ɩɪɢɟɦ ɫɟɬɟɜɨɣ ɚɜɬɨɩɨɫɵɥɤɢ (ɩɨɞɬɜɟɪɠɞɟɧɢɟ

ɩɪɢɟɦɚ ɧɟ ɝɟɧɟɪɢɪɭɟɬɫɹ). Ʉɚɧɚɥɵ, ɩɪɢɧɢɦɚɸɳɢɟ ɚɜɬɨɩɨɫɵɥɤɢ, ɞɨɥɠɧɵ

ɢɦɟɬɶ ɬɢɩ INPUT;

CHGROUP – ɡɚɩɪɨɫ/ɨɬɜɟɬ ɩɨ ɝɪɭɩɩɨɜɨɦɭ ɧɨɦɟɪɭ;

CHFAULT – ɡɚɩɪɨɫ/ɨɬɜɟɬ ɩɨ ɪɟɡɟɪɜɚɦ;

CHCS – ɫɩɟɰɢɮɢɱɟɫɤɢɣ ɜɢɞ ɜɡɚɢɦɨɞɟɣɫɬɜɢɹ.

ɉɪɢ ɤɨɧɮɢɝɭɪɢɪɨɜɚɧɢɢ ɫɜɹɡɢ ɤɚɧɚɥɨɜ ɪɚɡɧɵɯ ɭɡɥɨɜ ɢɯ ɜɡɚɢɦɨɞɟɣ-

ɫɬɜɢɟ ɡɚɞɚɟɬɫɹ ɧɚ ɜɤɥɚɞɤɟ

ɂɧɮɨɪɦɚɰɢɹ ɨɤɧɚ ɫɜɨɣɫɬɜ ɤɚɧɚɥɚ (ɪɢɫ. 2.12)

ɫ ɩɨɦɨɳɶɸ ɜɵɛɨɪɚ ɢɡ ɫɩɢɫɤɚ ɨɞɧɨɣ ɢɡ ɫɥɟɞɭɸɳɢɯ ɨɩɰɢɣ:

Ɋɢɫ. 2.12. ȼɢɞɟɨɝɪɚɦɦɚ ɢɧɮɨɪɦɚɰɢɨɧɧɨɝɨ ɬɚɛɥɨ ɤɚɧɚɥɨɜ ɜ TRACE MODE

x Auto – CHNET/CHMLINK. ȿɫɥɢ ɞɨɫɬɭɩɧɨ ɜɡɚɢɦɨɞɟɣɫɬɜɢɟ ɩɨ

ɫɟɬɢ, ɛɭɞɟɬ ɭɫɬɚɧɨɜɥɟɧ ɢɧɬɟɪɮɟɣɫ CHNET ɜɧɟ ɡɚɜɢɫɢɦɨɫɬɢ ɨɬ ɜɨɡ-

ɦɨɠɧɨɫɬɢ ɜɡɚɢɦɨɞɟɣɫɬɜɢɹ ɩɨ ɢɧɬɟɪɮɟɣɫɭ RS. ɉɪɢ ɭɫɬɚɧɨɜɤɟ ɢɧɬɟɪɮɟɣ-

ɫɚ CHMLINK ɢɫɩɨɥɶɡɭɟɬɫɹ ɩɟɪɜɵɣ ɨɛɧɚɪɭɠɟɧɧɵɣ COM-ɩɨɪɬ, ɤɨɬɨɪɵɣ

ɫɤɨɧɮɢɝɭɪɢɪɨɜɚɧ ɤɨɪɪɟɤɬɧɨ. Ɉɩɰɢɹ

Ⱥɜɬɨ ɡɚɞɚɟɬɫɹ ɩɨ ɭɦɨɥɱɚɧɢɸ;

TCP – ɩɨ TCP;

RS 1 – CHMLINK, ɢɫɩɨɥɶɡɭɟɬɫɹ ɩɟɪɜɵɣ ɨɛɧɚɪɭɠɟɧɧɵɣ COM-

ɩɨɪɬ, ɤɨɬɨɪɵɣ ɫɤɨɧɮɢɝɭɪɢɪɨɜɚɧ ɤɨɪɪɟɤɬɧɨ;

RS 2 – CHMLINK, ɢɫɩɨɥɶɡɭɟɬɫɹ ɜɬɨɪɨɣ ɨɛɧɚɪɭɠɟɧɧɵɣ COM-

ɩɨɪɬ, ɤɨɬɨɪɵɣ ɫɤɨɧɮɢɝɭɪɢɪɨɜɚɧ ɤɨɪɪɟɤɬɧɨ;

GSM SMS 1 – ɜ ɜɢɞɟ SMS-ɫɨɨɛɳɟɧɢɹ, ɢɫɩɨɥɶɡɭɟɬɫɹ ɩɟɪɜɵɣ

ɨɛɧɚɪɭɠɟɧɧɵɣ ɦɨɞɟɦ;

GSM SMS 2 – ɜ ɜɢɞɟ SMS-ɫɨɨɛɳɟɧɢɹ, ɢɫɩɨɥɶɡɭɟɬɫɹ ɜɬɨɪɨɣ

ɨɛɧɚɪɭɠɟɧɧɵɣ ɦɨɞɟɦ;

Group – CHGROUP.

Ⱦɥɹ ɭɩɪɚɜɥɟɧɢɹ ɨɛɦɟɧɨɦ ɩɨ ɫɟɬɢ ɢɫɩɨɥɶɡɭɸɬɫɹ ɤɚɧɚɥɵ, ɫɜɹɡɚɧ-

ɧɵɟ ɫɨ ɫɥɟɞɭɸɳɢɦɢ ɫɢɫɬɟɦɧɵɦɢ ɩɟɪɟɦɟɧɧɵɦɢ TRACE MODE (ɝɪɭɩɩɚ

ɋɂɋɌȿɆɇɕȿ).

@Mode_Control. x @Status

2.7.2. ʽ̥̖̦̍ ̭ ̛̥̍̌̌̚ ̵̦̦̼̔̌

Ⱦɥɹ ɜɡɚɢɦɨɞɟɣɫɬɜɢɹ ɫ ɛɚɡɚɦɢ ɞɚɧɧɵɯ (ɞɚɥɟɟ – ȻȾ) ɜ TRACE

MODE 6 ɜɫɬɪɨɟɧɚ ɩɨɞɞɟɪɠɤɚ ɹɡɵɤɚ

SQL. Ɉɫɧɨɜɧɵɦɢ ɮɭɧɤɰɢɹɦɢ, ɜɵ-

ɩɨɥɧɹɟɦɵɦɢ TRACE MODE 6 ɩɪɢ ɪɚɛɨɬɟ ɫ ȻȾ, ɹɜɥɹɸɬɫɹ ɫɥɟɞɭɸɳɢɟ:

ɩɨɞɤɥɸɱɟɧɢɟ ɤ ȻȾ ɩɨ ɩɪɨɬɨɤɨɥɭ ODBC3;

ɫɨɡɞɚɧɢɟ ɧɨɜɵɯ ɢɫɬɨɱɧɢɤɨɜ ɞɚɧɧɵɯ ODBC (ɩɪɢ ɪɟɞɚɤɬɢɪɨ-

ɜɚɧɢɢ ɩɪɨɟɤɬɚ);

ɨɬɨɛɪɚɠɟɧɢɟ ɢɧɮɨɪɦɚɰɢɢ ɨ ɫɬɪɭɤɬɭɪɟ ȻȾ (ɩɪɢ ɪɟɞɚɤɬɢɪɨɜɚɧɢɢ

ɩɪɨɟɤɬɚ);

ɫɨɡɞɚɧɢɟ ɢ ɪɟɞɚɤɬɢɪɨɜɚɧɢɟ ɡɚɩɪɨɫɨɜ ɤ ȻȾ, ɜ ɬɨɦ ɱɢɫɥɟ ɩɪɢ

ɩɨɦɨɳɢ ɦɚɫɬɟɪɚ (ɩɪɢ ɪɟɞɚɤɬɢɪɨɜɚɧɢɢ ɩɪɨɟɤɬɚ);

ɜɵɩɨɥɧɟɧɢɟ ɡɚɩɪɨɫɨɜ ɤ ȻȾ (ɩɪɢ ɪɟɞɚɤɬɢɪɨɜɚɧɢɢ ɩɪɨɟɤɬɚ ɢ ɜ

ɪɟɚɥɶɧɨɦ ɜɪɟɦɟɧɢ).

Ⱦɥɹ ɩɪɨɝɪɚɦɦɢɪɨɜɚɧɢɹ ɫɜɹɡɟɣ ɫ ȻȾ ɜ ɢɧɬɟɝɪɢɪɨɜɚɧɧɭɸ ɫɪɟɞɭ ɪɚɡ-

ɪɚɛɨɬɤɢ ɩɪɨɟɤɬɚ ɜɫɬɪɨɟɧ

ɪɟɞɚɤɬɨɪ ɫɜɹɡɟɣ ɫ ɛɚɡɚɦɢ ɞɚɧɧɵɯ. ɗɬɨɬ ɪɟ-

ɞɚɤɬɨɪ ɫɧɚɛɠɟɧ

ɦɚɫɬɟɪɨɦ, ɩɨɡɜɨɥɹɸɳɢɦ ɩɨɥɶɡɨɜɚɬɟɥɹɦ ɤɨɧɮɢɝɭɪɢɪɨ-

ɜɚɬɶ ɨɫɧɨɜɧɵɟ ɨɩɟɪɚɰɢɢ ɩɨ ɜɡɚɢɦɨɞɟɣɫɬɜɢɸ ɫ ɛɚɡɚɦɢ ɞɚɧɧɵɯ ɫ ɢɫɩɨɥɶ-

ɡɨɜɚɧɢɟɦ ɹɡɵɤɚ SQL.

ɉɨɞɤɥɸɱɟɧɢɟ ɤ ɛɚɡɟ ɞɚɧɧɵɯ. ɉɪɢ ɨɬɤɪɵɬɢɢ ɪɟɞɚɤɬɨɪɚ ɫɜɹɡɟɣ ɫ

ȻȾ ɩɨ ɭɦɨɥɱɚɧɢɸ ɨɬɤɪɵɜɚɟɬɫɹ ɨɤɧɨ

ɉɨɞɤɥɸɱɟɧɢɟ (ɪɢɫ. 2.13). ȼ ɷɬɨɦ

ɨɤɧɟ ɤɨɧɮɢɝɭɪɢɪɭɟɬɫɹ ɩɨɞɤɥɸɱɟɧɢɟ ɤ ɛɚɡɟ ɞɚɧɧɵɯ. Ⱦɥɹ ɩɨɞɤɥɸɱɟɧɢɹ ɤ

ɛɚɡɟ ɞɚɧɧɵɯ ɦɨɠɧɨ ɢɫɩɨɥɶɡɨɜɚɬɶ ɞɜɚ ɫɩɨɫɨɛɚ:

ɡɚɪɟɝɢɫɬɪɢɪɨɜɚɬɶ ȻȾ ɜ ɤɚɱɟɫɬɜɟ ɢɫɬɨɱɧɢɤɚ ɞɚɧɧɵɯ ODBC ɢ

ɩɨɞɤɥɸɱɢɬɶɫɹ ɤ ɷɬɨɦɭ ɢɫɬɨɱɧɢɤɭ;

ɩɨɞɤɥɸɱɢɬɶɫɹ ɧɟɩɨɫɪɟɞɫɬɜɟɧɧɨ ɤ ɮɚɣɥɭ ȻȾ.

Ɋɢɫ. 2.13. ȼɢɞɟɨɝɪɚɦɦɚ ɨɤɧɚ ɦɚɫɬɟɪɚ ɩɨɞɤɥɸɱɟɧɢɹ ɤ ȻȾ

Ⱦɥɹ ɩɨɞɤɥɸɱɟɧɢɹ ɤ ɢɫɬɨɱɧɢɤɭ ɞɚɧɧɵɯ ODBC ɧɭɠɧɨ ɭɤɚɡɚɬɶ ɟɝɨ

ɩɚɪɚɦɟɬɪɵ ɜ ɨɤɧɟ

ɉɨɞɤɥɸɱɟɧɢɟ ɪɟɞɚɤɬɨɪɚ ɫɜɹɡɟɣ ɫ ȻȾ. ȼ ɩɨɥɟ ɂɧɬɟɪ-

ɮɟɣɫ

ɧɭɠɧɨ ɜɵɛɪɚɬɶ ɩɪɨɬɨɤɨɥ (ODBC3), ɜ ɩɨɥɟ DSN / ɋɬɪɨɤɚ ɩɨɞ-

ɤɥɸɱɟɧɢɹ

– ɢɦɹ ɡɚɪɟɝɢɫɬɪɢɪɨɜɚɧɧɨɝɨ ɢɫɬɨɱɧɢɤɚ ɞɚɧɧɵɯ. ȼ ɩɨɥɟ ɉɚ-

ɪɨɥɶ

ɧɭɠɧɨ ɜɜɟɫɬɢ ɩɚɪɨɥɶ, ɡɚɞɚɧɧɵɣ ɞɥɹ ȻȾ. ɉɨɥɹ ɉɨɥɶɡɨɜɚɬɟɥɶ, ɏɨɫɬ

ɢ ɉɨɪɬ ɧɚɞɨ ɨɫɬɚɜɢɬɶ ɩɭɫɬɵɦɢ. ȿɫɥɢ ɩɨɞɤɥɸɱɟɧɢɟ ɤ ȻȾ ɜɵɩɨɥɧɟɧɨ ɤɨɪ-

ɪɟɤɬɧɨ, ɜ ɨɤɧɟ

ɋɬɪɭɤɬɭɪɚ ɪɟɞɚɤɬɨɪɚ ɫɜɹɡɟɣ ɫ ȻȾ ɨɬɨɛɪɚɠɚɟɬɫɹ ɫɬɪɭɤɬɭ-

ɪɚ ɛɚɡɵ ɞɚɧɧɵɯ. ȼ ɫɬɨɥɛɰɟ

Ɍɢɩ ɷɬɨɝɨ ɨɤɧɚ ɫɨɞɟɪɠɢɬɫɹ ɢɧɮɨɪɦɚɰɢɹ ɨ

ɬɢɩɟ ɞɚɧɧɵɯ ɩɨɥɟɣ ɬɚɛɥɢɰ ȻȾ. ȼ ɫɬɨɥɛɰɟ

Ɉɛɹɡ. ɩɨɥɟ ɭɤɚɡɵɜɚɟɬɫɹ, ɹɜ-

ɥɹɸɬɫɹ ɥɢ ɩɨɥɹ ɫɬɨɥɛɰɨɜ ȻȾ ɨɛɹɡɚɬɟɥɶɧɵɦɢ ɞɥɹ ɡɚɩɨɥɧɟɧɢɹ (

ɧɟɬ – ɦɨ-

ɝɭɬ ɩɪɢɧɢɦɚɬɶ ɡɧɚɱɟɧɢɟ

NULL, ɬ. ɟ. ɛɵɬɶ ɩɭɫɬɵɦɢ, ɞɚ – ɩɨɥɹ ɨɛɹɡɚ-

ɬɟɥɶɧɵ ɞɥɹ ɡɚɩɨɥɧɟɧɢɹ). ȼ ɫɬɨɥɛɰɟ

ɋɨɪɬɢɪɨɜɤɚ ɭɤɚɡɵɜɚɟɬɫɹ ɩɨɪɹɞɨɤ

ɫɨɪɬɢɪɨɜɤɢ ɞɚɧɧɵɯ (

asc – ɩɨ ɜɨɡɪɚɫɬɚɧɢɸ, desc – ɩɨ ɭɛɵɜɚɧɢɸ).

ɋɨɡɞɚɧɢɟ SQL-ɡɚɩɪɨɫɨɜ. Ɂɚɩɪɨɫɵ SQL ɦɨɝɭɬ ɛɵɬɶ ɫɨɡɞɚɧɵ ɜɪɭɱ-

ɧɭɸ ɜ ɨɤɧɟ

Ɂɚɩɪɨɫɵ ɢɥɢ ɫ ɩɨɦɨɳɶɸ ɦɚɫɬɟɪɚ (ɪɢɫ. 2.14) (ɞɥɹ ɟɝɨ ɡɚɩɭɫɤɚ

ɧɭɠɧɨ ɧɚɠɚɬɶ ɤɧɨɩɤɭ

Ɇɚɫɬɟɪ). Ɂɚɩɪɨɫ, ɩɨɫɬɪɨɟɧɧɵɣ ɫ ɩɨɦɨɳɶɸ ɦɚɫɬɟ-

ɪɚ, ɦɨɠɟɬ ɛɵɬɶ ɜ ɞɚɥɶɧɟɣɲɟɦ ɨɬɪɟɞɚɤɬɢɪɨɜɚɧ ɜ ɨɤɧɟ

Ɂɚɩɪɨɫɵ:

Ɋɢɫ. 2.14. ȼɢɞɟɨɝɪɚɦɦɚ ɨɤɧɚ ɦɚɫɬɟɪɚ ɫɨɡɞɚɧɢɹ SQL-ɡɚɩɪɨɫɨɜ ɜ TRACE MODE.

Ⱦɚɧɧɨɟ ɨɤɧɨ ɫɧɚɛɠɟɧɨ ɬɢɩɨɜɵɦɢ ɢɧɫɬɪɭɦɟɧɬɚɦɢ ɫɨɡɞɚɧɢɹ/ɭɞɚɥɟɧɢɹ ɡɚɩɪɨ-

ɫɨɜ ɢ ɪɚɛɨɬɵ ɫ ɛɭɮɟɪɨɦ ɨɛɦɟɧɚ

Ⱦɥɹ ɤɚɠɞɨɝɨ ɡɚɩɪɨɫɚ, ɫɨɡɞɚɧɧɨɝɨ ɜɪɭɱɧɭɸ ɢɥɢ ɫ ɩɨɦɨɳɶɸ ɦɚɫɬɟ-

ɪɚ, ɜ ɨɤɧɟ ɚɜɬɨɦɚɬɢɱɟɫɤɢ ɫɨɡɞɚɟɬɫɹ ɜɤɥɚɞɤɚ, ɧɚ ɤɨɬɨɪɨɣ ɡɚɩɪɨɫ ɦɨɠɟɬ

ɛɵɬɶ ɨɬɪɟɞɚɤɬɢɪɨɜɚɧ. Ʉɚɠɞɨɦɭ ɡɚɩɪɨɫɭ ɚɜɬɨɦɚɬɢɱɟɫɤɢ ɩɪɢɫɜɚɢɜɚɟɬɫɹ

ɧɨɦɟɪ (ɧɚɱɢɧɚɹ ɫ 1). ɗɬɨɬ ɧɨɦɟɪ, ɨɬɨɛɪɚɠɚɟɦɵɣ ɜ ɡɚɝɨɥɨɜɤɟ ɜɤɥɚɞɤɢ,

ɹɜɥɹɟɬɫɹ ɢɞɟɧɬɢɮɢɤɚɬɨɪɨɦ ɡɚɩɪɨɫɚ ɢ ɢɫɩɨɥɶɡɭɟɬɫɹ ɜɩɨɫɥɟɞɫɬɜɢɢ ɞɥɹ

ɜɵɩɨɥɧɟɧɢɹ ɡɚɩɪɨɫɚ ɜ ɪɟɚɥɶɧɨɦ ɜɪɟɦɟɧɢ.

ȼɵɩɨɥɧɟɧɢɟ SQL-ɡɚɩɪɨɫɨɜ ɜ ɪɟɚɥɶɧɨɦ ɜɪɟɦɟɧɢ. Ⱦɥɹ ɜɵɩɨɥɧɟ-

ɧɢɹ SQL-ɡɚɩɪɨɫɨɜ ɤ ɩɨɞɤɥɸɱɟɧɧɨɣ ȻȾ ɜ ɪɟɚɥɶɧɨɦ ɜɪɟɦɟɧɢ ɜ ɭɡɥɟ ɞɨɥɠɟɧ

ɛɵɬɶ ɫɨɡɞɚɧ ɤɚɧɚɥ ɤɥɚɫɫɚ CALL ɫ ɬɢɩɨɦ ɜɵɡɨɜɚ

SQL-ɡɚɩɪɨɫ, ɧɚɫɬɪɨɟɧ-

ɧɵɣ ɧɚ ɜɵɡɨɜ ɲɚɛɥɨɧɚ ɫɜɹɡɢ ɫ ȻȾ. ɉɪɢ ɞɚɧɧɨɦ ɬɢɩɟ ɜɵɡɨɜɚ ɚɬɪɢɛɭɬ

Ƚɥɭ-

ɛɢɧɚ ɜɵɛɨɪɤɢ

ɤɚɧɚɥɚ CALL ɧɟ ɢɫɩɨɥɶɡɭɟɬɫɹ, ɬɢɩ ɤɚɧɚɥɚ ɧɟ ɢɦɟɟɬ.

ɋ ɩɨɦɨɳɶɸ ɚɬɪɢɛɭɬɚ

ɉɚɪɚɦɟɬɪ ɤɚɧɚɥɚ CALL ɦɨɠɧɨ ɡɚɞɚɬɶ ɧɨɦɟɪ ɜɨɡ-

ɜɪɚɳɚɟɦɨɣ ɫɬɪɨɤɢ ɢɡ ɜɵɛɨɪɤɢ, ɩɨɥɭɱɟɧɧɨɣ ɢɡ ɬɚɛɥɢɰɵ ȻȾ ɜ ɪɟɡɭɥɶɬɚɬɟ

ɡɚɩɪɨɫɚ. ȿɫɥɢ

ɉɚɪɚɦɟɬɪ=0 (ɡɧɚɱɟɧɢɟ ɩɨ ɭɦɨɥɱɚɧɢɸ), ɜɨɡɜɪɚɳɚɟɬɫɹ ɩɨ-

ɫɥɟɞɧɹɹ ɫɬɪɨɤɚ. Ɂɧɚɱɟɧɢɟ ɤɚɧɚɥɚ CALL ɡɚɞɚɟɬ

ɧɨɦɟɪ ɜɵɩɨɥɧɹɟɦɨɝɨ ɡɚ-

ɩɪɨɫɚ. ɉɨɫɥɟ ɨɬɪɚɛɨɬɤɢ ɡɧɚɱɟɧɢɟ ɤɚɧɚɥɚ ɚɜɬɨɦɚɬɢɱɟɫɤɢ ɫɛɪɚɫɵɜɚɟɬɫɹ ɜ 0.

2.7.3. ʽ̥̖̦̍ ̥̖̙̱̔ ̨̛̛̛̪̬̣̙̖̦̥́ ̨̪ ̨̨̡̨̪̬̯̣̱ DDE

ɋɭɬɶ DDE ɞɨɫɬɚɬɨɱɧɨ ɩɪɨɫɬɚ – ɨɩɪɟɞɟɥɟɧɵ ɧɟɫɤɨɥɶɤɨ ɫɬɚɧɞɚɪɬɧɵɯ

ɬɢɩɨɜ ɫɨɨɛɳɟɧɢɣ, ɩɪɢ ɩɨɦɨɳɢ ɤɨɬɨɪɵɯ ɦɨɠɧɨ ɩɟɪɟɞɚɜɚɬɶ ɞɟɫɤɪɢɩɬɨɪɵ

(ɨɩɢɫɚɬɟɥɢ) ɨɛɴɟɤɬɨɜ ɝɥɨɛɚɥɶɧɨɣ ɩɚɦɹɬɢ, ɫɨɞɟɪɠɚɳɢɯ ɧɟɨɛɯɨɞɢɦɵɟ ɞɚɧ-

ɧɵɟ. Ⱦɥɹ ɚɞɪɟɫɚɰɢɢ ɨɛɴɟɤɬɨɜ ɜ ɩɚɦɹɬɢ ɢɫɩɨɥɶɡɭɸɬɫɹ:

ɋɟɪɜɢɫ ɨɛɵɱɧɨ ɷɬɨ

ɢɦɹ ɩɪɢɥɨɠɟɧɢɹ DDE-ɫɟɪɜɟɪɚ; ɧɚɢɦɟɧɨɜɚɧɢɟ ɬɢɩɚ ɩɟɪɟɞɚɜɚɟɦɵɯ ɞɚɧɧɵɯ

(ɧɚɡɵɜɚɟɦɨɟ

ɬɟɦɨɣ) ɢ ɝɪɭɩɩɚ ɞɚɧɧɵɯ, ɩɟɪɟɞɚɜɚɟɦɵɯ ɩɨ ɨɞɧɨɦɭ ɫɨɨɛɳɟ-

ɧɢɸ (ɧɚɡɵɜɚɟɦɚɹ

ɷɥɟɦɟɧɬɨɦ ɞɚɧɧɵɯ).

ɗɥɟɦɟɧɬɚɦɢ ɞɚɧɧɵɯ, ɤɚɤ ɩɪɚɜɢɥɨ, ɹɜɥɹɸɬɫɹ ɬɟɤɫɬɨɜɵɟ ɫɬɪɨɤɢ, ɛɢ-

ɬɨɜɵɟ ɨɛɪɚɡɵ, ɬɚɛɥɢɰɵ ɞɚɧɧɵɯ ɢ ɞɪ. ɉɟɪɟɞɚɜɚɬɶ ɜ ɫɨɨɛɳɟɧɢɹɯ ɬɚɤɢɟ

ɞɚɧɧɵɟ (ɦɚɫɫɢɜɵ) ɧɟɭɞɨɛɧɨ, ɩɨɷɬɨɦɭ ɜ DDE ɜɜɨɞɢɬɫɹ ɫɩɟɰɢɚɥɶɧɵɣ ɫɩɨ-

ɫɨɛ ɤɨɞɢɪɨɜɚɧɢɹ ɞɚɧɧɵɯ. Ⱦɥɹ ɷɬɨɝɨ ɢɫɩɨɥɶɡɭɟɬɫɹ ɭɧɢɜɟɪɫɚɥɶɧɵɣ ɨɛɴɟɤɬ

ɨɛɦɟɧɚ ɦɟɠɞɭ ɩɪɢɥɨɠɟɧɢɹɦɢ – ɚɬɨɦ (ɭɧɢɤɚɥɶɧɵɣ ɢɞɟɧɬɢɮɢɤɚɬɨɪ ɞɥɹ

ɫɬɪɨɤɢ ɫɢɦɜɨɥɨɜ ɢɥɢ ɭɤɚɡɚɬɟɥɶ ɧɚ ɞɪɭɝɢɟ ɞɚɧɧɵɟ). Windows ɩɨɞɞɟɪɠɢ-

ɜɚɟɬ

ɜ ɩɚɦɹɬɢ ɬɚɛɥɢɰɭ ɚɬɨɦɨɜ, ɤɨɬɨɪɚɹ ɫɬɚɜɢɬ ɜ ɫɨɨɬɜɟɬɫɬɜɢɟ ɦɚɫɫɢɜɭ

ɞɚɧɧɵɯ ɰɟɥɨɱɢɫɥɟɧɧɨɟ ɡɧɚɱɟɧɢɟ (ɚɞɪɟɫ ɜ ɬɚɛɥɢɰɟ). ɉɪɢɥɨɠɟɧɢɹ ɦɨɝɭɬ

ɞɨɛɚɜɥɹɬɶ ɢɥɢ ɭɞɚɥɹɬɶ ɫɬɪɨɤɢ ɢɡ ɷɬɨɣ ɬɚɛɥɢɰɵ, ɚ ɬɚɤɠɟ ɢɡɜɥɟɤɚɬɶ ɫɬɪɨ-

ɤɢ ɩɨ ɢɞɟɧɬɢɮɢɰɢɪɭɸɳɟɦɭ ɧɨɦɟɪɭ. ɗɬɚ ɬɚɛɥɢɰɚ ɹɜɥɹɟɬɫɹ ɨɫɧɨɜɧɨɣ

DDE ɦɟɯɚɧɢɡɦɚ, ɬ. ɟ. ɦɟɠɞɭ ɩɪɢɥɨɠɟɧɢɹɦɢ ɩɟɪɟɫɵɥɚɸɬɫɹ ɚɞɪɟɫɚ ɞɚɧ-

ɧɵɯ (ɚɬɨɦɵ), ɚ ɫɚɦɢ ɞɚɧɧɵɟ ɧɚɯɨɞɹɬɫɹ

ɜ ɬɚɛɥɢɰɟ (ɪɚɡɞɟɥɹɟɦɨɣ ɩɚɦɹɬɢ).

Ɇɨɧɢɬɨɪɵ TRACE MODE ɩɨɞɞɟɪɠɢɜɚɸɬ ɨɛɦɟɧ ɩɨ DDE/NetDDE

ɦɟɠɞɭ ɫɨɛɨɣ ɢ ɫ ɩɪɢɥɨɠɟɧɢɹɦɢ WINDOWS, ɜɵɫɬɭɩɚɹ ɨɞɧɨɜɪɟɦɟɧɧɨ ɜ

ɤɚɱɟɫɬɜɟ ɫɟɪɜɟɪɚ ɢ ɤɥɢɟɧɬɚ. Ʉɥɢɟɧɬ ɢɧɢɰɢɢɪɭɟɬ ɨɛɦɟɧ ɫ ɫɟɪɜɟɪɨɦ ɢ ɡɚ-

ɞɚɟɬ ɨɞɢɧ ɢɡ ɫɥɟɞɭɸɳɢɯ ɪɟɠɢɦɨɜ ɨɛɦɟɧɚ:

POKE – ɢɡɦɟɧɟɧɢɟ ɡɧɚɱɟɧɢɹ ɭɤɚɡɚɧɧɨɝɨ ɩɚɪɚɦɟɬɪɚ ɧɚ ɫɟɪɜɟɪɟ;

REQUEST – ɡɚɩɪɨɫ ɡɧɚɱɟɧɢɹ ɭɤɚɡɚɧɧɨɝɨ ɩɚɪɚɦɟɬɪɚ ɨɬ ɫɟɪɜɟɪɚ

(ɨɛɵɱɧɵɣ DDE-ɤɚɧɚɥ);

ADVISE – ɪɟɠɢɦ, ɩɪɢ ɤɨɬɨɪɨɦ ɫɟɪɜɟɪ ɩɨɫɵɥɚɟɬ ɤɥɢɟɧɬɭ ɡɧɚɱɟɧɢɟ

ɭɤɚɡɚɧɧɨɝɨ ɩɚɪɚɦɟɬɪɚ ɩɪɢ ɟɝɨ ɢɡɦɟɧɟɧɢɢ («ɝɨɪɹɱɢɣ» DDE-ɤɚɧɚɥ).

ɉɜɧɠɨ «Ɋɫɣɦɩɡɠɨɣɠ – ɇɋȽ ɥɛɥ DDE-ɬɠɫɝɠɫ»

ɉɪɢ ɨɛɦɟɧɟ ɫ ɥɨɤɚɥɶɧɵɦ ɆɊȼ ɢɡ ɩɪɢɥɨɠɟɧɢɹ-DDE-ɤɥɢɟɧɬɚ,

ɜɨɡɦɨɠɧɨ:

ɱɬɟɧɢɟ ɚɬɪɢɛɭɬɚ (0, R) ɤɚɧɚɥɨɜ (ɜ ɪɟɠɢɦɟ REQUEST ɢɥɢ

ADVISE);

ɱɬɟɧɢɟ (REQUEST) ɢ ɡɚɩɢɫɶ (POKE) ɥɸɛɵɯ ɞɪɭɝɢɯ ɚɬɪɢɛɭɬɨɜ

ɤɚɧɚɥɨɜ.

ȿɫɥɢ ɤɥɢɟɧɬɨɦ DDE ɹɜɥɹɟɬɫɹ Excel, ɬɨ DDE-ɨɛɦɟɧ ɫ ɆɊȼ ɦɨɠɟɬ

ɛɵɬɶ ɫɤɨɧɮɢɝɭɪɢɪɨɜɚɧ ɫ ɩɨɦɨɳɶɸ ɮɨɪɦɭɥ Excel ɢɥɢ ɦɚɤɪɨɫɨɜ VBA

Ɏɨɪɦɭɥɚ Excel ɦɨɠɟɬ ɛɵɬɶ ɢɫɩɨɥɶɡɨɜɚɧɚ ɬɨɥɶɤɨ ɞɥɹ ɡɚɩɪɨɫɚ ɡɧɚɱɟɧɢɹ

(ɜ ɪɟɠɢɦɟ ADVISE ɢɥɢ REQUEST) – ɜ ɷɬɨɦ ɫɥɭɱɚɟ ɨɧɚ ɢɦɟɟɬ ɫɥɟɞɭɸ-

ɳɢɣ ɮɨɪɦɚɬ:

=<server>|<topic>!<item>, ɝɞɟ

server – ɢɦɹ ɫɟɪɜɟɪɚ ɜ ɮɨɪɦɚɬɟ RTM<k>, ɝɞɟ k – ɢɧɞɢɜɢɞɭɚɥɶɧɵɣ

ɧɨɦɟɪ ɭɡɥɚ;

topic – ɬɟɦɚ ɡɚɩɪɨɫɚ (ɫɦ. ɩɪɢɦɟɪɵ ɧɢɠɟ);

item – ɢɦɹ ɤɚɧɚɥɚ ɢɥɢ ɭɬɨɱɧɟɧɧɨɟ ɢɦɹ ɚɬɪɢɛɭɬɚ.

ɍɬɨɱɧɟɧɧɨɟ ɢɦɹ ɚɬɪɢɛɭɬɚ ɢɦɟɟɬ ɫɥɟɞɭɸɳɢɣ ɮɨɪɦɚɬ:

<ɢɦɹ ɤɚɧɚ-

ɥɚ>.<ɧɨɦɟɪ ɚɬɪɢɛɭɬɚ>

ɉɪɢɦɟɪ: «Ɂɚɩɪɨɫ ɡɧɚɱɟɧɢɹ ɚɬɪɢɛɭɬɚ R». Ⱦɥɹ ɡɚɩɪɨɫɚ ɪɟɚɥɶɧɨɝɨ

ɡɧɚɱɟɧɢɹ ɤɚɧɚɥɚ

pila ɜ ɪɟɠɢɦɟ ADVISE ɜ ɹɱɟɣɤɭ ɬɚɛɥɢɰɵ Excel ɧɭɠɧɨ

ɡɚɩɢɫɚɬɶ ɫɥɟɞɭɸɳɭɸ ɮɨɪɦɭɥɭ:

=RTM2|GET!pila

ȼ ɷɬɨɦ ɪɟɠɢɦɟ ɡɧɚɱɟɧɢɟ ɜ ɹɱɟɣɤɟ ɨɛɧɨɜɥɹɟɬɫɹ ɚɜɬɨɦɚɬɢɱɟɫɤɢ.

ȼ ɪɟɠɢɦɟ ADVISE ɦɨɧɢɬɨɪ ɩɨɫɵɥɚɟɬ ɤɥɢɟɧɬɭ ɡɧɚɱɟɧɢɟ ɤɚɧɚɥɚ ɩɪɢ ɤɚ-

ɠɞɨɦ ɟɝɨ ɩɟɪɟɫɱɟɬɟ.

Ⱦɥɹ ɡɚɩɪɨɫɚ ɪɟɚɥɶɧɨɝɨ ɡɧɚɱɟɧɢɹ ɤɚɧɚɥɚ

pila ɜ ɪɟɠɢɦɟ REQUEST ɜ

ɹɱɟɣɤɭ ɬɚɛɥɢɰɵ Excel ɧɭɠɧɨ ɡɚɩɢɫɚɬɶ ɨɞɧɭ ɢɡ ɫɥɟɞɭɸɳɢɯ ɮɨɪɦɭɥ:

=RTM2|PUT!pila

=RTM2|PUT!pila.0

ȼɨ ɜɬɨɪɨɣ ɮɨɪɦɭɥɟ ɬɟɦɚ ɡɚɩɪɨɫɚ ɦɨɠɟɬ ɛɵɬɶ ɩɪɨɢɡɜɨɥɶɧɨɣ.

ȼ ɷɬɨɦ ɪɟɠɢɦɟ ɡɧɚɱɟɧɢɟ ɤɚɧɚɥɚ ɡɚɩɪɚɲɢɜɚɟɬɫɹ ɢ ɡɚɩɢɫɵɜɚɟɬɫɹ ɜ ɹɱɟɣɤɭ

ɨɞɧɨɤɪɚɬɧɨ ɩɪɢ ɢɫɩɨɥɧɟɧɢɢ ɮɨɪɦɭɥɵ.

ɉɜɧɠɨ «ɇɋȽ ɥɛɥ DDE-ɥɦɣɠɨɭ – Ɋɫɣɦɩɡɠɨɣɠ»

ȿɫɥɢ ɦɨɧɢɬɨɪ ɜɵɫɬɭɩɚɟɬ ɜ ɪɨɥɢ DDE-ɤɥɢɟɧɬɚ, ɞɥɹ ɤɨɧɮɢɝɭɪɢɪɨ-

ɜɚɧɢɹ ɨɛɦɟɧɚ ɢɫɩɨɥɶɡɭɸɬɫɹ ɩɟɪɟɦɟɧɧɵɟ DDE. Ɋɚɫɫɦɨɬɪɢɦ ɨɛɦɟɧ ɧɚ

ɨɞɧɨɦ ɤɨɦɩɶɸɬɟɪɟ ɦɟɠɞɭ ɦɨɧɢɬɨɪɨɦ ɢ Excel, ɜɵɫɬɭɩɚɸɳɢɦ ɜ ɤɚɱɟɫɬɜɟ

DDE-ɫɟɪɜɟɪɚ. ȼɤɥɚɞɤɚ ɧɚɫɬɪɨɣɤɢ ɨɛɦɟɧɚ ɩɨ DDE ɩɪɟɞɫɬɚɜɥɟɧɚ ɧɚ

ɪɢɫ. 2.15.

Ɋɢɫ. 2.15. ȼɢɞɟɨɝɪɚɦɦɚ ɨɤɧɚ ɧɚɫɬɪɨɣɤɢ DDE ɨɛɦɟɧɚ ɦɟɠɞɭ ɆɊȼ ɢ Excel

ɉɪɢɦɟɪ: «Ɂɚɩɪɨɫ ɡɧɚɱɟɧɢɹ ɜ ɪɟɠɢɦɟ REQUEST». Ⱦɥɹ ɡɚɩɪɨɫɚ

ɜ ɪɟɠɢɦɟ REQUEST ɬɢɩ ɩɟɪɟɦɟɧɧɨɣ DDE ɞɨɥɠɟɧ ɛɵɬɶ INPUT. ɋɨɡ-

ɞɚɞɢɦ ɜ ɭɡɥɟ ɤɚɧɚɥ

ch2 ɢ ɫɜɹɠɟɦ ɟɝɨ ɫ ɩɟɪɟɦɟɧɧɨɣ DDE, ɩɚɪɚɦɟɬɪɵ

ɤɨɬɨɪɨɣ ɡɚɞɚɞɢɦ ɤɚɤ ɧɚ ɪɢɫ. 2.15. Ⱦɥɹ ɡɚɩɪɨɫɚ ɜ ɪɟɠɢɦɟ REQUEST

ɩɚɪɚɦɟɬɪɭ

Ɋɟɠɢɦ ɩɟɪɟɦɟɧɧɨɣ DDE ɦɨɠɧɨ ɬɚɤɠɟ ɡɚɞɚɬɶ ɡɧɚɱɟɧɢɟ

REQ/POKE[data] (ɪɢɫ. 2.16).

ɉɪɢɦɟɪ: «Ɂɚɩɪɨɫ ɡɧɚɱɟɧɢɹ ɜ ɪɟɠɢɦɟ ADVISE». ɋɨɡɞɚɞɢɦ ɜ ɭɡɥɟ

ɤɚɧɚɥ

ch1 ɢ ɫɜɹɠɟɦ ɟɝɨ ɫ ɩɟɪɟɦɟɧɧɨɣ DDE, ɩɚɪɚɦɟɬɪɵ ɤɨɬɨɪɨɣ ɡɚɞɚɞɢɦ

ɤɚɤ ɧɚ ɪɢɫ. 2.15. Ɉɬɤɪɨɟɦ Excel, ɫɨɡɞɚɞɢɦ ɧɨɜɭɸ ɤɧɢɝɭ ɢ ɡɚɩɭɫɬɢɦ ɭɡɟɥ

– ɭɫɬɚɧɨɜɢɬɫɹ ɫɜɹɡɶ ɦɨɧɢɬɨɪɚ ɫ ɤɧɢɝɨɣ Excel, ɚɤɬɢɜɧɨɣ ɜ ɞɚɧɧɵɣ ɦɨ-

ɦɟɧɬ, ɜ ɪɟɠɢɦɟ ADVISE. ȼ ɷɬɨɦ ɪɟɠɢɦɟ DDE-ɫɟɪɜɟɪ (Excel) ɛɭɞɟɬ ɩɨ-

ɫɵɥɚɬɶ DDE-ɤɥɢɟɧɬɭ (ɦɨɧɢɬɨɪɭ) ɡɧɚɱɟɧɢɟ (ɩɪɢ ɤɚɠɞɨɦ ɟɝɨ ɢɡɦɟɧɟɧɢɢ)

ɹɱɟɣɤɢ

G6 (Row=6, Column=7) ɥɢɫɬɚ Sheet1, ɢ ɷɬɨ ɡɧɚɱɟɧɢɟ ɛɭɞɟɬ ɡɚɩɢ-

ɫɚɧɨ ɜɨ ɜɯɨɞ ɤɚɧɚɥɚ

ch1.

Ɋɢɫ. 2.16. ȼɢɞɟɨɝɪɚɦɦɚ ɨɤɧɚ ɧɚɫɬɪɨɣɤɢ DDE ɨɛɦɟɧɚ ɦɟɠɞɭ ɆɊȼ

ɢ Excel (reɪɟɠɢɦ quest)