🚀 go-pugleaf

David McCullough wrote:
> I have been trying to use a memory variable in a select * statement with  a
> statement such as SELECT * FROM FEATURES  WHERE CODE = M->variable

Variables work only when using the embedded SQL feature of the language, 
i.e. typing SQL statements as straight dBASE statements:

  x = 'abc'
  select * from whatever where field = :x

To use a variable in the a Query object's SQL statement, you can 
formulate the SQL statement as the others suggest. You can also place the 
parameter in the sql statement, then fill in the resulting params array:

  q = new Query()
  q.sql = "select * from whatever where field = :x"
  q.params[ "x" ] = 'abc'
  q.active = true

-- 
//Ken@Borland
<Please follow-up to newsgroup; do not reply to email>