>>>>Hi,
>>>>
>>>>I need to update a cursor based on the values in an array. I know I can do it by scanning through the cursor or scanning through the array and checking each element. But I was wondering if there is SQL command to do it. The following are the structure and sample of the cursor and the array:
>>>>
>>>
>>>VFP has the hybrid INSERT INTO ... FROM ARRAY.
>>>
>>>Tamar
>>
>>Thank you. But in my case the cursor already exist. So, I am not sure that the INSERT INTO will work.
>
>
>CREATE CURSOR .....
>INSERT INTO ... FROM ARRAY
>INDEX ON ...
>
>SELECT SOURCE
>SET RELATION TO... INTO CURSOR
>REPLACE F1 WITH CURSOR.F1 ALL
>
>
>
>MartinaJ
I see now what can be done with the INSERT INTO ... FROM ARRAY. I will try this. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
