Hi Robin,
I only use REPLACE for cursors (I use ODBC/Informix), so my POV might be a bit different, but when using REPLACE I always take care that VFP has the correct cursor in scope via the IN clause
REPLACE myField1 WITH m.myValue1, myField2 WITH m.myValue2 IN myCursor
but as an alternative you could use the UPDATE-SQL command to update the record.
UPDATE myCursor SET myField1 = myValue1 where myIndex = myIndexValue
>Hi Thomas
>
>I'm using REPLACE to save the details.
>
>>Hi Robin,
>>
>>as you use memory vars in the form, what do you do to write those values back in the grid cursor?
>>REPLACE , GATHER or something else?
>>
>>>Hi
>>>
>>>I have a grid on my 1st form that lists jobs.
>>>
>>>When a user clicks on one of the columns I run a modal form that allows the user to edit some of the jobs details for the row selected,
>>>
>>>The modal form uses memory variables
>>>
>>>I then save the changes, and release the form, the row changes to the 1st row in my grid on the 1st form?
>>>
>>>As a test I've even changed the form I call to an empty one, it still moves the grid row to the top?
>>>,
>>>
>>>I don't get it?
>>>
>>>TAI
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011