>>>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!
Take cursor as OO wrapper for variables :-).
Edward Pikman
Independent Consultant