Database package - A2019/AA360 Automation anywhere -Select, insert, update query,variable - Database

A2019 Database package overview in Automation anywhere A2019
Connect with Database in Automation anywhere A2019
#Automation anywhere Enterprise A2019
Automation anywhere enterprise A2019 Database packages
Automation anywhere Enterprise A2019 Database
Automation anywhere AA360 database
Select query in Automation anywhere A2019
insert query in Automation anywhere A360
update query in Automation anywhere A2019
delete query in Automation anywhere A2019
Loop function in Automation anywhere A2019
Variable in Automation anywhere A2019
Automation anywhere Enterprise AA360 Database

Playlist - Automation anywhere A360/ A2019 all packages & actions

'SQL Select Statement
SELECT * from Test WHERE Final_Status = 'Closed'
'SQL select & Count Statement
SELECT COUNT(Year1)from Test WHERE Final_Status = 'Closed’
'SQL INSERT INTO statement
INSERT INTO Test (Year1,Final_Value) VALUES ('2015',‘Test value');
'SQL Update Statement
UPDATE Test SET Final_Status = 'Test' WHERE Year1 = '2017'

Automation anywhere A2019 overview
How to use Automation anywhere A2019
Create first bot in Automation anywhere A2019 web page / web browser
Microsoft access database connection in Automation anywhere A2019
Automation anywhere Enterprise A2019 Database
Using Connect action for database - Automation Anywhere
Configure database type and server - Automation Anywhere
automation anywhere A2019 database connection string

[meghanavincent]

Nicely explained..Please try to upload more videos of other packages.
Could you also confirm if we can use 'Export to data table' option instead of Read form? Where all the rows would be stored in Variable table
Then to use loop and display values through message box.
Please confirm.
Thankyou

[amarhappy]

Hi While connection, Its asking to select Database File path in Required extensions: “.accdb”, “.mdb”
Only .accdb and .mdb files are allowed.
What about Excel .xslx, xls

I want to connect Excel as DB

[deepchauhan]

Plz tell the syntax if I have to UPDATE a numeric value - A2019
Eg : - I am working on database of students marks where i want to update "total" column value with adding column value of "maths+science+ english+ social science" subjects

[jrkkfso]

while using insert query it gives me error. So can you show how to write insert query in automation anywhere?

[yad]

i tried the same method but bot only shows last me