Executing SQL Statements

Executing SQL Statements

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.

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

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular