LISA SQL

Welcome to the LISA SQL documentation site.

Working with cards

You can also arrange data columns into a data card like the example below.

Contact details

Phone

800-555-1212

Mobile

800-442-4244

chris@mymail.net

OPEN c FOR
    SELECT * FROM customer
    WHERE custid = @custid
BEGIN
    PRINT 'Contact details' AS DATA-CARD
    BEGIN
        PRINT c.phone LABEL 'Phone'
        PRINT c.mobile LABEL 'Mobile'
        PRINT c.email LABEL 'Email'
    END
ENDCopy

-goes-here>