scriptengine/tests/ParameterisedQueries.sql

/* Demonstrate Parameterised queries in scripts */

Alter Table COUNTRY
  add Image Blob;

Update COUNTRY Set Image = :MyImage Where COUNTRY = 'England';
Commit;

Revision:	37
Committed:	Mon Feb 15 14:44:25 2016 UTC (8 years, 2 months ago) by tony
Content type:	application/sql
File size:	163 byte(s)
Log Message:	Committing updates for Release R1-4-0
#	User	Rev	Content
1	tony	37	/* Demonstrate Parameterised queries in scripts */
2
3			Alter Table COUNTRY
4			add Image Blob;
5
6			Update COUNTRY Set Image = :MyImage Where COUNTRY = 'England';
7			Commit;
8