_MSSQL.au3 help

[marcus_tong]

hi,all.

I use  MSSQL.au3 to populate my MS SQL database

the _MSSQL_Con， _MSSQL_AddRecord and _MSSQL_GetRecord functions are all works well, but when I work with _MSSQL_DeleteRecord and _MSSQL_UpdateRecord to update and delete SQL table items I encountered a problem.

According to their syntax explain, I wrote the wrong Parameter of $Condition, for example of _MSSQL_UpdateRecord Syntax

_MSSQL_UpdateRecord($oConnectionObj, $sTable, $sColumn , $sValue, $condition = "")

_MSSQL_UpdateRecord($oConnectionObj, $sTable, $sColumn , $sValue, are easy to know, but $condition default is all, ie, update all column values, but I need to specify only one row.

I tried to key in _MSSQL_UpdateRecord($oConnectionObj, "TestTable", "TestColume" , "100" , 1) 

or 

_MSSQL_UpdateRecord($oConnectionObj, "TestTable", "TestColume" , "100" , "1") 

or

_MSSQL_UpdateRecord($oConnectionObj, "TestTable", "TestColume" , "100" , "id=1")

are all fail.

what is the $Condition Syntax ?

thank you 

[mLipok]

You should really start using ADO.au3 udf.

Edited March 14, 2023 by mLipok

[marcus_tong]

Sorry for the inconvenience, I downloaded the _MSSQL.au3 form this page.

Hope someone can help.

Thanks @mLipok, I am now starting on ADo.au3 UDF. hope can solve my problem.

 

[marcus_tong]

mssql.au3

$condition is "where date='2023-02-16'" I tried to success.

Thank you.