SQL-Builder
With the SQL Builder SQL statements can be built for the table selected in the database:
 
 
SELECT-statement SELECT customer.custno, customer.company, customer.addr1
FROM customer
WHERE customer.custno = :custno
GROUP BY customer.custno, customer.company, customer.addr1
ORDER BY customer.custno
 
INSERT-statement INSERT INTO customer (custno, company, addr1)
VALUES (:custno, :company, :addr1)
 
UPDATE-statement UPDATE customer
SET customer.company = :company, customer.addr1 = :addr1
WHERE customer.custno = :custno
 
DELETE-statement DELETE FROM customer
WHERE customer.custno = :custno

  • Tablenames: The name of the table is given in front of the field name
  • Parameter: Parameter prefix for parametered query
  • Uppercase: Tables and field names are completely in upper case
  • Execute: The SQL statement is executed directly
 
<< Back