LabVIEW自带函数实现SQL Server操作（下）

桃扇骨 2022-06-15 06:43 162阅读 0赞

1. DBTool Insert Data.vi

![计算机生成了可选文字:N1CreateD日t日ba沈API.IVlib:OBTOO15Ins.rtD日t日．Vitable?（日data........COnnedionFeferenCet日blecolumns(noerror)cluster?（日回砂，connectionreferenceouterrorOUt.errorInf】atten][N1CreateD_t_ba_API.IVlib_OBTOO15Ins.rtD_t_Vitable_data........COnnedionFeferenCet_blecolumns_noerror_cluster_connectionreferenceouterrorOUt.errorInf_atten]

简介：添加一个新的行到之前连接的数据库的表内。其中data为变体数据类型，变体内存放的是簇，簇内可以存放多种数据类型。

示例：向AlarmData里面添加时间和错误代码

![计算机生成了可选文字:园connectioninformationloriver二sQLservecA'”『m。‘,’巡糕鬓瓷器A!armDateErrCodeServer二．:Database二Userlnfo:u\{d二sa;pwd二Aa123789in(noerror)嘿蘸儒eFrorOUt硬二」｝][connectioninformationloriver_sQLservecA_m_A_armDateErrCodeServer_Database_Userlnfo_u_d_sa_pwd_Aa123789in_noerror_eFrorOUt]

2. DBTool Select Data.vi

![计算机生成了可选文字:NlDatabaseAPI.IVlib:DBT0015SelectDat口．Vi仁OnneCtionreferenCetablecolumns(noerror)connectionreferenceoutdataeFFOrOUt.errorIn][NlDatabaseAPI.IVlib_DBT0015SelectDat_Vi_OnneCtionreferenCetablecolumns_noerror_connectionreferenceoutdataeFFOrOUt.errorIn]

根据条件查询数据库表中数据，输出类型为变体数据，需要通过Database Variant To Data.vi解析出所需数据。

示例：查询AlarmData里面日期为2017/5/3的数据

![计算机生成了可选文字:conditionw卜ereAlarmDate二’2017/5/3'dataIn阮汉皿data下‘习OUtconnectioninformationIgriV一‘日L,s,rv竺二，;l、理er＝·‘口ata"a,e'"Ser'nTo;l"'“了终．。一。。IPwa＝从口1乙。，o,tableName骊示而丽而0，团。。励errorin(noerror)匡昼一一一一．＝诬片。。圃l互」蕊EL气虑DB坦刃铆卜。。励errorOUt巨三团｝][conditionw_ereAlarmDate_2017_5_3_dataIn_data_OUtconnectioninformationIgriV_L_s_rv_l_er_ata_a_e_Ser_nTo_l_IPwa_1_o_tableName_0_errorin_noerror_l_EL_DB_errorOUt]

3. DBTool Update Data.vi

![计算机生成了可选文字:Nl\_Databa“一Pl.lvlib:DBToolsUpdateData.viConnectionconditiondat日referenCetableco\}umns(noerror)cluster?（日connectionreferenceouterrOFOUt.eFFOFIn们atten][Nl_Databa_Pl.lvlib_DBToolsUpdateData.viConnectionconditiondat_referenCetableco_umns_noerror_cluster_connectionreferenceouterrOFOUt.eFFOFIn_atten]

根据条件更新数据库表中数据。需要指定更新列的名称、更新条件和新数据，而列的名称需要通过DB Tools List Columns.vi函数获得。

示例：将ErrCode里面为AL0001的错误代码改为AL0002

![计算机生成了可选文字:ConditionIw卜ere%s二’%s,connectioninformation｝妙e呼黔，吧二，,l》望er='‘口日t日”''e=",er'n'0;l"'“丁5是‘.,,，。。lpwo＝从日i'0,o,TableNamelAlarmDataerrorin(noerror)应垂―＝还片。。圆目L‘了DF：屋闯铆卜D。虽eFFOFOUt··～一巫司][ConditionIw_ere_s_s_connectioninformation_e_l_er_t_e_er_n_0_l_5_._lpwo_i_0_o_TableNamelAlarmDataerrorin_noerror_L_DF_D_eFFOFOUt]

4. DBTool Delete Data.vi

![计算机生成了可选文字:NlOataba弓eAPI.IVlib:OBTOOISOel时eOata.Vi:OnnectionConditionrefeFen仁etab!e(noerror)connedionreferenceouterrorOUterrOFIn][NlOataba_eAPI.IVlib_OBTOOISOel_eOata.Vi_OnnectionConditionrefeFen_etab_e_noerror_connedionreferenceouterrorOUterrOFIn]

根据条件删除数据库表中数据。

示例：删除表中错误代码为AL0001的所有数据

![计算机生成了可选文字:connedioninformation｝妙e呼野，吧．…l。望er='‘口日t日”''e""ser,n'0;l"'“丁5愁，，一。。lpwo二只口i乙J,O,W卜ereErrCode='ALODDIAlarmDataerrorin(noerror)睡负―蕙团黯口篇eFFOFOUt应二」｝][connedioninformation_e_l_er_t_e_ser_n_0_l_5_lpwo_i_J_O_W_ereErrCode_ALODDIAlarmDataerrorin_noerror_eFFOFOUt]

[N1CreateD_t_ba_API.IVlib_OBTOO15Ins.rtD_t_Vitable_data........COnnedionFeferenCet_blecolumns_noerror_cluster_connectionreferenceouterrorOUt.errorInf_atten]: /images/20220615/2b69b58e26df4ce68489e781069469aa.png
[connectioninformationloriver_sQLservecA_m_A_armDateErrCodeServer_Database_Userlnfo_u_d_sa_pwd_Aa123789in_noerror_eFrorOUt]: /images/20220615/398652303ca145419418dc0db1cd5c5f.png
[NlDatabaseAPI.IVlib_DBT0015SelectDat_Vi_OnneCtionreferenCetablecolumns_noerror_connectionreferenceoutdataeFFOrOUt.errorIn]: /images/20220615/8ae5ea761f84425aa9cca41f6b237cc4.png
[conditionw_ereAlarmDate_2017_5_3_dataIn_data_OUtconnectioninformationIgriV_L_s_rv_l_er_ata_a_e_Ser_nTo_l_IPwa_1_o_tableName_0_errorin_noerror_l_EL_DB_errorOUt]: /images/20220615/1e4b0c255bfe4548930a7c42053f1649.png
[Nl_Databa_Pl.lvlib_DBToolsUpdateData.viConnectionconditiondat_referenCetableco_umns_noerror_cluster_connectionreferenceouterrOFOUt.eFFOFIn_atten]: /images/20220615/de912066906b45ae96b0425c6851d456.png
[ConditionIw_ere_s_s_connectioninformation_e_l_er_t_e_er_n_0_l_5_._lpwo_i_0_o_TableNamelAlarmDataerrorin_noerror_L_DF_D_eFFOFOUt]: /images/20220615/32706162f1634048bb728b43e82bc7fe.png
[NlOataba_eAPI.IVlib_OBTOOISOel_eOata.Vi_OnnectionConditionrefeFen_etab_e_noerror_connedionreferenceouterrorOUterrOFIn]: /images/20220615/83e7fcb7471b4fd4b7217897c32de718.png
[connedioninformation_e_l_er_t_e_ser_n_0_l_5_lpwo_i_J_O_W_ereErrCode_ALODDIAlarmDataerrorin_noerror_eFFOFOUt]: /images/20220615/8a3a17fabb31402aabf915a9906f9286.png