Subject variable or const in sql script
Author A6-CMO Philippe Makowski
Hello

I have a bath file wich invoque a sql script to import data into the database

In this script I have Delete instruction :
DELETE FROM TABLE WHERE ANNEE=2002

(ANNEE is a integer)
How can I use a variable instead of the hard coded value ?

the batch file is something like :
and the variable is the second parameter sent to the batch file (%2)

@ECHO OFF
ECHO Chargement
rem transformation du fichier
ctt "%1" -annee:"%2" -rep:c:\temp
ECHO.
rem chargement dans la base
"C:\Program Files\Firebird_1_5\bin\isql.exe" -i TC_charge.sql
ECHO.
rem suppression des fichiers
del C:\temp\*.dat
ECHO.
ECHO Fin

--
Philippe Makowski

Firebird serveur SQL open-source en fran├žais
http://firebird-fr.eu.org