Advanced AmiScript 2: AMI SQL

This second tutorial in the series will start by creating and altering a table like the previous tutorial but this time using AMI SQL statements. We will then look at how to delete data, for example, a single row, rows that match a condition or all the rows in a table. While we didn't have any methods to update or modify a row in a Table object we can use the UPDATE statement to make changes to our data. This works for both Tables and Table objects. We will then look at how to insert data using the INSERT statement. At first we will look at a simple example, then incorporate AMI Script variables and finally demonstrate the INSERT statements for loop syntax. Finally, we will show that Tables and Table objects are, for the most part, interchangeable and that everything we have covered works on both.