Thunderstone Support Forums

Hi,
I'm trying ot debug some sql by running it on the command line.

The query i'm testing involves a LIKE, and uses @1 and w/line, and i'm getting the standard errors:

115 'delimiters' not allowed in query
115 'intersects' not allowed in query

I know how to fix this in vortex (with the apicp options) but how do you do it on the command line?

Use "tsql" instead of "texis" for your command line query. It will allow those by default. And you can use multiple queries, either interactively or on the command line, so you can perform "set" statements as needed before your select.

ah.
I don't have tsql....I guess thats because we only have a license to use webinator?

Write and run a tiny vortex script. A minimal script would be:

<script language=vortex>
<db=/path/to/your/database>
<a name=main>
<sql row "select field1,field2 from ...">
$field1, $field2
</sql>
</a>
</script>

Run it with
texis myscript/main.txt