Question:
How do I perform INSERTS, UPDATES andDELETES on existing tables? I have looked up the help andin books but nothing seems to tell me exactly how to do it.
Answer:
Those statements are fairly easy to do…you just have to have the correct syntax, which is all documented in the Professional Features Books and in the online help files.Here is an example INSERT, DELETE, and UPDATE:
INSERT INTO SUPPLIERS (field1, field2, field3) VALUES (value1, value2, value)Put that statement into an ExecuteSQL command, and it will run. field1 – field3 are the fields you are filling, and value1 – value3 are the corresponding values.
UPDATE SUPPLIERS SET field1 = value1, field2 = value2 WHERE id = 10DELETE FROM SUPPLIERS WHERE id = 10
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
