>>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

Thanks, so no matter what, you have to bring it back into a cursor? I was hoping to not have to bring it back into a cursor but rather bring it directly into the variable!