### SQL LIKE Operator Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Demonstrates how to search for a specified pattern in a column using the LIKE operator and wildcards. This example finds customer names starting with 'A'. It's useful for flexible text searching.
```sql
SELECT * FROM Customers
WHERE CustomerName LIKE 'A%';
```
--------------------------------
### SQL Wildcard _ Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of the '_' wildcard character with the SQL LIKE operator. It matches any single character.
```sql
SELECT * FROM customers
WHERE contactName LIKE '_r%'; -- Second character is 'r'
SELECT * FROM customers
WHERE country LIKE 'N__'; -- Starts with N and is three letters long
```
--------------------------------
### SQL Insert Statement Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of an SQL INSERT statement used to add new records to a table. It shows how to specify column names and their corresponding values.
```sql
INSERT INTO "Table" ("Field1", "Field2") VALUES ("Value1", "Value2")
```
--------------------------------
### SQL Select Statement Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Demonstrates a basic SQL SELECT statement to retrieve data from a table. This example illustrates selecting specific columns and applying a filter condition.
```sql
SELECT * FROM "Table" WHERE "Field" = "Value"
```
--------------------------------
### SQL INSERT Statement Example
Source: https://help.claris.com/en/sql-reference/content/field-names
Demonstrates how to insert new records into a database table using SQL. This example shows a basic INSERT statement, which is fundamental for data entry.
```sql
INSERT INTO Employees (EmployeeID, FirstName, LastName, HireDate)
VALUES (101, 'John', 'Doe', '2023-10-26');
```
--------------------------------
### SQL Date Functions (CURTIME)
Source: https://help.claris.com/en/sql-reference/content/relational-operators
Provides an example of the CURTIME() function to get the current time.
```sql
SELECT CURTIME();
```
--------------------------------
### SQL BETWEEN Operator Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Shows how to select values within a given range using the BETWEEN operator. This example retrieves products with prices between 10 and 50. It simplifies range-based filtering.
```sql
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 50;
```
--------------------------------
### SQL GRANT Permission Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Shows how to grant specific privileges to database users. This example grants SELECT and INSERT privileges on the 'Customers' table to a user named 'user1'. Permissions management is vital for database security.
```sql
GRANT SELECT, INSERT ON Customers TO user1;
```
--------------------------------
### Claris SQL Date Formatting Example
Source: https://help.claris.com/en/sql-reference/content/constants
Example of formatting dates in Claris SQL using the `Format` function. This allows you to display date values in a specific string format. The format specifiers determine the output representation of the date.
```sql
SELECT Format(order_date, 'YYYY-MM-DD') AS formatted_date
FROM orders;
```
--------------------------------
### SQL CREATE INDEX Statement Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Illustrates how to create an index on a table to speed up data retrieval operations. This example creates a unique index on the 'Email' column of the 'Customers' table. Indexes are crucial for database performance tuning.
```sql
CREATE UNIQUE INDEX idx_email ON Customers (Email);
```
--------------------------------
### SQL CREATE TABLE Statement Example
Source: https://help.claris.com/en/sql-reference/content/field-names
Demonstrates the syntax for creating a new table in a database. This statement defines the structure and columns of a new table.
```sql
CREATE TABLE Departments (
DepartmentID INT PRIMARY KEY,
DepartmentName VARCHAR(255) NOT NULL
);
```
--------------------------------
### SQL CREATE TABLE Statement Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Demonstrates the syntax for creating a new table in a SQL database. This snippet defines the table name and the columns with their respective data types and constraints. It's fundamental for database schema design.
```sql
CREATE TABLE Products (
ProductID int PRIMARY KEY,
ProductName varchar(255),
Price decimal(10, 2)
);
```
--------------------------------
### Claris SQL BETWEEN Operator Example
Source: https://help.claris.com/en/sql-reference/content/group-by-clause
Illustrates the use of the BETWEEN operator to select values within a given range. The range includes the start and end values.
```Claris SQL
SELECT * FROM Products WHERE price BETWEEN 50 AND 100;
```
--------------------------------
### Claris SQL Substring Function Example
Source: https://help.claris.com/en/sql-reference/content/constants
This snippet shows how to extract a portion of a string using the Substring function in Claris SQL. It requires the string, starting position, and length of the substring to extract. Useful for parsing or manipulating text data.
```sql
SELECT Substring(product_code, 1, 3) AS product_prefix
FROM products;
```
--------------------------------
### Claris SQL CREATE TABLE Statement Example
Source: https://help.claris.com/en/sql-reference/content/group-by-clause
Demonstrates the creation of a new table in a Claris SQL database. It specifies column names, data types, and constraints.
```Claris SQL
CREATE TABLE Projects (
projectID INT PRIMARY KEY,
projectName VARCHAR(255),
startDate DATE
);
```
--------------------------------
### SQL DDL - CREATE DATABASE
Source: https://help.claris.com/en/sql-reference/content/offset-and-fetch-first-clauses
Demonstrates the Data Definition Language (DDL) command CREATE DATABASE for creating a new database in the Claris environment.
```sql
CREATE DATABASE database_name;
```
--------------------------------
### SQL HAVING Clause Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of the SQL HAVING clause, used to filter groups based on a specified condition. It is typically used with GROUP BY.
```sql
SELECT COUNT(column_name), column_name
FROM table_name
WHERE condition
GROUP BY column_name
HAVING COUNT(column_name) > value;
```
--------------------------------
### SQL DELETE Statement Example
Source: https://help.claris.com/en/sql-reference/content/field-names
Provides an example of how to remove records from a database table using the DELETE statement. Use with caution as it permanently removes data.
```sql
DELETE FROM Employees
WHERE EmployeeID = 101;
```
--------------------------------
### CSS Responsive Layouts and Navigation
Source: https://help.claris.com/en/sql-reference/content/constants
Styles for multi-column layouts, ensuring responsiveness across different screen sizes. Includes rules for navigation items, hover effects, and margin adjustments for last-child elements.
```css
ation li:last-child,.ei-multicolumn .column-flex:last-child .ei-expand-local-nav,.ei-multicolumn .column:last-child .ei-expand-local-nav{margin-right:0}.ei-expand-local-nav{display:block;text-align:right;color:#208a3d;margin-bottom:24px;cursor:pointer}.column.tertiary-nav-item.selected:hover p,.ei-expand-local-nav:hover{color:#2da14a}@media only screen and (min-width:736px){.ei-multicolumn .column-flex .expandable-item{margin-top:-18px}}@media only screen and (max-width:735px){.ei-multicolumn{flex-direction:column}.ei-multicolumn .column-flex .column-content{padding-bottom:0}.column-flex:last-child .expandable-item,.column:last-child .expandable-item{margin-left:0;margin-right:0}.column .expandable-item,.column-flex .expandable-item{margin-left:0;margin-right:0}.ei-multicolumn .column .ei-expand-local-nav{margin-right:0}.ei-multicolumn .column:last-child h2,.ei-multicolumn .column:last-child h3,.ei-multicolumn .column:last-child h4{margin-left:0}}
```
--------------------------------
### SQL Subquery Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of a SQL subquery, which is a query nested inside another SQL query. Subqueries can be used in SELECT, FROM, WHERE, and HAVING clauses.
```sql
SELECT "Field" FROM "Table" WHERE "ID" IN (SELECT "ID" FROM "AnotherTable" WHERE "Status" = 'Active')
```
--------------------------------
### SQL Delete Statement Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Presents an SQL DELETE statement to remove records from a table. The example demonstrates how to specify criteria for the records to be deleted.
```sql
DELETE FROM "Table" WHERE "Field" = "Value"
```
--------------------------------
### SQL IS NOT NULL Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of the SQL IS NOT NULL operator, used to select rows where a column does not contain NULL values. Ensures data completeness.
```sql
SELECT * FROM customers
WHERE address IS NOT NULL;
```
--------------------------------
### SQL ORDER BY Clause Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Demonstrates the SQL ORDER BY clause for sorting the result set in ascending or descending order. Crucial for presenting data logically.
```sql
SELECT * FROM table_name ORDER BY column_name ASC|DESC;
```
--------------------------------
### SQL UPDATE Statement Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of the SQL UPDATE statement, used to modify existing records within a table. Essential for data maintenance.
```sql
UPDATE customers
SET address = 'Valley 345'
WHERE customerName = 'Alfreds Futterkiste';
```
--------------------------------
### Claris SQL: LIKE Operator
Source: https://help.claris.com/en/sql-reference/content/constants
Illustrates the LIKE operator for pattern matching within string data. This example shows how to search for values that match a specific pattern using wildcards ('%' and '_'). Useful for flexible text searches.
```sql
SELECT column1, column2
FROM your_table_name
WHERE column1 LIKE 'pattern%';
```
--------------------------------
### Claris SQL Subquery Example
Source: https://help.claris.com/en/sql-reference/content/group-by-clause
Provides an example of a subquery (nested query) used within another SQL query. Subqueries can be used in SELECT, FROM, WHERE, and HAVING clauses.
```Claris SQL
SELECT customerName FROM Customers WHERE customerID IN (SELECT customerID FROM Orders WHERE amount > 1000);
```
--------------------------------
### FileMaker SQL Syntax for SELECT Statements
Source: https://help.claris.com/en/sql-reference/content/constants
Demonstrates the basic structure of a SELECT statement in FileMaker SQL, including selecting columns, specifying tables, and applying WHERE clauses. This is fundamental for retrieving data.
```sql
SELECT column1, column2
FROM tablename
WHERE condition;
```
--------------------------------
### SQL CREATE TABLE Statement in Claris
Source: https://help.claris.com/en/sql-reference/content/sql-clauses
Demonstrates the syntax for creating a new table in Claris SQL. This involves defining the table name and its columns with their respective data types. Constraints and indexes are not detailed in this basic example. Ensure data types are appropriate for the intended data.
```SQL
CREATE TABLE TableName (
column1 datatype,
column2 datatype,
...
);
```
--------------------------------
### SQL CREATE TABLE Statement
Source: https://help.claris.com/en/sql-reference/content/create-index-statement
Provides an example of creating a new table with specified columns and their data types. It demonstrates defining column constraints like NOT NULL.
```sql
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
...
);
```
--------------------------------
### Claris SQL CREATE TABLE Statement
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of the CREATE TABLE statement used to define and create new tables within a Claris database. It includes specifying column names and their data types.
```sql
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
...
);
```
--------------------------------
### SQL WHERE Clause Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Demonstrates the use of the WHERE clause to filter records based on a condition. This example selects customers from a specific city. It's crucial for targeted data retrieval.
```sql
SELECT * FROM Customers
WHERE City = 'London';
```
--------------------------------
### SQL UPDATE Statement Example
Source: https://help.claris.com/en/sql-reference/content/update-statement
An example of an SQL UPDATE statement modifying the salary and exempt status of an employee in the 'emp' table based on their employee ID.
```sql
UPDATE emp SET salary=32000, exempt=1 WHERE emp_id = 'E10001'
```
--------------------------------
### Script Loading (HTML)
Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects
This HTML snippet demonstrates how various JavaScript files are loaded asynchronously using the 'defer' attribute. It includes polyfills, jQuery, cookie-related scripts, and site-specific JavaScript. The 'defer' attribute ensures scripts are executed after the HTML document has been parsed, improving page load performance.
```html
```
--------------------------------
### SQL INSERT Statement Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Demonstrates how to insert data into a table using SQL. This snippet typically involves specifying the table name and the values to be inserted. It's a fundamental operation for populating databases.
```sql
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Alfreds Futterkiste', 'Maria Anders', 'Obere Str. 57', 'Berlin', '12209', 'Germany');
```
--------------------------------
### Claris SQL UPDATE Statement Example
Source: https://help.claris.com/en/sql-reference/content/group-by-clause
Provides an example of updating existing records in a Claris SQL table. This is useful for modifying data based on specific criteria.
```Claris SQL
UPDATE Orders SET status = "Shipped" WHERE orderID = 12345;
```
--------------------------------
### Claris SQL: CREATE TABLE Statement
Source: https://help.claris.com/en/sql-reference/content/constants
Demonstrates the SQL CREATE TABLE statement for defining a new table structure. This snippet outlines specifying the table name and its columns with their respective data types. This is fundamental for database schema design.
```sql
CREATE TABLE your_table_name (
column1 datatype,
column2 datatype,
column3 datatype
);
```
--------------------------------
### SQL Wildcard % Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Illustrates the use of the '%' wildcard character with the SQL LIKE operator. It matches any sequence of characters.
```sql
SELECT * FROM customers
WHERE customerName LIKE 'A%'; -- Starts with A
SELECT * FROM customers
WHERE customerName LIKE '%a'; -- Ends with a
SELECT * FROM customers
WHERE customerName LIKE '%or%'; -- Contains 'or'
```
--------------------------------
### Claris SQL LIKE Operator Example
Source: https://help.claris.com/en/sql-reference/content/group-by-clause
Demonstrates the use of the LIKE operator for pattern matching in string columns. Wildcards '%' and '_' are commonly used.
```Claris SQL
SELECT customerName FROM Customers WHERE customerName LIKE 'A%';
SELECT customerName FROM Customers WHERE customerName LIKE '_a%';
```
--------------------------------
### SQL Aggregate Function COUNT Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Provides an example of the SQL COUNT aggregate function to determine the number of rows that match a specified criterion. Essential for data summarization.
```sql
SELECT COUNT(column_name)
FROM table_name;
```
--------------------------------
### SQL Aggregate Function AVG Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Shows an example of the SQL AVG aggregate function to compute the average value of a numeric column. Commonly used in statistical analysis.
```sql
SELECT AVG(column_name)
FROM table_name;
```
--------------------------------
### Inserting Data into a Table using Claris SQL
Source: https://help.claris.com/en/sql-reference/content/logical-operators
Example of an SQL INSERT statement to add a new record to a 'Products' table. The statement specifies values for 'ProductID', 'ProductName', and 'Price'.
```sql
INSERT INTO Products (ProductID, ProductName, Price) VALUES (101, 'Gadget', 19.99);
```
--------------------------------
### SQL HAVING Clause Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Illustrates how to filter groups based on a specified condition using the HAVING clause. This example shows cities with more than 5 customers. HAVING is used after GROUP BY to filter aggregated results.
```sql
SELECT City, COUNT(*) AS NumberOfCustomers
FROM Customers
GROUP BY City
HAVING COUNT(*) > 5;
```
--------------------------------
### JavaScript: Newsletter Pre-Signup Functionality
Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects
This JavaScript file, referenced by the 'defer' attribute, is responsible for pre-newsletter signup functionalities. The exact functions and their purpose are not detailed in the provided HTML, but it's loaded asynchronously to avoid blocking page rendering.
```javascript
defer type="text/javascript" src="/site/includes/email-signup/js/pre-newsletter.js?v=8"
```
--------------------------------
### Claris SQL INSERT Statement Example
Source: https://help.claris.com/en/sql-reference/content/constants
Example of an INSERT statement in Claris SQL used to add new records to a table. This code specifies the table, the columns to populate, and the values for those columns. Adjust table and column names, as well as the data types of the values, to match your database.
```sql
INSERT INTO your_table_name (column1, column2, column3)
VALUES ('value1', 'value2', 123);
```
--------------------------------
### Claris SQL ALTER TABLE Statement Example
Source: https://help.claris.com/en/sql-reference/content/group-by-clause
Illustrates modifying an existing table structure using the ALTER TABLE statement. This example adds a new column to a table.
```Claris SQL
ALTER TABLE Customers
ADD COLUMN email VARCHAR(255);
```
--------------------------------
### SQL Update Statement Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Illustrates an SQL UPDATE statement for modifying existing records in a table. This example shows how to set new values for specific columns based on a condition.
```sql
UPDATE "Table" SET "Field" = "NewValue" WHERE "Field" = "OldValue"
```
--------------------------------
### SQL IN Operator Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Illustrates how to specify multiple values in a WHERE clause using the IN operator. This example selects customers from specific countries. It's a concise way to check for multiple possible values.
```sql
SELECT * FROM Customers
WHERE Country IN ('Germany', 'France', 'UK');
```
--------------------------------
### SQL UPDATE Statement with Subquery Example
Source: https://help.claris.com/en/sql-reference/content/update-statement
An example of an SQL UPDATE statement that uses a subquery to set the salary of a specific employee to the average salary of all employees in the 'emp' table.
```sql
UPDATE emp SET salary = (SELECT avg(salary) from emp) WHERE emp_id = 'E10001'
```
--------------------------------
### SQL SELECT Statement Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Illustrates how to retrieve data from a database table using the SELECT statement. This snippet shows basic selection of columns and specifying the table to query from. It's essential for data retrieval.
```sql
SELECT CustomerName, City FROM Customers;
```
--------------------------------
### SQL WHERE Clause - Example
Source: https://help.claris.com/en/sql-reference/content/offset-and-fetch-first-clauses
Demonstrates the usage of the WHERE clause in SQL to filter records based on specific conditions. It shows how to select data that meets a particular criterion.
```sql
SELECT column1, column2, ...
FROM table_name
WHERE condition;
```
--------------------------------
### SQL Example: Filtering Groups with HAVING
Source: https://help.claris.com/en/sql-reference/content/having-clause
This example demonstrates how to use the HAVING clause to filter grouped records. It selects department IDs and the sum of salaries, displaying only those departments where the total salary exceeds $200,000.
```sql
SELECT dept_id, SUM (salary) FROM emp GROUP BY dept_id HAVING SUM (salary) > 200000
```
--------------------------------
### SQL Aggregate Function Examples
Source: https://help.claris.com/en/sql-reference/content/aggregate-functions
Provides examples of using SUM, AVG, COUNT, MAX, and MIN aggregate functions in SQL SELECT statements within Claris FileMaker.
```sql
SELECT SUM (Sales_Data.Amount) AS agg FROM Sales_Data
```
```sql
SELECT AVG (Sales_Data.Amount) AS agg FROM Sales_Data
```
```sql
SELECT COUNT (Sales_Data.Amount) AS agg FROM Sales_Data
```
```sql
SELECT MAX (Sales_Data.Amount) AS agg FROM Sales_Data WHERE Sales_Data.Amount < 3000
```
```sql
SELECT MIN (Sales_Data.Amount) AS agg FROM Sales_Data WHERE Sales_Data.Amount > 3000
```
--------------------------------
### SQL Aggregate Function MIN Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Demonstrates the SQL MIN aggregate function for finding the smallest value in a column. Useful for identifying minimums in datasets.
```sql
SELECT MIN(column_name)
FROM table_name;
```
--------------------------------
### SQL String Function - Concatenation Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Shows an example of SQL string concatenation to combine multiple text fields into a single string. This is useful for formatting output or creating composite keys.
```sql
SELECT "FirstName" || ' ' || "LastName" AS "FullName" FROM "Table"
```
--------------------------------
### SQL Join Operation Example
Source: https://help.claris.com/en/sql-reference/content/where-clause
Demonstrates an SQL INNER JOIN operation to combine rows from two or more tables based on a related column between them. This example links two tables on a common field.
```sql
SELECT T1."Field1", T2."Field2" FROM "Table1" T1 INNER JOIN "Table2" T2 ON T1."CommonField" = T2."CommonField"
```
--------------------------------
### Modernizr Feature Detection and Configuration
Source: https://help.claris.com/en/sql-reference/content/index
This snippet initializes Modernizr, a JavaScript library used for detecting HTML5 and CSS3 features available in the user's browser. It includes tests for WebP image formats and CSS 'position: sticky', and manages asynchronous test loading.
```javascript
/*! Modernizr 3.6.0 (Custom Build) | MIT
* https://modernizr.com/download/?-csspositionsticky-webp
*/
window.Modernizr = function(a, b, c) {
function z(a, b) {
var c = b.substr(0, b.indexOf(" "));
return a.style[c] !== c.toLowerCase()
}
function y(a, b, d, e) {
var f;
try {
f = b.createElement(a)
} catch (g) {
f = b.createEvent("Element");
f.initEvent(a, !1, !1)
}
return "function" != typeof f.style.setProperty ? b.body || b.documentElement : (f.style.cssText = d, f)
}
function x(a, b) {
return ("" + a).indexOf(b) \
}
function w(a, b) {
return a.replace(/[^ ]+ /, "") \
}
function v(a, b, c, d) {
var e, f, g, h, i = b.load;
b.load = function() {
// A crude async
event.preventDefault ? event.preventDefault() : event.returnValue = !1,
"undefined" != typeof b.readyState ? b.readyState \
: (b.style.display = "none", b.style.cssText = "", b.parentNode.removeChild(b))
}
d
```
--------------------------------
### SQL REVOKE Permission Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Demonstrates how to revoke previously granted privileges from database users. This example revokes the INSERT privilege on the 'Customers' table from 'user1'. Revoking permissions is essential for maintaining security.
```sql
REVOKE INSERT ON Customers FROM user1;
```
--------------------------------
### SQL CREATE TABLE Statement - Defining Tables
Source: https://help.claris.com/en/sql-reference/content/offset-and-fetch-first-clauses
Demonstrates the SQL CREATE TABLE statement used to define a new table in the database. It includes specifying column names, data types, and constraints.
```sql
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);
```
--------------------------------
### Claris SQL: Rename Table Example
Source: https://help.claris.com/en/sql-reference/content/alter-table-statement
Example demonstrating how to rename an entire table using the ALTER TABLE statement in Claris SQL. This changes the identifier of the table within the database.
```sql
ALTER TABLE Salespeople RENAME TO Salesperson
```
--------------------------------
### SQL Date Function Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Illustrates the use of a common date function to retrieve the current date. This example selects all orders placed today. Date functions are essential for time-based data filtering and reporting.
```sql
SELECT * FROM Orders
WHERE OrderDate = CURDATE();
```
--------------------------------
### SQL Query Example in Claris SQL
Source: https://help.claris.com/en/sql-reference/content/constants
This snippet demonstrates a basic SQL query to select data from a table in Claris SQL. It shows how to retrieve specific columns and filter rows based on certain criteria. Ensure the table and column names are correctly specified for your database schema.
```sql
SELECT column1, column2
FROM your_table_name
WHERE column1 = 'some_value';
```
--------------------------------
### SQL IS NULL Operator Example
Source: https://help.claris.com/en/sql-reference/content/character-operators
Shows how to check if a column contains NULL values using the IS NULL operator. This example finds customers without a specified region. It's important for handling missing data.
```sql
SELECT * FROM Customers
WHERE Region IS NULL;
```