Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 19.6 ('Memorable Passwords')
Instant purchase and download via GumRoad!

COLUMN

SQL

A Brief Discussion on SQL

Issue: 19.6 (November/December 2021)
Author: Vince Du Beau
Author Bio: Vince is an experienced Filemaker developer. He is exploring Xojo as an alternative to Filemaker.
Article Description: No description available.
Article Length (in bytes): 4,601
Starting Page Number: 75
Article Number: 19610
Related Link(s): None

Excerpt of article text...

I'm sure as Xojo users you are familiar with using SQL.

Structured Query Language (SQL—pronounced "Sequel") is the definitive language used to manage relational databases. SQL includes commands for database queries, Data Definition, Data control, and data manipulation.

Data Definition

The data defintion Language (DDL) part of SQL uses the create statement to define your Tables and Columns (Rows). This sample create statement is from my previously mentioned invoice program:

BEGIN TRANSACTION;

...End of Excerpt. Please purchase the magazine to read the full article.