Hi again, I have one more question. I am trying to clear a table in the underlying database before adding new rows. I am using tableadapters on my form (.net). The documentation says that I can add a query to the tableadapters and simply run that query in the code to perform a delete. It will be carried out on the database as well as the datasource. The problem is that I cannot seem to write the correct sql for this delete query.
I am trying to write: DELETE * FROM my_pages
But when I try to execute this query I receive an error: Unable to parse query text.
So I changed the sql to: DELETE page_id FROM my_pages
Now I get: Missing FROM clause.
Unable to parse query text.
Can anyone tell me what I am doing wrong?
Thanks so much for any help.