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
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:
SELECT * FROM [TableName]
WHERE [PURCHASE_ORDER] = $nPurchaseOrder.Number:toString$Is this what you were looking for?
Kind Regards,
Ashwin A.K
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.