Table of Contents
SQL Style Examples
This section contains examples that demonstrate how to control Valentina database using SQL commands. Many examples in this section have a satellite - example in the section API Examples.
SQL Binding Example
Demonstrates how to use SQL query with binded parameters. You will see:
- how it works with SqlExecute() and SqlSelect().
- how to use SQL92 standard syntax with ‘?‘.
- how to use non-standard syntax “:n“.
- how to mix both syntaxes (not recommended although).
Demonstrates how to use field constraints.
Demonstrates how to create in Table different Field types using SQL command CREATE TABLE and how to drop a field in the table using ALTER TABLE DROP FIELD command.
Demonstrates how to work with Picture field via VCursor.
Demonstrates how to Import/Export into the text file using VCursor ImportText() and ExportText() methods.
Demonstrates how to use index by words feature of Valentina with SQL way. It shows different kinds of searches for string: Start with, Contains, End With…
Demonstrates how to create Table Method (a.k.a Calcualted Field) using SQL.
Demonstrates how to work with record locks when you use VCursor class.
Demonstrates how to
- add records using INSERT command.
- delete records using DELETE WHERE command.
- update records using UPDATE WHERE command.
Demonstrates different features of ALTER TABLE command:
- Add field
- Drop field
- Rename field
- Change field length
- Change field type
- Rename Table.
Demonstrates how to create and drop table using SQL commands CREATE TABLE and DROP TABLE.
Demonstrates the using of ZIP compression for TEXT (BLOB) field.