>Is there a way to select a field into a variable using SQL such as:
>
>SELECT field INTO variable FROM table WHERE field = value
>
>I am using an Oracle database connecting through odbc.

Is this a variable within Oracle or VFP. I've always done it like this.

SQLEXEC(c, [SELECT field AS value FROM table WHERE field = value], [result])
variable = result.value
USE IN result

-Mike