6ES79548LF020AA0
6ES79548LF020AA0
6ES79548LF020AA0
6ES79548LF020AA0
6ES79548LF020AA0
在組態(tài)王6.5版本中數(shù)據(jù)采集頻率可設(shè)定為毫秒級，數(shù)據(jù)保存可按“定時記錄” 和“數(shù)據(jù)變化記錄” 兩種方式。其中“定時記錄”方式最快的數(shù)據(jù)保存頻率是1個/分；而“數(shù)據(jù)變化記錄”方式雖可實現(xiàn)數(shù)據(jù)毫秒級高速存儲和數(shù)據(jù)壓縮，但是，如果直接利用組態(tài)王所提供的歷史報表，通過ReportsetHistData()函數(shù)進行數(shù)據(jù)查詢時，其查詢數(shù)據(jù)的最小時間間隔只能為1秒鐘。當(dāng)實際要求以固定毫秒級時間間隔實現(xiàn)數(shù)據(jù)的按次存儲與按次查詢時，簡單、直接地使用組態(tài)王是無法實現(xiàn)的。
3.3.2問題的解決
ODBC是一種用來在相關(guān)或不相關(guān)的數(shù)據(jù)庫管理系統(tǒng)中存取數(shù)據(jù)的標(biāo)準(zhǔn)應(yīng)用程序設(shè)計接口(API),可以實現(xiàn)不同數(shù)據(jù)庫系統(tǒng)的互連訪問。ODBC是一種使用SQL的程序設(shè)計接口，因此，可以使用組態(tài)王的SQL訪問功能實現(xiàn)組態(tài)王和其他ODBC數(shù)據(jù)庫之間的數(shù)據(jù)傳輸。
組態(tài)王與其他外部數(shù)據(jù)庫（支持ODBC訪問接口）進行數(shù)據(jù)傳輸時，首先要在系統(tǒng)ODBC數(shù)據(jù)源中添加數(shù)據(jù)庫，然后通過組態(tài)王SQL訪問管理器和SQL函數(shù)實現(xiàn)各種操作。針對系統(tǒng)高頻記錄、按次存儲與按次查詢的要求，以本系統(tǒng)為例，給出以下具體的解決方案：
（1）建立ODBC數(shù)據(jù)庫
組態(tài)王和其他外部數(shù)據(jù)庫實現(xiàn)數(shù)據(jù)傳輸時必須在系統(tǒng)ODBC數(shù)據(jù)源中定義相應(yīng)數(shù)據(jù)庫。本系統(tǒng)將Microsoft Access數(shù)據(jù)庫作為組態(tài)王的外部數(shù)據(jù)庫,首先建立一個Access數(shù)據(jù)庫，然后在控制面板下的“ODBC數(shù)據(jù)源(32位)”選項內(nèi)創(chuàng)建新數(shù)據(jù)源，選擇“Mirosoft Access Driver”。
（2）建立表格模板與記錄體
SQL訪問管理器用來建立數(shù)據(jù)庫列和組態(tài)王變量之間的聯(lián)系。包括表格模板和記錄體兩部分功能。通過表格模板在數(shù)據(jù)庫表中建立表格；通過記錄體建立數(shù)據(jù)庫表格列和組態(tài)王之間的聯(lián)系，表格模板和記錄體都是在工程瀏覽器中建立的。
SIEMENS SIMODRIVE 6SN1123-1AB00-0BA1 6SN1118-1NH01-0AA0
QUALICOMM espresso CARD 30-VR209-P2 30-VR208-P2
New ECOFIT 2GDS25 133x190R double inlet Blower 133 fan
VIASYS Mainboard 52130A PCBA MAIN VELA Critical care
Trench CPR 04 Capacitor Protection Relay CPR04-00-110
New Allan Bradley AB 140U-J2X3 140U-J2 Circuit Breaker
Lot 3000 AA264-87LF SKYWORKS Chips Digital Attenuator
SCHRACK-SECONET BA-OI3 EG072846-C/01 InputOutput module
Leuze Contrast Scanner KRTG 20M/N-20-1320-S12 NEW
New Sunshine XENON Light Bulbs Controll Ballast 35W
ANRITSU Matching Pad T-PAD Z-164A DC-1GHZ NEW
ABB Turbocharger parts Cover ring DH1 nipple wp VTR201
Applied Biosystems GeneAmp 9700 Mainboard & Power AsIs
Autoliv seatbelt R200 retractor Assembly NEW 5115542FLB
Lot of 5000 screws TEXTRON Fastening System CSM-PH4251
Toshiba Power Adapter AD-121AJDT 100-120VAC to 12VDC 1A
Tektronix gigaBERT 1400 GENERATOR GB1400 Desktop Refurb
pilz PNOZ11 110VAC/24VDC 7S10 safety relay NEW in box
NEW in box LUCENT TFU 44WW7 1:5 BOARDS
MITSUBISHI 4G52 G54B Main Bearings 025 TAIHO KOGYO
MITSUBISHI 4G52 G54B Main Bearings Standard Size STD
MOELLER Z5-70/SK3 Z5 Overload Relay NEW
lot of 10 SQUARE D D3 2 Pole 8 pins Relay Sockets NEW
RIKEN KEIKI Gas meter Alarm System GX-111 GX-111EX
Lot 500 HARWIN M22-714 M22-7140842 DIL Vertical Socket
Lot 500 HARWIN M22-713 M22-7132042 DIL Vertical Socket
Lot 500 HARWIN M22-714 M22-7142042 DIL Vertical Socket
Lot 500 HARWIN M50-315 M50-3152042 SurfaceMount Sockets
Harmonic Drive Robot part HDC-3C-086-2A 1020592086K Set
20 Tapes 80K TDK SMD Capacitors C1608X5R1A105KT 1UF 10V
New Pierburg EGR VALVE 7.00069.00 06T293
Lot of 960pcs Jalco YKF45-3001 Socket D-SUB 6620R-Z002A
New NIDEC SANKYO SC3150 Robot Controller 200/230vAC
JAMES H. HEAL EB640PRJH light fastness tester Power
Lot of 4 Motorola MC68331CFC16 MCU 32BIT 16MHZ 132-PQFP
ASM SERVO DRIVER Type: APD20 AC DUAL SD 890 02-15783
TOYOPUC PC3JP TIC-6215 TOYODA Machine
TOYOPUC PC3JG-P TIC-6088 1.90 CPU Module TOYODA Machine
TOYOPUC FL/ET-T-V2 THU-5998 10M Base-t Ethernet TOYODA
Mitsubishi Extension Unit EP72EX-PA21-S1 PCI*2 ISA*1
Matsushita Power Supply ETU-5E200 120VAC-5VDC 20A 150W
NEW GROHE Bath Shower Mixer Concealed Body 33961 000
PowerDAQ PCI Multifunction Board PD2-MF-64-400/14H used
PowerDAQ PD2-AO-16/16 analog output board
GE LOGIQ e Basic Compounding CWD Software Certificate
PowerDAQ PD2-DIO-128I/MT DIO Board
New IRONPORT C300 Email Security Sever Hardware
NEW Trupoint Flexoconcepts Blades 35mm*2mm*30m 30°
Barco D320 RGBHV Analog Input R9850950 RefurbishedSpare
Fujikin FPR-UDDF-71-6.35-4-316LP-EPL AIR VALVE NEW
Plantronics 17593-70 AttiTube for Mirage StarSet Supra
used Panasonic VS-2536A W-CDMA /UMTS UE Simulator
Lot of 3000 1206SFF500FM/32-2 Tyco Raychem Chip Fuse 5A
SCHOTT SF57HHT 33.42*21.45*1.65mm GLASS
RICOH Z-folding Unit ZF-4000 for MP6000 MP7000 MP8000
RICOH PPC RT39 for MP6000 MP7000 MP8000 NEW
RICOH SR842 finisher stapler for MP6000 MP7000 MP8000
RICOH IEEE 1284 Interface Board Type A B679-17 New
RICOH File Format Converter TypeC B609-04 New
RICOH USB Host Interface Unit TypeA B825-17 New
RICOH Data Overwrite Security TypeC B735-17 New
RICOH Printer/Scanner Unit Type8000 D406-03 New
RICOH Cover Interposer Tray Type 3260
FUJI UG20 UG221H-LE4 HMI Touch Screen 5.7" Mono LCD
COSMOS Vibration Sensor SAF512R Vibro Monitor CVM-20A-V
Lot 25 Fairchild Optoelectronics QVE00112 with cable
Lot 80 CY7C1414SV18-250BZC CY7C1414
New GM Fuel PUMP 12626234 by BOSCH
Lot 211 pcs RENESAS M30622MWP-152FP M30622 IC
VICKERS Valve DG4V-3S-6C-M-U-H5-60 new spare
VICKERS Pressue Relief Valve DGMC2-3-AB-CW-BA-CW-41
VICKERS PILOT OP. CHECK Valve DGMPC-3-ABK-KBA-41
Lot 58 pcs NAiS JW1AFHN-DC5V Realys New Spare
EATON ROLL/YAW TRIM 441-40456-001 SAGEM 251524189-0102
Air Liquide DIVA ARM 4.20 MASTER Rosemount 3051 sensor
TAKIKAWA COUNTING EVENT PRINTER AD-50 NEW Surplus
MSC cPCI Computer Card 1.4GHZ 512MB 105495-50 NEW
Astron SS-30 SS-30D power supply 13.5vDC output NEW
Ingersoll Rand 150BMP-2451B CONTROL VALVE 24 VDC NEW
NERA F77 Transceiver Unit & Modem Unit Repaired Spare
Toshiba Machine VELCONIC VLPSV-070P3-AB Servo Drive
EXCEL 1032B Precision Signal Processor Card Used Spare
Alcab-Lucent LSC16G1X module CRTUAAMCAA New
AD-8118A JOURNAL PRINTER USED SPARE
New ADDA 12VDC Brushless Blower Fan AB5012MB-C03
Lot 33 TYCO1658629-1 SFP CAGE Connector 2X4 PRESS FIT
New Alcab RRA 3DB02147AA
New Alcab SERV 3DB02155AA
Alcab 3AL98029AA 63X2MB/S PROT.75OHM HM (4 TE) New
Alcab OC3C/STM1C IR I/O CARD SOLD AS IS Refurbished
New Alcab MD128W1 3DB02136AA
Alcab SWL-B LHR R2.0 FEE License Certificate
Lot of 10 lbs ALLFAST RIVET SOLID AF1049W1C6C6 Boeing
Alcab 3AL97690AAAB LC-ESC board
Vision Multiswitch V5-508 new
Fuji Electric DC-02121 DDC TR285698 Control Board NEW
Fuji Electric Pulse Amplifier TR284228 New
Fuji Electric Pulse Transmitter TR490533C TR284654A New
IP05 IP ENGINE ipanema xx-256-CF512-2-X-G4
GE Energy Power module 151X1225EK01PC03 230V TO 12V NEW
HoneyWell C7061F2001 Purple Peeper Flame Detector C7061
IRIS Model P522 P522AC Flame Monitor Signal Processor
Lot of 7 Nico 5006L Keypads NEW
ABB DI801 3BSE020508R1 S800 Digital Input Module new
HLOS CL-7000 Electrical Screwdriver & CLT-150 power NEW
ABB 3BSE018161R1 PM864AK01 S800 I/O CPU Processor new
lot 520 iKANOS Fusiv IKF68331-A1-PB1-C chips
ABB 3BSE018109R1 SB821 BATTERY EXTERNAL DIN RAIL NEW
ABB 3BSE040360R41 Compact Control Builder CD license
CG171A-T003-05 Reflector Film UX188 etching mould
HoneyWell C7012A 1202 Purple Peeper UV Flame Detector
