SQL query question

[shino54]

Hello,

I would like a query to know if an entry exists

Thank you in advance.

$sQuery = "SELECT Alger FROM garage where auto='BL1879'"

$result1 = $result.Fields("Alger").Value

if $result1="" Then
       MsgBox(0, "ERROR", "BAD not exist")     
Else
       MsgBox(0, "Success!", "OK exist")
EndIf
Exit

 

[Jos]

I've split your question of into the support forum, where this belongs:

So what exactly is your question?
There are a couple of UDF's available to do SQL queries with Autoit3, so look for those.

Jos

Edited August 15, 2020 by Jos

[mLipok]

21 minutes ago, shino54 said:

I would like a query to know if an entry exists

Try to use my ADO.au3 UDF 

 

if you try attached examples and still will have questions ask here:

 

[Zedna]

Look here for example showing working with ADO directly without any includes: