SQLTeX documentation - SQLTEX errors and warnings

SQLTeX documentation - SQLTEX errors and warnings

Inhoudsopgave
SQLTeX documentation
Installing SQLTeX
Write your SQLTEX file
Process your SQLTEX file
SQLTEX errors and warnings
Alle pagina's

SQLTEX errors and warnings

no input file specified

 

SQLTEX was called without any parameters.
Action: Specify at least one parameter at the commandline. This parameter should be the name of your input file.

File input filename does not exist

 

The input file does not exist.
Action: Make sure the first parameter points to the input file.

outputfile output filename already exists

 

The outputfile cannot be created because it already exists.
Action: Specify another output filename with command line option -e, -E or -o, or force an overwrite with option -f.

no database opened at line line nr

 

A query starts at line line nr, but at that point no database was opened yet.
Action: Add an \sqldb command prior to the first query statement.

insufficient parameters to substitute variable on line line nr

 

The query starting at line line nr uses a parameter in a WHERE- clause with $PARn, where n is a number bigger than the number of parameters passed to SQLTEX.
Action: Specify all required parameters at the command line.

trying to substitute with non existing on line line nr

 

The query starting at line line nr requires a variable $VARn in its WHERE- clause, where n points to a variable that has not (yet) been set.
Action: Change the number or set the variable prior to this statement.

trying to overwrite an existing variable on line line nr

 

At line line nr, a \sqlfield query tries to set a variable n using the option [setvar=n], but $VARn already exists at that point.
Action: Change the number.

no result set found on line line nr

 

The query starting at line line nr returned a NULL value. If the option -N was specified at the commandline, this is just a warning message. Otherwise, SQLTEX exits.
Action: None.

result set too big on line line nr

 

The query starting at line line nr, called with \sqlfield returned more than one field.
Action: Change your query or use \sqlrow instead.

unrecognized command on line line nr

 

At line line nr, a command was found that starts with ``\sql'', but this command was not recognized by SQLTEX.
Action: Check for typos. If the command is a user- defined command, it will conflict with default SQLTEX commands. Change the SQLTEX command prefix.

no sql statements found in input filename

 

SQLTEX did not find any valid SQLTEX commands.
Action: Check your input file.

 

Copyright and disclaimer

Copyright© 2001-2005 - Oscar van Eijk, Oveas Functionality Provider

This software is subject to the terms of the LaTeX Project Public License; see http://www.ctan.org/tex-archive/help/Catalogue/licenses.lppl.html.