LiveCode Forums.

put "DELETE FROM Table1 WHERE firstName='Mary' AND lastName='Smith' " into tySQL
revExecuteSQL gConnectionID,tSQL

if the result is a not a number then
answer "Error : "&the result
else
answer "ok"
end if

on MouseUp
global gConnectionID
if gConnectionID is not a number then
answer error "Please connect to the database first"
exit to top
end if

-- since you don't need a where clause, its really straight forward. No Where means all rows removed.
put "delete from table1" into tSQL 

revExecuteSQL gConnectionID, tSQL

if the result is a number then
answer info "All rows deleted"
else
answer error "There was a problem clearing table1" & cr & the result
end if
end mouseUp

rayck23 wrote:I apologize for the confusion....I was in a rush when I wrote my question. Here we go....

I have a database called "slpproject" that has a table called "table1". I am able to create entries in that table but am having issues with creating a line of code that will allow me to delete all the entries that have been made in that table. I followed the directions in the example for creating an entry to a database here,

creating.PNG

but I am having problems figuring out where to enter the "Delete From" portion of the code into the above example,

delete.PNG

I am sorry again if this confuses anyone....I am very new to this and am reading all I can in order to learn Livecode....but I feel like a 1st grader trying to learn physics!