Skip to main content
Hello, can i check a MSQL database and get a boolean variable? or something like this like 1 or 0 / true / false thank u for u help

Hi @Nils Pottbäcker​ ,

 

Can you give me bit more details?


I have a bot that gets a PDF and an order number via email and the PDF has to be attached to an order in a program using the order number.

 

Therefore I would like to query my MSQL database from this program whether this order already exists.

 

Can you understand that?

 


Yes you can Query the result from the DB and using Loop command you can check for the required value and convert to the required format.


Hi @Nils Pottbäcker​ ,

 

You can use the Database Action Package to connect with MS SQL and using a Where clause, check whether the item exists or not, i.e., check if the datatable queried back is empty or not:

 

imageimageSELECT * FROM TableName]

WHERE WPURCHASE_ORDER] = $nPurchaseOrder.Number:toString$imageimageIs this what you were looking for?

 

Kind Regards,

Ashwin A.K

 


Reply