🚀 go-pugleaf

On Fri, 20 Mar 1998 10:38:20 -0600, "David McCullough"
<72223.2320@compuserve.com> 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
>Nothing I do seems to work. I hope a Visual Dbase ver. 7 for Dummies is
>coming soon. I sure feel like one.

The local SQL parser cannot use memory variables from the application
front-end, whether the application is written in Visual dBASE, Delphi, or
other. When you build the string that will be the SQL statement, keep the
SQL-specific content as string literals and use Visual dBASE programming
syntax to concatenate the string literals with the memory variable values.
For example:

  SQLVar = 'SELECT * FROM FEATURES WHERE CODE = "' + M->variable + '"'

**************************************************************************
Steve Koterski
Borland International, Inc.
http://www.borland.com/delphi
(Remove the "SPICEDHAM2" from the address. Death to spam-bots!)