At 10:00 PM 2/11/2008, Ken wrote:

According to my interpetation of the documentation, this would be the syntax:

RUN SELECT USING 'A B' SELECT VARCHAR_CMD from table where name='name' -- where A and B are constants.

This throws a syntax error. Any insight would be appreciated.


Ken,

A very simple example:

Table Name: StoredCommands

No. Column Name        Attributes
--- ------------------ ------------------------------------------------------
  1 CommandID          Type   : INTEGER
                                Comment: Command ID
  2 CommandFile        Type   : LONG VARCHAR
                                Comment: Actual Command File

Typical Syntax:

RUN SELECT CommandFile FROM StoredCommands WHERE CommandID = nnnn

Hope that helps!

Very Best R:egards,

Razzak.


Reply via email to