HexLibraryHexLibrary
</> HexCodeSign inSign up
PythonJavaScriptTypeScriptCC++JavaPHPGoRustRubyBashSQLLuaPerlCOBOLPascalDelphiFortranDartSwiftC#JuliaGroovyRElixirHaskellKotlinScalaClassic ASPClipperMS-DOS
LESSONS
Introduction to ClipperVariablesStringsConditions (IF / DO CASE)Loops (FOR / DO WHILE)DBF Database
REFERENCE
📖 Overview
🖥️ Output
📦 Variables
✍️ Text & Number
🔁 Condition & Loop
🗃️ Functions & Database
FUNCTION / RETURNUSE / APPEND / REPLACE
Clipper›REFERENCE›Functions & Database
🗃️

Functions & Database

FUNCTION and xBase database commands.

CommandDescription
FUNCTION / RETURNSubroutine that returns a value.
USE / APPEND / REPLACExBase database operations (the essence of Clipper).

FUNCTION / RETURN

Try it yourself →

Subroutine that returns a value.

Syntax

FUNCTION name(p) ... RETURN value

Description

Defined with FUNCTION, returns a value with RETURN. PROCEDURE does not return a value.

Example

? Square(5)

FUNCTION Square(x)
RETURN x * x

Expected output

25

When to use?

Preventing code repetition.

USE / APPEND / REPLACE

Try it yourself →

xBase database operations (the essence of Clipper).

Syntax

USE table
APPEND BLANK
REPLACE field WITH value

Description

Clipper was designed to work with .DBF database files. USE opens the table, APPEND BLANK adds a row, REPLACE updates a field, SKIP moves to the next record.

Example

USE customer
APPEND BLANK
REPLACE name WITH "Alex"
? name

Expected output

Alex

When to use?

Database management — Clipper's primary purpose.

HexLibraryHexLibrary

Learn programming more clearly. Every command is explained line by line with colors, reinforced with runnable exercises, test your code instantly — all in one place, free.

Learn

  • Home
  • Languages & Lessons
  • HexCode

Company

  • About
  • Contact

Legal

  • Privacy Policy
  • Terms of Use

Other Projects

  • HexToolz
  • Free Service Manuals
© 2026 HexLibrary · The clearest way to learn code